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'.
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur FullyFocus. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €11,22. Vous n'êtes lié à rien après votre achat.
