University of North Texas Data Analyst of Homestead Partners Program Project

The assignment steps:

1.Homestead Partners is a company that connects independent home owners with long-term renters. You work in the Customer Service Department of Homestead Partners as a data analyst. You are developing an Access database application to help manage and analyze several types of customer service data, including property and property manager effectiveness. In this project, you will improve an existing database by formatting, modifying, and creating new forms and reports. You will also modify several different types of form and report controls.

Create a split form from the Managers table. Save the form with the name SplitManagers and close it.

2.Open the ManagerEntry form in Design View and change the Record Source for the form to the SortedManagers query. Change the tab order so that the SignonBonus field is in the third position in the Detail section. Save and close the ManagerEntry form.

3.In Design View of the PropertyEntry form, use the Combo Box Wizard to add a combo box to the form just below the City text box. Get the values from the StateAbbreviations table. Select both fields for the columns in the combo box. Do not add any sort orders, hide the key column, and store the value in the State field. Enter State as the label for the combo box and save the PropertyEntry form.

4.While still in Design View of the PropertyEntry form, add a check box control to the upper right area of the Detail section at approximately the 3.5″ mark on the horizontal ruler and just below the Detail section bar. Modify the Control Source property of the check box to the ScenicView field and use View? as the Caption of the accompany label. Save and view the form in Form View as shown in Figure 1, and then close the PropertyEntry form.

5.Open the HomeStyles form in Design View. Select the four controls in the Detail section and apply a Stacked Layout to them. Expand the Detail section to be about 3″ tall. Use the Subform Wizard to add the PropertyNo, City, and State fields from the Properties table as a subform control positioned just below the Description label. Use the default link and name for the subform. Save and view the form in Form View as shown in Figure 2, and then close the HomeStyles form.

6.Open the ManagerEntry form in Layout View. Add a new text box to the form and move it just below the Signon Bonus text box. Use Phone as the Caption for the accompanying label and use CellPhone as the Control Source property for the text box. Save the ManagerEntry form.

7.Switch the ManagerEntry form to Design View and left align the left edges of the InterviewScore, RealEstateTestScore, and CustomerServiceTestScore text boxes. Add a rectangle control around the six controls (three labels and three text boxes) that represent the Interview, Real Estate, and Customer Service scores. Save the ManagerEntry form.

8.With the ManagerEntry form still open in Design View, insert the Support_AC19_EOM6-1_Manager.png image found in the default folder at the top edge of the Form Header at about the 2.5″ mark on the horizontal ruler. Save and view the form in Form View as shown in Figure 3, and then close the ManagerEntry form.

9.Open the ManagerScores report in Design View and add a rectangle control around the three text boxes on the right side of the Detail section that display score information. Apply the shape fill of the rectangle control to transparent. Add a horizontal line to the Report Footer section, just above the three text boxes that calculate the average scores for the report. Save and view the report in Report View as shown in Figure 4, and then close the ManagerScores report.

10.Open the Properties report in Design View and add the Support_AC19_EOM6-1_Draft.png image as a background image to the report. Save and view the report in Print Preview as shown in Figure 5, and then close the Properties report.