Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.
a. Report
b. Table
c. Query
d. Tools
Q. In Access press…………………….to Movethe selected control to the left (except controls that are part of a layout)
a. CTRL+C
b. CTRL+X
c. CTRL+V
d. None of these
Q. In Access press …………………….to Move the selected control to the right (except controls that are part of a layout)
a. CTRL+C
b. CTRL+X
c. CTRL+V
d. None of these
Q. In Access press …………………….to Paste the contents of the Clipboard in the upper- left corner of the selected section
a. CTRL+C
b. CTRL+X
c. CTRL+V
d. None of these
Q. In Access press …………………….to Cut the selected control and copy it to the Clipboard
a. CTRL+C
b. CTRL+X
c. CTRL+V
d. None of these
Q. In Access press …………………….to Copy the selected control to the Clipboard
a. CTRL+C
b. CTRL+X
c. CTRL+V
d. None of these
Q. In Access press RIGHT ARROW or CTRL+RIGHT ARROW
a. Move the selected control to the right (except controls that are part of a layout)
b. Move the selected control to the left (except controls that are part of a layout)
c. Move the selected control up
d. None of these
Q. In Access press LEFT ARROW or CTRL+LEFT ARROW
a. Move the selected control to the right (except controls that are part of a layout)
b. Move the selected control to the left (except controls that are part of a layout)
c. Move the selected control up
d. None of these
Q. In Access press ALT+F11 to
a. Display the Control menu
b. Display the shortcut menu
c. Close the active window
d. None of these
Q. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
a. By setting required to ‘Yes’
b. By using default value
c. By defining validation rule
d. By using format
Q. In an application created using the database wizard, the main menu is presented as a:
a. form, called a switchboard
b. report, called a menu
c. table, called a switchboard
d. query, called a menu
Q. Which leads you through the process of creating a table?
a. wizard
b. assistant
c. relation
d. coach
Q. Which data type is better to use for storing the price of an item?
a. Text
b. AutoNumber
c. Number
d. Currency
Q. Which do you click to display the table\'s primary key and indexes in a separate window?
a. indexes button
b. primary key button
c. view datasheet button
d. view design button