Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Changing the order of this in the query datasheet does not affect the field order in the table.
a. Record
b. Row
c. Column
d. Sort
Q. In the second subform wizard dialog box you specify the table to use as the data source and the
a. Records from the selected form
b. Form from the selected table
c. Fields from the selected table
d. Content from the selected form
Q. This is not one of the sections of the form design window
a. Form footer
b. Form content
c. Form header
d. Form detail
Q. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
a. Text
b. Form
c. Label
d. Field
Q. In access, this view is used to create and modify the structure of a form.
a. Normal
b. Datasheet
c. Form design
d. Control
Q. To set a password for the database, select ____________ in the Microsoft Access open window.
a. Open read only
b. Open write only
c. Open explicit
d. Open exclusive
Q. To enter the input mask wizard
a. Click on the three dots to the right of the caption entry field
b. Click on the three dots to the right of the format entry field
c. Click on the input mask toolbar
d. Click on the three dots to the right of the input mask entry field
Q. Saving a database in access is done
a. At the beginning of the database
b. The first time you save data
c. When closing the application
d. During auto save
Q. Which of the following best describes the grouped report?
a. A part of report that can be generated by the report wizard
b. A report that displays data that has been sorted in ascending or descending order
c. A report that displays data grouped by fields you specify
d. None of a the above
Q. What is the use of description field in table design window?
a. The description will be displayed on status bar when entering data in datasheet view
b. The description will be displayed on status bar when entering data in form
c. Both of above
d. None of a the above
Q. How can you display the related records from other tables in datasheet view?
a. Click on the expand indicator next to the record
b. Double click on the record to expand it
c. Apply filter by command to display related records
d. All of above
Q. Which of the following query type is best suitable to analyze data?
a. Cross tab queries
b. Parameter queries
c. Action queries
d. None of above
Q. Which of the following is a database management system?
a. Ms word
b. Ms excel
c. Oracle
d. Lotus 1-2-3