Open the LifesAnimalShelter-04 database start file.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor
Enable content in the database.
Right-click the PetsWithoutMatchingOwner report and select Layout View to open the report in Layout view.
Change the report to a landscape orientation.
Click the Page Setup tab.
Click the Landscape button [Page Layout group].
Adjust the width of the report columns
Select a text box in the Why I’d make a great companion column.
Press and hold Shift and click to select the Why I’d make a great companion label.
Press F4 to open the Property Sheet and click the Format tab if necessary.
Enter 3.2″ in the Width property. You must press Enter or Tab after entering the value so that Access recognizes a changed value.
Enter 7″ in the Left property.
Select a text box in the Color column. Press and hold Shift and click to select the Color label.
Enter 1.5″ in the Width property.
Enter 5.3″ in the Left property.
Set the Width property of the Gender column and label to .6″ and set the Left property to 4.6″.
Set the Width property of the Age column and label to .5″ and set the Left property to 4″.
Set the Width property of the Breed column and label to 1.3″ and set the Left property to 2.5″.
Click a text box in the Breed column to select only the text box and to deselect the Breed label.
Enter .5″ in the Height property.
Set the Width property of the Type column and label to .7″ and set the Left property to 1.7″.
Set the Width property of the Pet Name column and label to .8″ and set the Left property to .8″. The report should look similar to Figure 4-141.
Layout view of report excerpt displays header, and two records.
Figure 4-141 PetsWithoutMatchingOwner report
Save the report.
Edit the header and footer sections.
Click the text box containing the Date.
Enter 7.4″ in the Left property.
Click to select the title label and then click the label again to open the edit mode.
Change the label to Pets Available for Adoption.
Click outside the label to save the changes.
Scroll down to the bottom of the report and select the page number text box.
Enter 9″ in the Left property.
Press F4 to close the Property Sheet.
Add grouping and sorting to the report.
Click the Group & Sort button [Design tab, Grouping & Totals group] to open the Group, Sort, and Total pane at the bottom of the report.
Alternate Instruction for Microsoft 365 Apps iconClick the Group & Sort button [Report Layout Design tab, Grouping & Totals group] to open the Group, Sort, and Total pane at the bottom of the report.
Click Add a group in the Group, Sort, and Total pane.
Select the Type field from the Group on select field list.
Click More in the Group, Sort, and Total pane.
Select the do not keep group together on one page arrow and then select keep header and first record together on one page (Figure 4-142).
Expanded Group, Sort, and Total pane with pointer on desired option in drop-down list.
Figure 4-142 Keep header and first record together on one page option
Click Add a sort in the Group, Sort, and Total pane.
Select the ID field from the Sort by select field list.
Close the Group, Sort, and Total pane by clicking the X in the upper-right corner of the Group, Sort, and Total pane. Be careful not to click the Delete symbol inside the pane or you remove the group.
Scroll to the top of the report. The first record should be for “Martin,” Pet ID number 6. Because the grouping uses a stepped layout, the word “Cat” appears in the Type column on the line above Martin.
Add conditional formatting to the report.
Click any cell in the Gender column.
Click the Conditional Formatting button [Format tab, Control Formatting group] to open the Conditional Formatting Rules Manager dialog box. Gender displays in the Show formatting rules for box.
Click the New Rule button to open the New Formatting Rule dialog box.
Select the Check values in the current record or use an expression rule type in the Select a rule type box if necessary.
Select equal to as the comparison.
Type M into the value box.
Select bold and choose the Dark Blue font color from the first row of Standard Colors.
Click OK. The completed rule displays in the Conditional Formatting Rules Manager dialog box (Figure 4-143).
Conditional formatting rule
Figure 4-143 Conditional formatting rule
Click Apply.
Click OK.
Save the report.
Add totals to the report to count how many of each type of pet is available.
Select a text box in the Pet ID column.
Click the Totals button [Design tab, Grouping & Totals group].
Alternate Instruction for Microsoft 365 Apps iconClick the Totals button [Report Layout Design tab, Grouping & Totals group].
Select Count Records. The report updates to show the total at the end of each group and a grand total at the end of the report.
Save the report.
Preview the report.
Select the View button [Design tab, Views group] and select Print Preview. The report should look similar to Figure 4-144.
Alternate Instruction for Microsoft 365 Apps iconSelect the View button [Report Layout Design tab, Views group] and select Print Preview. The report should look similar to Figure 4-144.
Report excerpt displays header, two records in detail section, and page number in footer.
Figure 4-144 Print Preview of completed report
Click the One Page button [Print Preview tab, Zoom group] if necessary.
Use the navigation arrows to move among pages.
Click the Close Print Preview button.
Close the report.
Create a split form and adjust control positions on the form.
Click to select the Owners table in the Navigation Pane.
Click the More Forms button [Create tab, Forms group] and select Split Form to create a new form. Depending on the width of the Access window, your form may display the fields in two columns in the top half of the form.
Click the Arrange tab.
Click the Select Layout button.
Click the Control Padding button.
Select Medium.
Click inside the form to deselect the control layout. The completed form should look similar to Figure 4-145.
Layout view of Owners split form. Data about OwnerID 0100 displays in top section while multiple records display in Datasheet view in the bottom section.
Figure 4-145 Completed split form
Save the form. Accept the suggested form name by clicking OK.
Switch to Form view by clicking the Form View icon in the Status bar.
Use the navigation buttons to move among records.
Close the form.
Close the database.
Upload and save your project file.
Submit project for grading.
For This or a Similar Paper Click Here To Order Now
