Access Exam ACTUAL Exam Questions
and CORRECT Answers
1) From the current view (Layout view), group this report by values in the Classification field. -
CORRECT ANSWER - In the Design Ribbon Tab in the Grouping & Totals Ribbon
Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field
Name menu, you clicked the Classification menu item.
2) From Design view, modify the Gender field to use a lookup list with Male and Female in a
single column. Limit the field to values in the list only. - CORRECT ANSWER - PIC
Expand the Data Type list for the Phone Type field.
3) Add criteria to this query to return only the records where the value in the Credits field is less
than 90 and the value in the Classification field is Jr or Sr (without punctuation). Run the query
to view the results. - CORRECT ANSWER -
4)Use Filter by Selection to filter the table to show only records where the student's DOB is
10/25/1998 or later. - CORRECT ANSWER - In the Access Table, you clicked in the
10/25/1998 Cell, clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter
Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or
After "10/25/1998" menu item.
5) Use the Field List pane to add the DOB field to the form immediately to the right of the
LastName controls. Do not switch views. - CORRECT ANSWER -
13) Add criteria to this query to return only the records where the value in the DeptCode field is
ENG or CIS. Run the query to view the results. - CORRECT ANSWER - You clicked the
DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the
deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon
Tab in the Results Ribbon Group, you clicked the Run button.
14) Create a filter using the Custom Filter dialog to show only records where the value in the
CourseDescription field contains the word Foundation. - CORRECT ANSWER - In the
and CORRECT Answers
1) From the current view (Layout view), group this report by values in the Classification field. -
CORRECT ANSWER - In the Design Ribbon Tab in the Grouping & Totals Ribbon
Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field
Name menu, you clicked the Classification menu item.
2) From Design view, modify the Gender field to use a lookup list with Male and Female in a
single column. Limit the field to values in the list only. - CORRECT ANSWER - PIC
Expand the Data Type list for the Phone Type field.
3) Add criteria to this query to return only the records where the value in the Credits field is less
than 90 and the value in the Classification field is Jr or Sr (without punctuation). Run the query
to view the results. - CORRECT ANSWER -
4)Use Filter by Selection to filter the table to show only records where the student's DOB is
10/25/1998 or later. - CORRECT ANSWER - In the Access Table, you clicked in the
10/25/1998 Cell, clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter
Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or
After "10/25/1998" menu item.
5) Use the Field List pane to add the DOB field to the form immediately to the right of the
LastName controls. Do not switch views. - CORRECT ANSWER -
13) Add criteria to this query to return only the records where the value in the DeptCode field is
ENG or CIS. Run the query to view the results. - CORRECT ANSWER - You clicked the
DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the
deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon
Tab in the Results Ribbon Group, you clicked the Run button.
14) Create a filter using the Custom Filter dialog to show only records where the value in the
CourseDescription field contains the word Foundation. - CORRECT ANSWER - In the
