Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
a. Design View
b. Datasheet View
c. Office View
d. Print Preview
Q. What is the keyboard shortcut to move to the last records in a table?
a. [Tab]
b. [Shift]+[Tab]
c. [Ctrl]+Home]
d. [Ctrl]+[End]
Q. 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
Q. Print options can be changed in the Print ____.
a. tab
b. layout mode
c. setup routine
d. dialog box
Q. Access file operations can be found by clicking the ____.
a. Access Button
b. Database Button
c. Office Button
d. Window Button
Q. A ____ is a major database object used to display information in a printable page format.
a. form
b. query
c. report
d. table
Q. In Datasheet View, new records are added to a table ____.
a. in alphabetical order
b. at the end of the table
c. at the beginning of the table
d. in numerical order
Q. What happens when a user selects a record in a form and presses [Delete]?
a. The record is deleted in the form and from its source table.
b. The record is deleted in the form, but not from its source table.
c. The record is neither deleted in the form, nor from its source table.
d. The record is not deleted in the form, but is deleted from its source table.
Q. What is one of the advantages for using a form over other Access objects?
a. Utilizes field placement to improve the efficiency of data entry.
b. Forms store information more efficiently.
c. Forms show the summary of all the records.
d. Forms cannot be edite
Q. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
a. Press [Ctrl]+[C] and [Ctrl]+[V].
b. Right-click, choose from the shortcut menu Copy and Paste.
c. Press [Ctrl]+[+] and [Ctrl]+[-].
d. From the ribbon, select Copy and Paste.
Q. A(n) ____ in the Record Selector indicates a new record.
a. check mark
b. pencil
c. asterisk
d. arrow
Q. All attachment fields display as a(n) ____ in Datasheet View.
a. icon
b. button
c. thumb tack
d. paperclip