MISY 5325 EVALUATION TEST QUESTIONS AND
ANSWERS SET A+
✔✔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 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
✔✔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
✔✔27. To include all fields for a table in the design grid, double-click the ———in the
field list. - ✔✔asterisk (*)
✔✔28. To include all fields in the design grid, double-click the question mark (?) in the
field list. T or f - ✔✔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. - ✔✔colon (:)
, ✔✔30. To include the Total row in the design grid, click the button on the DESIGN tab. -
✔✔Totals
✔✔31. To include totals and other statistics at the bottom of a datasheet, click the ——
—-button on the HOME tab to include the Total row in the datasheet. - ✔✔Totals
✔✔32. To indicate grouping in Access, select ————as the entry in the Total row for
the field to be used for grouping. - ✔✔Group By
✔✔33. To insert a field between existing fields, for the field that will follow the new field,
and then tap or click ———on the shortcut press and hold or right-click the column
heading menu. - ✔✔Insert Field
✔✔34. To insert a field between existing fields, press and hold or right-click the column
heading for the field that will follow the new field, and then tap or click on the shortcut
menu. - ✔✔Insert Field
✔✔35. To insert a field between existing fields, press and hold or right-click the column
heading for the field that will follow the new field, and then tap or click Insert Column the
shortcut menu. T or f - ✔✔False
✔✔36. To move from Layout view to Form view, click the button on the Access status
bar. - ✔✔Form View
✔✔37. To omit duplicates from a query, use the property sheet and change the Unique
Values property to - ✔✔Yes
✔✔38. To open a form in Form view fron the Navigation Pane, right-click the form and
click Form View on the shortcut menu. - ✔✔False
✔✔39. To open the Navigation Pane, tap or click the ——-Button. - ✔✔Shutter Bar
Open/Close
✔✔40. To order the records in the Account table by city in alphabetical order, use the —
—-button. - ✔✔Ascending
✔✔41. To order the records in the answer to a query in a particular way, you ——-the
records. - ✔✔sort
✔✔42. To organize entries in the Navigation Pane by table, click ———on the
Navigation Pane menu. - ✔✔Tables and Related Views
ANSWERS SET A+
✔✔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 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
✔✔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
✔✔27. To include all fields for a table in the design grid, double-click the ———in the
field list. - ✔✔asterisk (*)
✔✔28. To include all fields in the design grid, double-click the question mark (?) in the
field list. T or f - ✔✔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. - ✔✔colon (:)
, ✔✔30. To include the Total row in the design grid, click the button on the DESIGN tab. -
✔✔Totals
✔✔31. To include totals and other statistics at the bottom of a datasheet, click the ——
—-button on the HOME tab to include the Total row in the datasheet. - ✔✔Totals
✔✔32. To indicate grouping in Access, select ————as the entry in the Total row for
the field to be used for grouping. - ✔✔Group By
✔✔33. To insert a field between existing fields, for the field that will follow the new field,
and then tap or click ———on the shortcut press and hold or right-click the column
heading menu. - ✔✔Insert Field
✔✔34. To insert a field between existing fields, press and hold or right-click the column
heading for the field that will follow the new field, and then tap or click on the shortcut
menu. - ✔✔Insert Field
✔✔35. To insert a field between existing fields, press and hold or right-click the column
heading for the field that will follow the new field, and then tap or click Insert Column the
shortcut menu. T or f - ✔✔False
✔✔36. To move from Layout view to Form view, click the button on the Access status
bar. - ✔✔Form View
✔✔37. To omit duplicates from a query, use the property sheet and change the Unique
Values property to - ✔✔Yes
✔✔38. To open a form in Form view fron the Navigation Pane, right-click the form and
click Form View on the shortcut menu. - ✔✔False
✔✔39. To open the Navigation Pane, tap or click the ——-Button. - ✔✔Shutter Bar
Open/Close
✔✔40. To order the records in the Account table by city in alphabetical order, use the —
—-button. - ✔✔Ascending
✔✔41. To order the records in the answer to a query in a particular way, you ——-the
records. - ✔✔sort
✔✔42. To organize entries in the Navigation Pane by table, click ———on the
Navigation Pane menu. - ✔✔Tables and Related Views
