CGS 3065 EXAM 1 LATEST 2024 ACTUAL QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |GUARANTEED 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. - ANSWER: 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. - ANSWER: 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.
- ANSWER: 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" - ANSWER: 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 -
ANSWER: 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. - ANSWER: 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'. - ANSWER:
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. - ANSWER: 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. - ANSWER: 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. -
ANSWER: 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. - ANSWER: 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. - ANSWER: 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.'
Modify the database options to display 'University Registration' in the title bar -
ANSWER: Click the 'File' tab to open Backstage view. Click 'Options' to open the
Access Options Dialog. Click 'Current Database'. In the Application Title box, type
'University Registration'. Click 'OK.'
Generate documentation for the 'Student' table. Review the options and verify that
the documentation will include information about the table properties and
relationships only and all the details for fields and indexes. - ANSWER: On the
Database Tools tab, in the Analyze group, click the 'Database Documenter' button.
Click the 'Student' check box. Click the 'Options...' button. Click 'OK.' Click 'OK.'
Use the Form Wizard to create a new form. Include these fields in this order from
the 'Departments' table; 'DeptCode' and 'Deptname' fields and then add these fields
from the 'Courses' table; 'CourseNumber' and 'CourseDescription'. Organize the form
by the Departments table with data from the Courses table as a datasheet subform.
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |GUARANTEED 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. - ANSWER: 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. - ANSWER: 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.
- ANSWER: 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" - ANSWER: 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 -
ANSWER: 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. - ANSWER: 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'. - ANSWER:
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. - ANSWER: 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. - ANSWER: 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. -
ANSWER: 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. - ANSWER: 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. - ANSWER: 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.'
Modify the database options to display 'University Registration' in the title bar -
ANSWER: Click the 'File' tab to open Backstage view. Click 'Options' to open the
Access Options Dialog. Click 'Current Database'. In the Application Title box, type
'University Registration'. Click 'OK.'
Generate documentation for the 'Student' table. Review the options and verify that
the documentation will include information about the table properties and
relationships only and all the details for fields and indexes. - ANSWER: On the
Database Tools tab, in the Analyze group, click the 'Database Documenter' button.
Click the 'Student' check box. Click the 'Options...' button. Click 'OK.' Click 'OK.'
Use the Form Wizard to create a new form. Include these fields in this order from
the 'Departments' table; 'DeptCode' and 'Deptname' fields and then add these fields
from the 'Courses' table; 'CourseNumber' and 'CourseDescription'. Organize the form
by the Departments table with data from the Courses table as a datasheet subform.
