CGS ACCESS COMPREHENSIVE EXAM QUESTIONS WITH
DETAILED VERIFIED AND 100% ACCURATE ANSWERS
BRAND NEW EXAM ALREADY GRADED A+ PASS
From Design view, add a subreport control to the bottom of the Detail
section of this report. Base the subreport on the "CurrentHousing"
report. Use the "ID" field to link the report and subreport. Finish the
subreport without changing the subreport name. Ans✓✓✓On the Report
Design Tools Design tab, in the Controls group, click the
"Subform/Subreport" button. If the controls gallery is not visible on the
ribbon, click the "Controls" button to display it. Click in the Detail
section below the "ID" control. Click the "Use an existing report or form
radio" button. Click "CurrentHousing." Click "Next." Click "Next."
Click "Finish."
Modify the table properties to display the message "Due date cannot be
before invoice date" if the table validation rule is violated. Ans✓✓✓On
the Design tab, in the Show/Hide group, click the "Property Sheet"
button. In the Validation Text box, type message "Due date cannot be
before invoice date" and then press "Enter".
Modify this database so the Navigation Pane is hidden when the
database is opened. Ans✓✓✓Click the "File" tab to open Backstage
view. Click "Options" to open the Access Options dialog. Click "Current
Database." Click the "Display Navigation Pane" check box to remove
the checkmark. Click "OK."
Save a copy of this front-end database as "locked" databased using the
"ACCDE" format. Name the file: "Registration_Locked" Ans✓✓✓Click
the "File" tab to open Backstage. Click "Save as." In the Save Database
,As Column, under Advanced, click 'Make ACCDE', and then click the
'Save as' button. In the File name box, type 'Registration_Locked.' Click
'Save.'
From Design View, modify the selected controls so they are aligned at
the 'left' side Ans✓✓✓On the Report Design Tools Arrange tab, in the
Sizing and Ordering group, click the 'Align' button and select 'Left'
Switch to the view where you can modify the SQL code for the query.
Ans✓✓✓On the Query Tools Design tab, in the Results group, click the
View button arrow and select 'SQL view'
Use AutoFilter to filter the query results first to show only records where
value in the 'Department' field is 'Economics' and the value in the
'Credits' field is '4'. Ans✓✓✓Click the arrow at the top of the
'Department' column and click the '(Select All)' check box to remove all
the checkmarks. Click the 'Economics' check box to add a checkmark.
Click 'OK.' Click the arrow at the top of the 'Credits' column and click
the '(Select All)' check box to remove all the checkmarks. Click the '4'
check box to add a checkmark. Click 'OK.'
From Design view, add the 'University Logo' image file to the right side
of the form header, adding the image to the 'Image Gallery' at the same
time. Ans✓✓✓On the Form Design Tools Design tab, in the Controls
group, click the 'Insert Image' button to open the Image gallery. Click
'Browse...' Click the 'UniversityLogo' image file, and then click the 'OK'
button. Click at the far right side of the form header.
, Sort the records in this table so they are grouped by the value in the
'Classification' field from 'A to Z' and then grouped within each
classification by the value in the 'DOB' field from 'newest to oldest'.
Don't forget that when sorting by multiple fields, start with the
innermost sort and work your way out. Ans✓✓✓Click the arrow at the
top of the 'DOB' column and select 'Sort Newest to Oldest'. Click the
arrow at the top of the 'Classification' column and select 'Sort A-Z'
From Design view, disable both the vertical and horizontal scroll bars
for this form. Ans✓✓✓On the Form Design Tools Design tab, in the
Tools group, click the 'Property Sheet' button. Click the 'Property Sheet
Format' tab. Click in the 'Scroll Bars' property box, expand the list, and
select 'Niether'.
From SQL view, add the 'DeptName' field from the 'Department' table to
the end of the SELECT clause, and then run the query to see the results.
Ans✓✓✓At the end of the first line of code, type; ',
Department.Deptname'. Do not forget the comma. On the Query Tools
Design tab, in the Results group, click the 'Run' button.
Create a new crosstab query using the Crosstab Query Wizard. Select
the 'ScheduleByDepartment' query. Select the 'DeptName' field as the
row headings. Select the 'Days' field as the column headings. Calculate
the 'Sum' of the values in the 'Credits' field. Accept the suggested name
for the query. Ans✓✓✓On the Create tab, in the Queries group, click the
'Query Wizard' button. In the 'New Query' dialog, click 'Crosstab Query
Wizard'. Click 'OK.' Click the 'Queries' radio button. Click
'ScheduleByDepartment'. Click 'Next.' Double-click 'DeptName'. Click
'Next.' Click 'Days'. Click 'Next.' Click 'Sum'. Click 'Next'. Click 'Finish.'
DETAILED VERIFIED AND 100% ACCURATE ANSWERS
BRAND NEW EXAM ALREADY GRADED A+ PASS
From Design view, add a subreport control to the bottom of the Detail
section of this report. Base the subreport on the "CurrentHousing"
report. Use the "ID" field to link the report and subreport. Finish the
subreport without changing the subreport name. Ans✓✓✓On the Report
Design Tools Design tab, in the Controls group, click the
"Subform/Subreport" button. If the controls gallery is not visible on the
ribbon, click the "Controls" button to display it. Click in the Detail
section below the "ID" control. Click the "Use an existing report or form
radio" button. Click "CurrentHousing." Click "Next." Click "Next."
Click "Finish."
Modify the table properties to display the message "Due date cannot be
before invoice date" if the table validation rule is violated. Ans✓✓✓On
the Design tab, in the Show/Hide group, click the "Property Sheet"
button. In the Validation Text box, type message "Due date cannot be
before invoice date" and then press "Enter".
Modify this database so the Navigation Pane is hidden when the
database is opened. Ans✓✓✓Click the "File" tab to open Backstage
view. Click "Options" to open the Access Options dialog. Click "Current
Database." Click the "Display Navigation Pane" check box to remove
the checkmark. Click "OK."
Save a copy of this front-end database as "locked" databased using the
"ACCDE" format. Name the file: "Registration_Locked" Ans✓✓✓Click
the "File" tab to open Backstage. Click "Save as." In the Save Database
,As Column, under Advanced, click 'Make ACCDE', and then click the
'Save as' button. In the File name box, type 'Registration_Locked.' Click
'Save.'
From Design View, modify the selected controls so they are aligned at
the 'left' side Ans✓✓✓On the Report Design Tools Arrange tab, in the
Sizing and Ordering group, click the 'Align' button and select 'Left'
Switch to the view where you can modify the SQL code for the query.
Ans✓✓✓On the Query Tools Design tab, in the Results group, click the
View button arrow and select 'SQL view'
Use AutoFilter to filter the query results first to show only records where
value in the 'Department' field is 'Economics' and the value in the
'Credits' field is '4'. Ans✓✓✓Click the arrow at the top of the
'Department' column and click the '(Select All)' check box to remove all
the checkmarks. Click the 'Economics' check box to add a checkmark.
Click 'OK.' Click the arrow at the top of the 'Credits' column and click
the '(Select All)' check box to remove all the checkmarks. Click the '4'
check box to add a checkmark. Click 'OK.'
From Design view, add the 'University Logo' image file to the right side
of the form header, adding the image to the 'Image Gallery' at the same
time. Ans✓✓✓On the Form Design Tools Design tab, in the Controls
group, click the 'Insert Image' button to open the Image gallery. Click
'Browse...' Click the 'UniversityLogo' image file, and then click the 'OK'
button. Click at the far right side of the form header.
, Sort the records in this table so they are grouped by the value in the
'Classification' field from 'A to Z' and then grouped within each
classification by the value in the 'DOB' field from 'newest to oldest'.
Don't forget that when sorting by multiple fields, start with the
innermost sort and work your way out. Ans✓✓✓Click the arrow at the
top of the 'DOB' column and select 'Sort Newest to Oldest'. Click the
arrow at the top of the 'Classification' column and select 'Sort A-Z'
From Design view, disable both the vertical and horizontal scroll bars
for this form. Ans✓✓✓On the Form Design Tools Design tab, in the
Tools group, click the 'Property Sheet' button. Click the 'Property Sheet
Format' tab. Click in the 'Scroll Bars' property box, expand the list, and
select 'Niether'.
From SQL view, add the 'DeptName' field from the 'Department' table to
the end of the SELECT clause, and then run the query to see the results.
Ans✓✓✓At the end of the first line of code, type; ',
Department.Deptname'. Do not forget the comma. On the Query Tools
Design tab, in the Results group, click the 'Run' button.
Create a new crosstab query using the Crosstab Query Wizard. Select
the 'ScheduleByDepartment' query. Select the 'DeptName' field as the
row headings. Select the 'Days' field as the column headings. Calculate
the 'Sum' of the values in the 'Credits' field. Accept the suggested name
for the query. Ans✓✓✓On the Create tab, in the Queries group, click the
'Query Wizard' button. In the 'New Query' dialog, click 'Crosstab Query
Wizard'. Click 'OK.' Click the 'Queries' radio button. Click
'ScheduleByDepartment'. Click 'Next.' Double-click 'DeptName'. Click
'Next.' Click 'Days'. Click 'Next.' Click 'Sum'. Click 'Next'. Click 'Finish.'
