making database

Thenursinghub prides itself on its specialization in the all academic fields. This focus sets them apart as a writing company that fully comprehends the intricacies and challenges faced by students. Their team comprises skilled writers who possess not only advanced degrees but also practical experience in the industry. This expertise allows them to craft papers that reflect a deep understanding of nursing concepts, procedures, and standards. The company follows stringent quality assurance measures to ensure that all papers meet the highest academic standards. Each paper undergoes a thorough review process, which includes rigorous proofreading, editing, and plagiarism checks. By prioritizing quality, Thenursinghub ensures that nursing students receive well-researched, accurately cited, and flawlessly written papers.

Complete the Independent Challenge 3 exercise on page Access 160 in Module 6: Improving Queries. Do not perform the Print in step g, and m. The Friedrichsen Access 2016 data files can be found in the Resources section of the class. You must download and use the LakeHomes-6.accdb file provided with this course – look in the Resource section, Access Module 6 in the Friedrichsen Access 2016 Data Files folder.

Name the completed Access database Last Name_LakeHomes-6.accdb (i.e. Smith_ LakeHomes-6.accdb).

(-40) – additional submission allowed to compete this work
a. Open LakeHomes-6.accdb 2% (the deduction may be materially higher if correct file not used)

b. Create query with fields (in order) – AgencyName (Agencies table), RFirst and RLast (Realtors table), SqFt and Asking (Listings table) 5%

c. Sort in Descending order by SqFt field – removed for second query 0%

d. Save Query as BySqFt 2%

d. Enter Student last name in place of Schwartz 3%

e. Modify Query – add calculated field PerSqFt [Asking]/[SqFt] 6%

f. Remove former Sorts – sort PerSqFt in Descending order, save and close query 4%

g. Use Property sheet to set PerSqFt to currency, no Print needed 3%

h. Create CostSummary query – by copying BySqFt as base 2%

i. Delete RFirst, RLast and SqFt fields 2%

j. Change Big Cedar Realtors agency name to student last name Realtors 3%

k. Add Total row, then sum the Asking field and use Average aggregate function for the PerSqFt calculated field 5%

l. In Datasheet View – add the Total row and display the sum of the SumOfAsking field, widen all fields as needed, (see figure 6-22) 3%

m. If requested – print the CostSummary query – not requested 0%

n. Close and exit – change filename to include Student Last name 0%

Thenursinghub delivers custom papers tailored to the unique requirements of each student. Their writers collaborate closely with clients to understand their specific needs, instructions, and preferences. This individualized approach allows Thenursinghub to produce original content that aligns perfectly with the student’s academic goals, ensuring the work is both relevant and authentic.

 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.