MISY 5325 Final EXAM NEWEST 2026 WITH COMPLETE QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
VERSION!!
1. To combine criteria with ———— place the criteria on the same row. - (answer)AND
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
, MISY 5325 Final EXAM NEWEST 2026 WITH COMPLETE QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
VERSION!!
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
15. To delete a database object, press and hold or right-click the object in the Navigation Pane and then
tap or click ———- on the shortcut menu. - (answer)Delete
16. To delete a field from a table, open the table in ———- view, click the row selector for the field to be
deleted, and then press the DELETE key. - (answer)Answer: Design
17. To delete a field in a table, press and hold or right-click the column heading for the field, and then
tap or click ————-on the shortcut menu. - (answer)Delete Field
18. To delete a field, press and hold or right-click the column heading for the field, and then tap or click
Remove Field on the shortcut menu. T/F - (answer)False
19. To delete a record, tap or click the record selector for the record, and then press the key(s). -
(answer)DELETE
20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf - (answer)False
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
VERSION!!
1. To combine criteria with ———— place the criteria on the same row. - (answer)AND
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
, MISY 5325 Final EXAM NEWEST 2026 WITH COMPLETE QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
VERSION!!
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
15. To delete a database object, press and hold or right-click the object in the Navigation Pane and then
tap or click ———- on the shortcut menu. - (answer)Delete
16. To delete a field from a table, open the table in ———- view, click the row selector for the field to be
deleted, and then press the DELETE key. - (answer)Answer: Design
17. To delete a field in a table, press and hold or right-click the column heading for the field, and then
tap or click ————-on the shortcut menu. - (answer)Delete Field
18. To delete a field, press and hold or right-click the column heading for the field, and then tap or click
Remove Field on the shortcut menu. T/F - (answer)False
19. To delete a record, tap or click the record selector for the record, and then press the key(s). -
(answer)DELETE
20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf - (answer)False
