MISY 5325 Final Exam | 70 Questions with 100% Correct Answers | Verified | Latest Update | 2025/2026

MISY 5325 Final Exam | 70 Questions with 100% Correct Answers | Verified | Latest Update | 2025/2026 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. - answerMore 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. - answerClick 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