Access 2024 In Practice - Ch 4 Guided Project 4-3

Guided Project 4-3 SIMnet Project Steps to complete This Project

Mark the steps as checked when you complete them.

1.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

2.Enable content in the database.

3.Right-click the PetsWithoutMatchingOwner report and select Layout View to open the report in Layout view.

4.Change the report to a landscape orientation.

5.Click the Page Setup tab.

6.Click the Landscape button [Page Layout group].

7.Adjust the width of the report columns

8.Select a text box in the Why I’d make a great companion column.

9.Press and hold Shift and click to select the Why I’d make a great companion label.

10.Press F4 to open the Property Sheet and click the Format tab if necessary.

11.Enter 3.2" in the Width property. You must press Enter or Tab after entering the value so that Access recognizes a changed value.

inches

12.Enter 7" in the Left property.

inches

13.Select a text box in the Color column. Press and hold Shift and click to select the Color label.

14.Enter 1.5" in the Width property.

inches

15.Enter 5.4" in the Left property.

inches

16.Set the Width property of the Gender column and label to .6" and set the Left property to 4.7".

inchesinches

17.Set the Width property of the Age column and label to .5" and set the Left property to 4.1".

inchesinches

18.Set the Width property of the Breed column and label to 1.3" and set the Left property to 2.6".

inchesinches

19.Click a text box in the Breed column to select only the text box and to deselect the Breed label.

20.Enter .5" in the Height property.

inches

21.Set the Width property of the Type column and label to .7" and set the Left property to 1.8".

inchesinches

22.Set the Width property of the Pet Name column and label to 1" and set the Left property to .7".

inchesinches

23.Set the Width property of the Pet ID column and label to .4" and set the Left property to .2". The report should look similar to Figure 4-145.

inchesinches

A screenshot of Microsoft Access shows a report of Pets without Matching Owner.The report titled Pets Without Matching Owner, the date, Friday, September 25, 2026, is displayed at the right corner of the Header section. The data is organized into eight columns and two rows. The column headings are Pet I D, Pet Name, Type, Breed, Age, Gender, Color, and Why I'd make a great companion.

Figure 4-145 PetsWithoutMatchingOwner report

24.Save the report.

25.Edit the header and footer sections.

26.Click the text box containing the Date.

27.Enter 7.3" in the Left property.

inches

28.Click to select the title label and then click the label again to open the edit mode.

29.Change the label to Pets Available for Adoption.

30.Click outside the label to save the changes.

31.Scroll down to the bottom of the report and select the page number text box.

32.Enter 9" in the Left property and 11 in the Font Size property.

inches

33.Press F4 to close the Property Sheet.

34.Add grouping and sorting to the report.

35.Click 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.

36.Click Add a group in the Group, Sort, and Total pane.

37.Select the Type field from the Group on select field list.

38.Click More in the Group, Sort, and Total pane.

39.Click the arrow to the right of do not keep group together on one page and then select keep header and first record together on one page (Figure 4-146).

A screenshot shows the Group, Sort, and Total pane.The Group, Sort, and Total pane consists of a Ribbon, present below the Title bar. The Ribbon shows multiple options with a drop-down arrow for each option. The options start from the left end of the Ribbon, such as Group on, with A on top, by entire value, with no totals, with title, with a header section, without a footer section, do not keep group together on one page, and less. The do not keep group together on one page is selected. It consists of several options such as do not keep group together on one page, keep whole group together on one page, and keep header and first record together on one page. The keep header and first record together on one page option is selected.

Figure 4-146 Keep header and first record together on one page option

40.Click Add a sort in the Group, Sort, and Total pane.

41.Select the ID field from the Sort by select field list.

42.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.

43.Scroll to the top of the report. The first record should be for “Tate,” Pet ID number 8. Because the grouping uses a stepped layout, the word “Cat” appears in the Type column on the line above Tate.

44.Add conditional formatting to the report.

45.Click any cell in the Gender column.

46.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.

47.Click the New Rule button to open the New Formatting Rule dialog box.

48.Select the Check values in the current record or use an expression rule type in the Select a rule type box if necessary.

49.Select equal to as the comparison.

50.Type M into the value box.

51.Select Bold and choose the Dark Blue font color from the Standard Colors (fourth column, first row).

52.Click OK. The completed rule displays in the Conditional Formatting Rules Manager dialog box (Figure 4-147).

A screenshot shows the Conditional Formatting Rules Manager dialog box.The Conditional Formatting Rules Manager dialog box consists of the option "Show formatting rules for" at the top left along with a selection field. The Gender option is selected in the field. Below that, the New Rule, Edit Rule, and Delete Rule buttons are present. To the right of these buttons, Move Up and Move Down buttons are present. Below the buttons, show two options, Rule (applied in the order shown), on the left side, and Format, on the right side. Under the Rule option Value equals M is written. Under the Format feature, the text; uppercase A lowercase a uppercase B lowercase b uppercase C lowercase c uppercase Y lowercase y uppercase Z lowercase z, is written in blue color.

Figure 4-147 Conditional formatting rule

53.Click Apply.

54.Click OK.

55.Save the report.

56.Add totals to the report to count how many of each type of pet is available.

57.Select a text box in the Pet ID column.

58.Click the Totals button [Report Layout Design tab, Grouping & Totals group].

59.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.

60.Save the report.

Preview the report.

61.Click the View button drop-down arrow [Report Layout Design tab, Views group] and select Print Preview. The report should look similar to Figure 4-148.

A screenshot shows the Print Preview of a report.The report titled, Pets Available for Adoption, the date, Friday, September 25, 2026, is displayed on the right end of the header section. The data in the report is displayed in a tabular column. It consists of eight columns and three rows. The column headings are Pet I D, Pet Name, Type, Breed, Age, Gender, Color, and Why I would make a great companion.

Figure 4-148 Print Preview of completed report

62.Click the One Page button [Print Preview tab, Zoom group] if necessary.

63.Use the navigation arrows to move among pages. Notice the value for the total number of each pet type displays in the Pet ID column because this is the field used to count records. Also notice that the "M" in the Gender column displays in bold, dark blue.

64.Click the Close Print Preview button.

65.Close the report.

66.Create a split form and adjust control positions on the form.

67.Click to select the Owners table in the Navigation Pane.

68.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.

69.Click the Select Layout button [Arrange tab, Rows & Columns group].

70.Click the Control Padding button [Arrange tab, Position group].

71.Select Medium.

72.Click inside the form to deselect the control layout. The completed form should look similar to Figure 4-149.

A screenshot of Microsoft Access shows a Split form.On the top part of the Work area, shows an Object tab titled Owners. It consists of the Owners form. The form consists of eight fields. The fields and the entries are as follows: Owner I D: 0100. Owner or Last Name: Washington. Owner or First Name: Tyrone. Address: 11 Lakewood Drive. City: Abilene. State, ZIP, and Phone is present at the bottom of the datasheet area. The first row containing the database of a pet is converted into a split form. The split form is present in the upper half of the datasheet area. The form has a Header section with the label Owners. Below the label, multiple fields and their data are present. The fields and their corresponding data are as follows: Owner I D: 0100, Owner or Last Name: Washington, Owner or First Name: Tyrone, Address: 11 Lakewood Drive, City: Abilene. State: T X. ZIP: 79601. Phone: (325) 614-9333. Below the form, a table is shown. It consists of eight columns and five rows. A Record button, the Page number, a Filter, and a Search button are displayed on the bottom left of the Work area.

Figure 4-149 Completed split form

73.Save the form. Accept the suggested form name by clicking OK.

74.Sort the records on the form.

75.Press F4 to open the Property Sheet and click the Data tab if necessary.

76.Click the drop-down arrow in the Selection box of the Property Sheet and select Form.

77.Type [OwnerLastName] in the Order By property box and press Enter.

78.Select Yes in the Order By On Load property box if necessary.

79.Close the Property Sheet.

80.Save and close the form. This allows the sort action to take effect when the form is next opened.

Test the form.

81.Open the form in Form view. OwnerID 0103 should display based on the sort applied.

82.Use the navigation buttons to move among records. Notice that the highlighted record in the lower section updates as you navigate from one record to the next.

83.Close the form.

84.Close the database.

85.Upload and save your project file.

86.Submit project for grading.