Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Energy Audits

Authors: Prentice-Hall

1st Edition

0881731285, 978-0881731286

More Books

Students also viewed these Accounting questions

Question

What are the main characteristics of Feature Driven Development?

Answered: 1 week ago

Question

Which form of proof do you find most persuasive? Why?

Answered: 1 week ago