MS Access MCQ Questions and solutions with explanations | MS Office

A. address = "K"

B. address = "K*"

C. address = "K?"

D. address = "K#"

A. Table

B. Form

C. Report

D. Query

A. Case

B. IF

C. IIF

D. IsTrue

A. File

B. Record

C. Field

D. Query

A. Hold down the Shift key as you click each object that you want to select

B. If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls

C. Hold down the Ctrl key as you click each object that you want to select

D. All of these above are true

A. You need to delete the whole tablThere is no method to remove a particular field only.

B. Delete all the fields from third downwards and reenter the required fields again.

C. Select the third column in datasheet view then Delete

D. Select the third row in table design view then Delete

A. A wizard that creates a functional database structure based on the user's selections

B. A widely recognized naming convention for database objects

C. A sort order for records, which is identified in the table design

D. A set of relationship rules that enforce defined database relationships

A. Report Header section

B. Summary section

C. Page header section

D. Details section

A. A relationship is created

B. Edit relationship dialog box appears

C. Error occurs

D. Nothing happens

A. Indicate Primary Key

B. Indicate Current Row

C. Both of above

D. None of above