Need to make a Database following mentioned below steps?

a)      Start Access and open the LakeHomes-6.accdb database from the location where you store your Data Files, then enable content if prompted.

b)     Query Design View, make a query with the following fields in the following order:

AgencyName from the Agencies table

SqFt and Asking from the Listings table

c)      the records in descending order by the SqFt field.

d)     view the datasheet, enter your last name instead of Schwartz for the listing with the

the query as

largest SqFt value, then print the datasheet if requested by your instructor.

e)     In The new calculated field's name should be PerSqFt Query Design View, modify the BySqFt query by making a calculated field that determines price per square foot. , and the expression should be the asking price divided by the [Asking]/[SqFt]. square foot field, or

f)        Remove any former sort orders, sort the records in descending order based on the PerSqFt calculated field, and view the datasheet. Save and close the BySqFt query. ###### means the data is too wide to display in the column. You can make the data narrower and also align it by applying a Currency format.

g)      Reopen the BySqFt query in Query Design View, right-click the calculated PerSqFt field, click Properties, then change the Format property to Currency. View the datasheet, print it if requested by your instructor, then save and close the BySqFt query. CostSummary.

h)     Copy and paste the BySqFt query as CostSummary

i)       In Design View of the CostSummary query, delete the RFirst, RLast, and SqFt fields.

j)       View the datasheet, then change the Big Cedar Realtors agency name to your last name followed by Realtors

k)      In Design View, add the Total row, then sum the Asking field and use the Avg (Average) aggregate function for the PerSqFt calculated field.

l)       In Datasheet View, add the Total row and display the sum of the SumOfAsking field. Widen all columns as needed,

m)   Close the LakeHomes-6.accdb database, then exit Access.

 

Table Tools File Home Create External Data Database Tools Help Fields Table LakeHomes-6: Database- C:\Users\Farhan\Desktop\LakeHomes-6.accdb (Acc... mirza Tell me what you want to do Cut Ascending Selection New Totals ab ac Replace Calibri 11 ABC Copy Descending Advanced Save Spelling Go To View Paste Filter Format Painter Remove Sort Toggle Filter Refresh All Find - X Delete Select BIUA ab More Views All Acc... Tables Agencies HomeTypes Listings Realtors Clipboard Sort & Filter Records Find Text Formatting Agencies X Agency No AgencyName ++++ 1 Big Cedar Realtors 2 Sunset Cove Realtors 3 Green Mountain Realty 4 Shepherd of the Hills Realtors (New) Street 123 Second Street 7878 Lake View Lane 9900 West Sunset Drive 7744 Pokeberry Lane City State Zip Branson West MO 77889 555-666-7700 Branson MO 77770 555-555-8800 West Branson MO Hollister 77990 555-999-9999 MO 77660 555-888-4444 AgencyPhone Click t