MISY 5325 Final Exam Questions With Verified Answers

MISY 532 5 Final Exam Q uestions W ith Verified A nswers 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 di splay 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 15. To delete a database object, press and hold or right-click the object in th e 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 Fals e 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 rib bon. Torf - ANSWER False 21. To enter a number in a criterion, type the number without any dollar s igns or