Practice Test: Question Set - 03
1. What is an index?
- (A) A wizard
that creates a functional database structure based on the user\’s selections
- (B) A widely
recognized naming convention for database objects
- (C) A sort order
for records, which is identified in the table design
- (D) A set of
relationship rules that enforce defined database relationships
2. When you add fields in ________, a Field List pane displays.
- (A) Design View
- (B) Layout View
- (C) Print
Preview
- (D) Report View
3. Which report section only prints one time at the end of the report?
- (A) Report
Header
- (B) Page Header
- (C) Report
Footer
- (D) Page Footer
4. Which of the following statements about tab order setting is NOT true?
- (A) The actual
tab order setting for a form can be used in the Form View
- (B) The tab
order setting determines the movement of the insertion point through a form
- (C) The tab
order setting is usually right-to-left and top-to-bottom
- (D) The default
tab order setting can be altered by moving the controls in the Design View
5. Which mode sizes an image to fit the control while maintaining the proportions of the original image?
- (A) Clip
- (B) Fit
- (C) Stretch
- (D) Zoom
6. Referential integrity cannot be set for _________ relationships.
- (A) One-To-One
- (B) Indeterminate
- (C) One-To-Many
- (D) Many-To-Many
7. Which of the following statements about PivotChart View is NOT true?
- (A) It is used
to graphically summarize and analyze data in a table, query, or form
- (B) It can be
used to view different levels of detail or to specify custom layout
- (C) It displays
field values that can be switched for different views of data
- (D) It displays
the same information as a crosstab query, except for the counts and sums of
numeric fields
8. In the Field List of a table, the primary key appears __________.
- (A) Bold
- (B) Italicized
- (C) Underlined
- (D) With key
icon
9. Which is NOT a method of creating a table?
- (A) Datasheet
View
- (B) Design View
- (C) Layout View
- (D) Template
10. A(n) _________ is dynamic mathematical calculation that displays a single value for a specific field.
- (A) Format row
- (B) Criteria row
- (C) Aggregate
function
- (D) Format
layout
11. Which is not an option for Filter on a text field?
- (A) Begins With
- (B) Between
- (C) Contains
- (D) End With
12. A ________ is a major database object used to display information in an attractive, easy-to-read screen format.
- (A) Form
- (B) Query
- (C) Report
- (D) Table
13. A ________ is a major database object used to display information in a printable page format.
- (A) Form
- (B) Query
- (C) Report
- (D) Table
14. All attachment fields display as a(n) ________ in Datasheet View.
- (A) Icon
- (B) Button
- (C) Thumb tack
- (D) Paperclip
15. A DBMS that runs on many different operating systems is said to be _________.
- (A) Scalable
- (B) Robust
- (C) Platform
independent
- (D) Distributed
Next Tests: