MISY 5325 FINAL EXAM WITH ALL CORRECT &
VERIFIED ANSWERS/2025 LATEST
1. To combine criteria with ———— place the criteria on the same row. Correct answer-AND
2. To compact and repair a database, tap or click ———— button in the Info gallery in the Backstage
view. Correct answer-Compact & Repair
3. To create a crosstab, click the———— button on the CREATE tab. Correct answer-crosstab,
Query Wizard
4. To create a lookup field, select ————- from the menu of available data types. Correct answer-
Lookup Wizard
5. To create a multivalued field, create a ———— field being sure to check the Allow Multiple Values
check box. Correct answer-lookup
6. To create a multivalued field, create a(n) ———field being sure to check the Allow Multiple Values
check box. Correct 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. Correct 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 Correct 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.
Correct 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. Correct 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. Correct answer-T
12. To create an update query, create a new query and then click the ———- button on the DESIGN
tab. Correct answer-Update
13. To define an additional field in Datasheet view, tap or click the ———- column heading. Correct
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. Correct 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. Correct 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. Correct 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. Correct 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 Correct answer-False
19. To delete a record, tap or click the record selector for the record, and then press the key(s).
Correct answer-DELETE
20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf Correct
answer-False
21. To enter a number in a criterion, type the number without any dollar signs or commas.t or f
Correct answer-True
22. To export data from a query to Excel, select the query in the Navigation Pane, click ———-on the
ribbon, and then click the Excel button. Correct answer-EXTERNAL DATA
23. To filter records using complex criteria, click the ———-button on the HOME tab and then click
Advanced Filter/Sort on the menu that appears. Correct answer-Advanced
24. To find all accounts whose current due amounts are greater than $2,500.00 and whose account
manager is manager 31, enter each criterion on the same row. Torf Correct answer-True
25. To find duplicate records in a table, use the ———Query Wizard. Correct answer-Find
Duplicates
26. To find the largest amount paid amount for a client, select ———-as the entry in the Total row for
the Amount Paid column. Correct answer-MAX
27. To include all fields for a table in the design grid, double-click the ———in the field list. Correct
answer-asterisk (*)
28. To include all fields in the design grid, double-click the question mark (?) in the field list. T or f
Correct answer-False
29. To include calculated fields in queries, enter a name for the calculated field, a(n) ——-and then
the expression in one of the columns in the Field row. Correct answer-colon (:)
30. To include the Total row in the design grid, click the button on the DESIGN tab. Correct answer-
Totals
31. To include totals and other statistics at the bottom of a datasheet, click the ———-button on the
HOME tab to include the Total row in the datasheet. Correct answer-Totals
32. To indicate grouping in Access, select ————as the entry in the Total row for the field to be
used for grouping. Correct answer-Group By
33. To insert a field between existing fields, for the field that will follow the new field, and then tap or
click ———on the shortcut press and hold or right-click the column heading menu. Correct
answer-Insert Field
VERIFIED ANSWERS/2025 LATEST
1. To combine criteria with ———— place the criteria on the same row. Correct answer-AND
2. To compact and repair a database, tap or click ———— button in the Info gallery in the Backstage
view. Correct answer-Compact & Repair
3. To create a crosstab, click the———— button on the CREATE tab. Correct answer-crosstab,
Query Wizard
4. To create a lookup field, select ————- from the menu of available data types. Correct answer-
Lookup Wizard
5. To create a multivalued field, create a ———— field being sure to check the Allow Multiple Values
check box. Correct answer-lookup
6. To create a multivalued field, create a(n) ———field being sure to check the Allow Multiple Values
check box. Correct 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. Correct 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 Correct 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.
Correct 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. Correct 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. Correct answer-T
12. To create an update query, create a new query and then click the ———- button on the DESIGN
tab. Correct answer-Update
13. To define an additional field in Datasheet view, tap or click the ———- column heading. Correct
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. Correct 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. Correct 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. Correct 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. Correct 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 Correct answer-False
19. To delete a record, tap or click the record selector for the record, and then press the key(s).
Correct answer-DELETE
20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf Correct
answer-False
21. To enter a number in a criterion, type the number without any dollar signs or commas.t or f
Correct answer-True
22. To export data from a query to Excel, select the query in the Navigation Pane, click ———-on the
ribbon, and then click the Excel button. Correct answer-EXTERNAL DATA
23. To filter records using complex criteria, click the ———-button on the HOME tab and then click
Advanced Filter/Sort on the menu that appears. Correct answer-Advanced
24. To find all accounts whose current due amounts are greater than $2,500.00 and whose account
manager is manager 31, enter each criterion on the same row. Torf Correct answer-True
25. To find duplicate records in a table, use the ———Query Wizard. Correct answer-Find
Duplicates
26. To find the largest amount paid amount for a client, select ———-as the entry in the Total row for
the Amount Paid column. Correct answer-MAX
27. To include all fields for a table in the design grid, double-click the ———in the field list. Correct
answer-asterisk (*)
28. To include all fields in the design grid, double-click the question mark (?) in the field list. T or f
Correct answer-False
29. To include calculated fields in queries, enter a name for the calculated field, a(n) ——-and then
the expression in one of the columns in the Field row. Correct answer-colon (:)
30. To include the Total row in the design grid, click the button on the DESIGN tab. Correct answer-
Totals
31. To include totals and other statistics at the bottom of a datasheet, click the ———-button on the
HOME tab to include the Total row in the datasheet. Correct answer-Totals
32. To indicate grouping in Access, select ————as the entry in the Total row for the field to be
used for grouping. Correct answer-Group By
33. To insert a field between existing fields, for the field that will follow the new field, and then tap or
click ———on the shortcut press and hold or right-click the column heading menu. Correct
answer-Insert Field
