MISY 5325 Final 1-70 Exam 2026
Questions and Answers 100% Pass
Guaranteed
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
©COPYRIGHT 2025, ALL RIGHTS RESERVE 1
, 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
©COPYRIGHT 2025, ALL RIGHTS RESERVE 2
Questions and Answers 100% Pass
Guaranteed
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
©COPYRIGHT 2025, ALL RIGHTS RESERVE 1
, 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
©COPYRIGHT 2025, ALL RIGHTS RESERVE 2
