MISY 5325 Final 1-70 Questions and Answers New (2024/2025) Solved 100% Correct

MISY 5325 Final 1-70
1. 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 [ ]

2. 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

3. To create a crosstab, click the———— button on the CREATE tab. - ✔️✔️crosstab,
Query Wizard

4. 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 -
✔️✔️True

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. To combine criteria with ———— place the criteria on the same row. - ✔️✔️AND

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 compact and repair a database, tap or click ———— button in the Info gallery in
the Backstage view. - ✔️✔️Compact & Repair


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 enter a number in a criterion, type the number without any dollar signs or
commas.t or f - ✔️✔️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. - ✔️✔️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. - ✔️✔️Advanced

24. To create a lookup field, select ————- from the menu of available data types. -
✔️✔️Lookup Wizard

25. To find duplicate records in a table, use the ———Query Wizard. - ✔️✔️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. - ✔️✔️MAX