CGS2100 Access Exam UPDATED Exam
Questions and CORRECT Answers
Enable active content in this database. - CORRECT ANSWER - You clicked the Enable
Content button.
Preview how the results of this table will look when printed. Change the preview options to show
two pages at once. - CORRECT ANSWER - You opened the backstage view, clicked the
Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in
the Zoom Ribbon Group, you clicked the Two Pages button.
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.
Create a Split form from the Classes table. - CORRECT ANSWER - In the Create Ribbon
Tab in the Forms Ribbon Group, you clicked the More Forms button. In the More Forms menu,
you clicked the Split Form menu item.
Use Filter by Selection to filter the table to show only records where the student's DOB is
10/25/2006 or later. - CORRECT ANSWER - In the Access Table, you clicked in the
10/25/2006 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/2006" menu item.
Add a new calculated field named Tuition in the first empty column to the right of the Credits
field. The new field should calculate the value in the Credits field multiplied by 150. Run the
query to view the results. - CORRECT ANSWER - You right-clicked the Drop-Down
Menu. In the Right-Click menu, you clicked the Zoom... menu item. Inside the Zoom dialog, you
typed Tuition:[Credits]*150 in the Zoom Value Input input, clicked the Query Zoom Ok Button
button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
, Preview how the results of this query will look when printed. - CORRECT ANSWER -
You opened the backstage view, clicked the Print navigation button, and clicked the Print
Preview button.
From the current view (Design view) - CORRECT ANSWER - set the Default Value
property for the Classification field to Fr.,In the Access Table, you clicked the Default Value
property box, typed Fr in the Default Value property box, and pressed the Enter key.
Preview how this report will look when printed and show two pages at once. - CORRECT
ANSWER - You opened the backstage view, clicked the Print navigation button, and
clicked the Print Preview button. In the Print Preview Ribbon Tab in the Zoom Ribbon Group,
you clicked the Two Pages button.
Apply the Short Date input mask format to the selected field (StartDate). Do not change default
format or placeholder characters. - CORRECT ANSWER - In the Access Table, you
clicked the Input Mask property box, clicked the Input Mask Build... Button. Inside the Input
Mask Wizard dialog from the Input Mask list, you selected Short Date. Inside the Input Mask
Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish
button.
Go to the last record. - CORRECT ANSWER - You clicked the Last Record Button.
Modify this query to show only students who are freshmen. Add criteria to the Classification
field to return only records where the classification is Fr. Run the query. - CORRECT
ANSWER - You clicked the Classification field's criteria row, changed the Classification
field's criteria to Fr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run
button.
Add a new record to the table with the student ID 6412 and advance to the second field. -
CORRECT ANSWER - In the Home Ribbon Tab in the Records Ribbon Group, you
clicked the New button. In the Access Table, you typed 6412, pressed Tab.
Use AutoFilter to filter the query results to show only records where the value in the Department
field is Economics. - CORRECT ANSWER - In the Access Table, you clicked the arrow at
Questions and CORRECT Answers
Enable active content in this database. - CORRECT ANSWER - You clicked the Enable
Content button.
Preview how the results of this table will look when printed. Change the preview options to show
two pages at once. - CORRECT ANSWER - You opened the backstage view, clicked the
Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in
the Zoom Ribbon Group, you clicked the Two Pages button.
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.
Create a Split form from the Classes table. - CORRECT ANSWER - In the Create Ribbon
Tab in the Forms Ribbon Group, you clicked the More Forms button. In the More Forms menu,
you clicked the Split Form menu item.
Use Filter by Selection to filter the table to show only records where the student's DOB is
10/25/2006 or later. - CORRECT ANSWER - In the Access Table, you clicked in the
10/25/2006 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/2006" menu item.
Add a new calculated field named Tuition in the first empty column to the right of the Credits
field. The new field should calculate the value in the Credits field multiplied by 150. Run the
query to view the results. - CORRECT ANSWER - You right-clicked the Drop-Down
Menu. In the Right-Click menu, you clicked the Zoom... menu item. Inside the Zoom dialog, you
typed Tuition:[Credits]*150 in the Zoom Value Input input, clicked the Query Zoom Ok Button
button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.
, Preview how the results of this query will look when printed. - CORRECT ANSWER -
You opened the backstage view, clicked the Print navigation button, and clicked the Print
Preview button.
From the current view (Design view) - CORRECT ANSWER - set the Default Value
property for the Classification field to Fr.,In the Access Table, you clicked the Default Value
property box, typed Fr in the Default Value property box, and pressed the Enter key.
Preview how this report will look when printed and show two pages at once. - CORRECT
ANSWER - You opened the backstage view, clicked the Print navigation button, and
clicked the Print Preview button. In the Print Preview Ribbon Tab in the Zoom Ribbon Group,
you clicked the Two Pages button.
Apply the Short Date input mask format to the selected field (StartDate). Do not change default
format or placeholder characters. - CORRECT ANSWER - In the Access Table, you
clicked the Input Mask property box, clicked the Input Mask Build... Button. Inside the Input
Mask Wizard dialog from the Input Mask list, you selected Short Date. Inside the Input Mask
Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish
button.
Go to the last record. - CORRECT ANSWER - You clicked the Last Record Button.
Modify this query to show only students who are freshmen. Add criteria to the Classification
field to return only records where the classification is Fr. Run the query. - CORRECT
ANSWER - You clicked the Classification field's criteria row, changed the Classification
field's criteria to Fr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run
button.
Add a new record to the table with the student ID 6412 and advance to the second field. -
CORRECT ANSWER - In the Home Ribbon Tab in the Records Ribbon Group, you
clicked the New button. In the Access Table, you typed 6412, pressed Tab.
Use AutoFilter to filter the query results to show only records where the value in the Department
field is Economics. - CORRECT ANSWER - In the Access Table, you clicked the arrow at
