MS Access MCQ Questions and solutions with explanations | MS Office

A. scalability

B. expandability

C. maintainability

D. platform-independence

A. Design view

B. Crosstab query wizard

C. Simple query wizard

D. Datasheet view

A. A calculated field does not store data in a recordset.

B. Calculated fields use an expression or formula as its data source.

C. Data contained in a calculated field is created the first time a query is run.

D. A calculated field can be created using the Expression Builder dialog box.

A. Selecting the fields that you want to appear in the form or report

B. Selecting the underlying table or query on which you want to base the form or report

C. Reading several screens of mostly useless information and clicking next

D. Selecting how the form or report should be formatted

A. Move up one line

B. Move up one page

C. Exit the combo box or list box

D. None of these

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. All of above

A. Form

B. Form Wizard

C. Multiple Item Form

D. Split Form

A. select

B. summary

C. parameter

D. action

A. Table

B. Field

C. Record

D. Character

A. Typing Queries in SQL View

B. Drag and Drop fields on Query Builder

C. Using Query Wizard

D. All of the Above