ACCESS EXAM 3 WITH CORRECT
QUESTIONS AND ANSWERS 2025
1) From the current view (Layout view), group this report by values in the Classification
field. - CORRECT-ANSWERSIn 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-ANSWERSPIC
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-ANSWERS
, 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-ANSWERSIn 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-ANSWERS
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-ANSWERSYou 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.
QUESTIONS AND ANSWERS 2025
1) From the current view (Layout view), group this report by values in the Classification
field. - CORRECT-ANSWERSIn 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-ANSWERSPIC
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-ANSWERS
, 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-ANSWERSIn 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-ANSWERS
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-ANSWERSYou 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.
