McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center


Advantage Series MS Office XP Access 2002
Advantage Series: Microsoft® Access 2002
Sarah Hutchinson-Clifford
Glen Coulthard
Organizing And Retrieving Data

Case Problems

Download as a Word document: Case Problems Ch03 (25.0K)

Huffman Lake Property Owners Association

In this exercise you will help your uncle to organize and find out some information about the members in the HLPOA database.

The first question is, "how many properties have a SEV greater than $300,000 and are on the lake front?" Use the query by form. How many records were selected? How many properties have an SEV greater than $300,000 and are not lake front? ( Hint: you have to make sure the check box for lake front is not grayed and that it doesn’t have a check mark.) Close the table and do not save changes.

Use the simple query wizard to generate a list of members that have paid dues. Select MemberID FirstName, LastName, and Phone from the members table, Payment and Payment amount from the Payments table, and Description from the PaymentItems table. Use "Paid Members" for the title. After the datasheet view of the query opens, choose a different font, font size and font color, resize the columns to "Best Fit" then preview and print the report.

Close and save the layout changes. Then exit Access

Case Problems Data Files Ch03 (110.0K)




McGraw-Hill/Irwin




Copyright2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.