Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. A part of database that stores complete information about an entity such as employee, sales, orders etc.
a. File
b. Record
c. Field
d. Query
Q. To create this, you enter an expression in the design grid that instructs access to perform a calculation using the current field values.
a. Formulated field
b. Numeric field
c. Formula field
d. Calculated field
Q. The ascending order of data hierarchy is?
a. Bit - byte - field - record - file - databse
b. Bit - byte - record - field - file - database
c. Byte - bit - field - record - file - database
d. Bit - byte - field - record - database - file
Q. Which of the following database object can be used if you need to mail the invoice to customers?
a. A form
b. A query
c. A report
d. A table
Q. In access, this displays the results of a calculation in a query
a. Lookup field
b. Calculated field
c. Source field
d. Child field
Q. In access, this operation copies a backup file from the storage medium back onto the computer
a. Recreate
b. Restore
c. Copy
d. Structure
Q. If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct
a. Text error
b. Validation error
c. Literal error
d. Entry error
Q. In the form wizard dialog box, the fields from the selected table are displayed in this list box.
a. All fields
b. All records
c. Available records
d. Available fields
Q. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
a. Tabular
b. Justified
c. Columnar
d. Datasheet
Q. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
a. Columnar
b. Justified
c. Datasheet
d. Tabular
Q. In Access press ALT+F11 to
a. Display the Control menu
b. Display the shortcut menu
c. Close the active window
d. Switch between the Visual Basic Editor and the previous active window
Q. In Access press to Toggle the focus forwardbetween controls in the wizard
a. TAB
b. ALT+N
c. ALT+B
d. ALT+F
Q. In Access press UP ARROW to
a. Move up one line
b. Move up one page
c. Exit the combo box or list box
d. None of these