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. correct answers On the Report Design Tools ...
CGS ACCESS || All Questions Answered Correctly.
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. correct answers 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. correct answers 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. correct
answers 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" correct answers 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 correct
answers 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. correct answers 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'. correct answers 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. correct answers 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. correct answers 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. correct
answers 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. correct answers 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. correct answers 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 correct answers
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. correct answers 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. Accept the suggested names for
the form and subform. Allow Access to open the form in the Form view when you are finished.
correct answers On the Create tab, in the Forms group, click the 'Form Wizard' button. Expand
the 'Tables/Queries' list and select 'Table; Departments'. Double-click 'DeptCode' and then
'Deptname'. Expand the 'Tables/Queries' list and select 'Table; Courses'. Double-click
'CourseNumber' and 'Course Description'. Click 'Next'. Click 'Next'. Click 'Next'. Click 'Finish'.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
