Microsoft Access 2003- Working With Forms And Reports
30 Questions
| Attempts: 150
MCS- Students
Questions and Answers
- 1.
This type of control is very useful when viewing records based on two tables with a one-to-many-relationship.
Correct Answer
Subform
subforms - 2.
This type of control can be bound to a Yes/No field. It can also added to an option group.
Correct Answer
Toggle Button - 3.
This often to decorate the form to make it look better and to make the records more readable.
Correct Answer
Unbound - 4.
These are simple graphic element that you can draw on a form to add as decoration.
Correct Answer
Lines and Rectangles
Lines and Rectangle - 5.
It works like a combo box, but it displayed differently. Records are displayed one at a time.
Correct Answer
List Box - 6.
It performs an action or set of action when these button are clicked.
Correct Answer
Command Button - 7.
It is used to toggle an option, on or off. It is usually bound to a Yes/No field in the table.
Correct Answer
Check Box - 8.
It is used to start a new screen on a form, a new page on a printed form, or a new page of a report.
Correct Answer
Page Break - 9.
It is used to separate the pages on a form.
Correct Answer
Tab Control - 10.
It is used to provide a limited set of alternatives on a form. It includes values can use, which can be selected by just clicking on them.
Correct Answer
Option Group - 11.
It is used to display images or pictures on a form or report.
Correct Answer
Image
Add Image
Insert Picture
Insert Image - 12.
It is used on a form to provide descriptive text for text boxes, buttons, frames, titles, or instruction.
Correct Answer
Labels
Label - 13.
It is one that linked to a table or query.
Correct Answer
Bound - 14.
It also bound and unbound to an underlying record source. It is used to provide users with a list of values, that can either be bound to a field in the table, or unbound which stores values not tied in with any of the tables.
Correct Answer
Combo Box - 15.
A bound text box displays records from an underlying table or query. it is used also to display the result of a computation.
Correct Answer
Text Box
Textbox - 16.
This option allows you to build a new table by entering data directly into the datasheet.
- A.
Datasheet view
- B.
Design view
- C.
Link table
Correct Answer
A. Datasheet view -
- 17.
They key uniquely identifies each record in a table.
- A.
Primary key
- B.
Key word
- C.
Filed name
Correct Answer
A. Primary key -
- 18.
This data type allows alphanumeric characters and special symbols.
- A.
Text
- B.
Memo
- C.
Auto number
Correct Answer
A. Text -
- 19.
Unlike text data type, this can store up to maximum of 65, 535 characters.
- A.
Memo
- B.
Data/time
- C.
Number
Correct Answer
A. Memo -
- 20.
This data type stores data and time values from the year 100 through 9999.
Correct Answer
date
time
date/time - 21.
It is a database object to view, change, and analyze data in different ways.
- A.
Query
- B.
Form
- C.
Report
Correct Answer
A. Query -
- 22.
It is most common type of query. It retrieves records from one or more tables and then displays the results in the order you want.
- A.
Parameter
- B.
Select
- C.
Crosstab
Correct Answer
B. Select -
- 23.
It is a query that when run displays its own dialog box prompting you for information, such as criteria for retrieving records or a value you want to insert in a field.
- A.
Parameter
- B.
Select
- C.
Crosstab
Correct Answer
A. Parameter -
- 24.
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum, average, count, or type of total for data that is grouped by two types of information- one down the left side of the data sheet and another across the top.
- A.
Parameter
- B.
Select
- C.
Crosstab
Correct Answer
C. Crosstab -
- 25.
It is a sign or symbol that specifies, operator, and values that produce a result.
- A.
Operator
- B.
Query
- C.
Expression
Correct Answer
A. Operator -
- 26.
It is a sign or a symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison. Logical and reference operators.
- A.
Operator
- B.
Query
- C.
Expression
Correct Answer
A. Operator -
- 27.
These are values such as number, character, or date, which access evaluates exactly as written. “Carl”, 256.80, and # 26-Dec-02# or ’26-dec-02’ are examples of literals values.
- A.
Constant
- B.
Text string
- C.
Literal value
Correct Answer
C. Literal value -
- 28.
These are element in an expression with values that do not change.
- A.
Constants
- B.
Text string
- C.
Date
Correct Answer
A. Constants -
- 29.
These values in an expression that are identified by number signs (#) or sign (‘) quotation mark around the element.
- A.
Constants
- B.
Text string
- C.
Date
Correct Answer
C. Date -
- 30.
What character must you place beside a field if it is used in an expression?
Correct Answer
Bracket
[ ]
[
]
symbols
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2022Quiz Edited by
ProProfs Editorial Team -
Oct 11, 2010Quiz Created by
Johnwyne
Back to top