MISY 5325 FINAL 1-70 QUESTIONS AND ANSWERS
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. - 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 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
20. To display the Total row in a datasheet, click the Sum button on the ribbon. Torf - Answer- False
21. To enter a number in a criterion, type the number without any dollar signs or commas.t or f - 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. - 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. - 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 - Answer- True
25. To find duplicate records in a table, use the ———Query Wizard. - 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. - Answer- MAX
27. To include all fields for a table in the design grid, double-click the ———in the field list. - Answer- asterisk (*)
28. To include all fields in the design grid, double-click the question mark (?) in the field list. T or f - 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. - Answer- colon (:)