MISY 5325 ACTUAL EXAM SCRIPT 2026
FULL QUESTIONS AND CORRECT ANSWERS
GRADED A+
●● 2. To compact and repair a database, tap or click ———— button in
the Info gallery in the Backstage view. Answer: Compact & Repair
●● 3. To create a crosstab, click the———— button on the CREATE
tab. Answer: crosstab, Query Wizard
●● 4. To create a lookup field, select ————- from the menu of
available data types. Answer: Lookup Wizard
●● 5. To create a multivalued field, create a ———— field being sure to
check the Allow Multiple Values check box. Answer: lookup
●● 6. To create a multivalued field, create a(n) ———field being sure to
check the Allow Multiple Values check box. Answer: lookup
●● 7. To create a new query in Design view, click CREATE on the
ribbon to display the CREATE tab and then click the ———- button to
create a new query. Answer: Query Design
, ●● 8. create a parameter query, enter a parameter rather than a specific
value as a criterion in the design grid. The parameter must be enclosed in
Answer: parameter square brackets [ ]
●● 9. To create a split form, select the table in the Navigation Pane, click
CREATE on the ribbon, click the ———— button on the CREATE tab
to display a menu, and then click Split Form on the menu. Answer: More
Forms
●● 10. To create a top-values query, use the Top Values box on the
DESIGN tab to change the number of records to be included from All to
the desired number. Answer: False
●● 11. To create a validation rule for the State field to restrict entries to
TN or TX, enter ————in the Validation Rule property box. Answer:
T
●● 12. To create an update query, create a new query and then click the
———- button on the DESIGN tab. Answer: Update
●● 13. To define an additional field in Datasheet view, tap or click the
———- column heading. Answer: Click to Add
●● 14. To define an additional field in Datasheet view, tap or click the
———— column heading, select the data type, and then type the field
name. Answer: Click to Add
FULL QUESTIONS AND CORRECT ANSWERS
GRADED A+
●● 2. To compact and repair a database, tap or click ———— button in
the Info gallery in the Backstage view. Answer: Compact & Repair
●● 3. To create a crosstab, click the———— button on the CREATE
tab. Answer: crosstab, Query Wizard
●● 4. To create a lookup field, select ————- from the menu of
available data types. Answer: Lookup Wizard
●● 5. To create a multivalued field, create a ———— field being sure to
check the Allow Multiple Values check box. Answer: lookup
●● 6. To create a multivalued field, create a(n) ———field being sure to
check the Allow Multiple Values check box. Answer: lookup
●● 7. To create a new query in Design view, click CREATE on the
ribbon to display the CREATE tab and then click the ———- button to
create a new query. Answer: Query Design
, ●● 8. create a parameter query, enter a parameter rather than a specific
value as a criterion in the design grid. The parameter must be enclosed in
Answer: parameter square brackets [ ]
●● 9. To create a split form, select the table in the Navigation Pane, click
CREATE on the ribbon, click the ———— button on the CREATE tab
to display a menu, and then click Split Form on the menu. Answer: More
Forms
●● 10. To create a top-values query, use the Top Values box on the
DESIGN tab to change the number of records to be included from All to
the desired number. Answer: False
●● 11. To create a validation rule for the State field to restrict entries to
TN or TX, enter ————in the Validation Rule property box. Answer:
T
●● 12. To create an update query, create a new query and then click the
———- button on the DESIGN tab. Answer: Update
●● 13. To define an additional field in Datasheet view, tap or click the
———- column heading. Answer: Click to Add
●● 14. To define an additional field in Datasheet view, tap or click the
———— column heading, select the data type, and then type the field
name. Answer: Click to Add
