Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. This option allows you to build a new table by entering data directly into the datasheet.
a. datasheet view
b. design view
c. link table
d. None of the above
Q. To create queries in Access
a. You can drag and drop fields on query builders
b. you can type the SQL command in SQL view
c. You can use query wizard or design view
d. All of above
Q. Following is not a database model
a. network database model
b. relational database model
c. Object Oriented database model
d. None
Q. Which of the following is NOT a type of Microsoft Access database object?
a. Table
b. Form
c. Worksheets
d. Modules
Q. Which is not a view to display a table in Access?
a. Datasheet View
b. Design View
c. Pivot Table & Pivot Chart View
d. None of above
Q. The__ button on the tool box display data from a related table
a. Sub form sub report
b. Relationships
c. Select objects
d. More controls
Q. The expression builder is an access tool that controls an expression___ for entering an expression
a. Table
b. Box
c. Cell
d. Palette
Q. A __________ enables you to view data from a table based on a specific criterion
a. Form
b. Query
c. Macro
d. Report
Q. Which of the following database object produces the final result to present?
a. Forms
b. Reports
c. Queries
d. Tables
Q. The default and maximum size of text field in Access
a. 50 and 255 Characters
b. 8 and 1 GB
c. 266 characters & 64000 characters
d. None of above
Q. Cascade update option
a. means do not change the value in the primary key field if that record has related records in another table
b. means change all the related records in child tables if the record in parent table is changed
c. Both of above
d. None of above
Q. You can set a controls border type to make the border invisible.
a. Transparent
b. Invisible
c. Do not display
d. No border