New Perspectives Access 2019 | Module 1: End of Module Project 1 Homestead Partners   Building an Access Database     GETTING STARTED Open the file NP_AC19_EOM1-1_FirstLastName_1

Subject:MS AccessPrice:20.01 Bought7

Share With

New Perspectives Access 2019 | Module 1: End of Module Project 1

Homestead Partners

 

Building an Access Database

• GETTING STARTED

• Open the file NP_AC19_EOM1-1_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_EOM1-1_FirstLastName_2.accdb by changing the “1” to a “2”.
  • If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

• PROJECT STEPS

1. Homestead Partners is a firm 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 customer satisfaction survey data on the properties rented through your company. In this project you will improve an existing database by creating and modifying fields and tables, queries, forms, and reports.
   
   Open the Properties table in Datasheet view and use StreetAddress to rename the current Address field. Close the Properties table.
2. Create a new table in Datasheet view. Change the ID field name to ManagerID with the AutoNumber data type, add a field named ManagerFirstName with the Short Text data type, add a field named ManagerLastName with the Short Text data type, add a field named HireDate with the Date/Time data type, and add a field named Salary with the Currency data type. Save the table with the name Managers and close it.
3. Open the PropertyTypes table in Datasheet view and then add a new record with Log Cabin as the Description field value, noting that the ID field automatically increments to 7. Close the PropertyTypes table.
4. Open the Properties table in Datasheet view and delete the record for PropertyNo 4 (5817 Nall Ave, Sid, Ortiz, Des Moines, IA). Modify the FName value for the record with PropertyNo 2 (4106 W 67th Ter, Victorina, Hogg, Prairie Valley, KS), using Victor as the new FName value, and then close the Properties table.
5. Create a new query using the Simple Query Wizard. Choose the PropertyType, City, State, and YearBuilt fields from the Properties table. Title the new query with the name CityListing, open the query to view information, a portion of which is shown in Figure 1, and then close it.

Figure 1: CityListing Query

6. In the Navigation pane, rename the Property form using PropertyEntry as the new form name.
7. Create a new form using the Form Wizard. Choose the FName, LName, City, State, and Zip fields in the Properties table. Choose a Columnar layout. Title the form OwnerInfo, open the form to view information as shown in Figure 2, and then close it.

Figure 2: OwnerInfo Form

8. Create a new report using the Report Wizard. Choose the PropertyNo, City, State, and YearBuilt fields from the Properties table. Do not add any grouping levels. Sort the records in ascending order by State and then in ascending order by City. Use a Tabular layout and a Portrait orientation. Title the report PropertiesByState, preview the report, a portion of which is shown in Figure 3, and then close it.

Figure 3: PropertiesByState Report

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.