Microsoft Access MCQ Questions and Answers - Set 03 - ObjectiveBooks

Microsoft Access MCQ Questions and Answers - Set 03

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: