MS - ACCESS Important Questions and Answers Set - 3
1. Which of the following is NOT a report section ?
A. Report Header section
B. Summary section
C. Page header section
D. Details section
Ans- B. Summary section
2. You can display a database object in design view by
A. Opening the database object and clicking the view button on toolbar
B. Selecting the database object and clicking the design button on the
database window
C. Selecting the database object and press Ctrl + V
D. Opening the database object and selecting Tools > Design view
Ans- B. Selecting the database object and clicking the design button on
the database window
3. How can you display the relationship in a database ?
A. Select view > Relationship form the menu
B. Click the Relationship button on the toolbar
C. Select Edit > Relationship from the menu
D. All the above are true
Ans- B. Click the Relationship button on the toolbar
4. If you are creating a cross tab query , what must table you are querying
contain ?
A. Lots of confusing information
B. More than 100 records
C. At least one field
D. None of the above
Ans- C. At least one field
5. A query summarizes information in a grid , organized by regions and
months . Which type of query is this ?
A. A cross tab query
B. An update query
C. A parameter query
D. An action query
Ans- A. A cross tab query
6. What type of text box does the toolbox and to a form ?
A. Unbound
B. Bound
C. Rebound
D. Calculated
Ans- A. Unbound
7. The filter by selection feature allows you to filter
A. Those records that match an entity in a field
B. Records based on a criterion you specify
C. Records that meet any of several criteria you specify
D. All of above
Ans- A. Those records that match an entity in a field
8. What is the memo data type field used for ?
A. To add table
B. To store objects created in other programs
C. For long text entries
D. For short text entries of no more than 255 characters
Ans- C. For long text entries
9. What is the purpose of the description column in Table Design View ?
A. To define the data type applied to each field within the table
B. To describe the data that should be entered in each field
C. To enter lookup data that field should refer to
D. None of the above
Ans- B. To describe the data that should be entered in each field
10. What is the purpose to a sub datasheet ?
A. To provide a hierarchical view of related tables or queries in a single
window
B. To display grouped data in a report
C. To display summarized data
D. All of the above
Ans- A. To provide a hierarchical view of related tables or queries in a
single window
