Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started