Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 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

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

MS Access

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 PropertyTypeCityState, 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

The figure shows the first 12 records of the CityListing query in Datasheet View. The CityListing query contains the PropertyType, City, State, and YearBuilt fields in that order.

 

  1. In the Navigation pane, rename the Property form using PropertyEntry as the new form name.
  2. Create a new form using the Form Wizard. Choose the FNameLNameCityState, 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

 

The figure shows the OwnerInfo form in Form View. The form includes the FName, LName, City, State, and Zip fields in that order in a Columnar layout.

 

  1. Create a new report using the Report Wizard. Choose the PropertyNoCityState, 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

The figure shows a portion of the PropertiesByState report in Report View. The report includes the State, City, PropertyNo, and YearBuilt fields in that order in a Tabular layout. The records are sorted in ascending order by State and then by City.

 

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.

 

Option 1

Low Cost Option
Download this past answer in few clicks

19.99 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE