MISY 5325 MIDTERM
TESTED QUESTIONS AND COMPLETE SOLUTIONS
Question 1.
52. To sort records by amount paid within book rep number, specify Book Rep Number as the ———-
key.
ANSWER
Answer: major
Question 2.
56. To update records using an update query, enter the field be to updated in the design grid, enter
any necessary criterion, and then click the ——-button to update the records.
ANSWER
Run
Question 3.
68. When you sort data, duplicates are not included.
ANSWER
False
Question 4.
60. Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact
matches). T or f
ANSWER
True
Question 5.
44. To remove a total row that appears in a datasheet, click the
——-button on the HOME tab.
ANSWER
Totals
1/7
, Question 6.
61. Validation rules are rules that a user must follow when entering the data. T or f
ANSWER
True
Question 7.
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
ANSWER
False
Question 8.
37. To omit duplicates from a query, use the property sheet and change the Unique Values property to
ANSWER
Yes
Question 9.
53. To sort records in a query, specify the sort order in the row of the design grid below the field that is
the sort key.
ANSWER
Sort
Question 10.
69. You can search for a record in Form view but not in Datasheet view.
ANSWER
False
Question 11.
65. When you create a calculated field, users can update the field.t or f
ANSWER
False
2/7
TESTED QUESTIONS AND COMPLETE SOLUTIONS
Question 1.
52. To sort records by amount paid within book rep number, specify Book Rep Number as the ———-
key.
ANSWER
Answer: major
Question 2.
56. To update records using an update query, enter the field be to updated in the design grid, enter
any necessary criterion, and then click the ——-button to update the records.
ANSWER
Run
Question 3.
68. When you sort data, duplicates are not included.
ANSWER
False
Question 4.
60. Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact
matches). T or f
ANSWER
True
Question 5.
44. To remove a total row that appears in a datasheet, click the
——-button on the HOME tab.
ANSWER
Totals
1/7
, Question 6.
61. Validation rules are rules that a user must follow when entering the data. T or f
ANSWER
True
Question 7.
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
ANSWER
False
Question 8.
37. To omit duplicates from a query, use the property sheet and change the Unique Values property to
ANSWER
Yes
Question 9.
53. To sort records in a query, specify the sort order in the row of the design grid below the field that is
the sort key.
ANSWER
Sort
Question 10.
69. You can search for a record in Form view but not in Datasheet view.
ANSWER
False
Question 11.
65. When you create a calculated field, users can update the field.t or f
ANSWER
False
2/7
