MISY 5325 Final 1-70 | latest with complete solution

MISY 5325 Final 1-70 | latest with complete solution 1. To combine criteria with ———— place the criteria on the same row. - AND 2. To compact and repair a database, tap or click ———— button in the Info gallery in the Backstage view. - Compact & Repair 3. To create a crosstab, click the———— button on the CREATE tab. - crosstab, Query Wizard 4. To create a lookup field, select ————- from the menu of available data types. - Lookup Wizard 5. To create a multivalued field, create a ———— field being sure to check the Allow Multiple Values check box. - lookup 6. To create a multivalued field, create a(n) ———field being sure to check the Allow Multiple Values check box. - 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. - 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 - 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. - 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. - 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. - T 12. To create an update query, create a new query and then click the ———- button on the DESIGN tab. - Update 13. To define an additional field in Datasheet view, tap or click the ———- column heading. - 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. - 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. - 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: 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. - 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 - False 19. To delete a record, tap or click the record selector for the record, and then press the key(s). - DELETE 20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf - False 21. To ente