Question: help with access module 3 step by step answers to 1, 2, 3, 4, 5 PROJECT STEPS 1. Homestead Partners is a company that connects
PROJECT STEPS 1. Homestead Partners is a company that connects independent home owners with longterm 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. Open the Properties table in Datasheet view and in the record with the PropertyNo value of 2 for Victor Hogg, insert Georgia for the FName value and Brickley for the LName value. Hide the Baths and Deposit columns that do not yet contain any data. 2. With the Properties table still open in Datasheet view, modify the expression in the calculated ApplicationFee field to multiply by 15 instead of 10 . Apply the last filter (the State field is equal to GA). Sort the records in ascending order by the LName field and then save and close the Properties table. 3. Open the Surveys table in Datasheet view and sort the records in descending order by SurveyDate. Change the font size to 12 and apply Arial as the font. Save and dose the Surveys table. 4. Open the ManagerListing query in Datasheet view and for PropertyNo 13, change the ManagerID value to 1. Note that the ManagerLastName value will automatically update to Washington due to the relationships between the Managers and Properties tables. 5. Switch the ManagerListing query to De ign view and use a wildcard character to select all records where the ManagerLastName starts with the letter W. Save and display the ManagerListing query in Datasheet view as shown in Flgure 1 and then close it
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
