Microsoft Office Tutorials and References
In Depth Information
Martha created the Fitness database in Access to maintain information about the members
who have joined the center and the types of programs offered. She needs your help in
working with this database. Complete the following:
1. Open the Fitness database located in the Brief\Case2 folder provided with your
2. Open the Member table, print the table datasheet, and then close the table.
3. Use the Simple Query Wizard to create a query that includes the FirstName,
LastName, DateJoined, and Phone fields (in that order) from the Member table.
Name the query MemberList .
4. Sort the query results in descending order by the DateJoined field. ( Hint : Use a tool-
5. Print the query results, and then close and save the query.
6. Use the AutoForm: Columnar Wizard to create a form for the Member table. Save the
form as MemberInfo , and then close it.
7. Use the AutoReport: Columnar Wizard to create a report based on the Member table.
Maximize the Report window and change the Zoom setting to Fit.
8. Print just the first page of the report, and then close and save the report as Members .
9. Set the option for compacting the Fitness database on close. ( Note: If you are work-
ing from a floppy disk, check with your instructor or technical support staff to confirm
that you should set this option.)
10. Close the Fitness database.
Case Problem 3
Data File needed for this Case Problem: Redwood.mdb
Redwood Zoo The Redwood Zoo is a small zoo located in the picturesque city of Gig
Harbor, Washington, on the shores of Puget Sound. The zoo is ideally situated, with the
natural beauty of the site providing the perfect backdrop for the zoo’s varied exhibits.
Although there are larger zoos in the greater Seattle area, the Redwood Zoo is considered
to have some of the best exhibits of marine animals. The newly constructed polar bear
habitat is a particular favorite among patrons.
Use what you've
learned, and go a bit
beyond, to work with a
database that contains
information about a zoo.
Michael Rosenfeld is the director of fundraising activities for the Redwood Zoo. The zoo
relies heavily on donations to fund both ongoing exhibits and temporary displays, espe-
cially those involving exotic animals. Michael created an Access database named
Redwood to keep track of information about donors, their pledges, and the status of funds.
You’ll help Michael maintain the Redwood database. Complete the following:
1. Open the Redwood database, which is located in the Brief\Case3 folder provided
with your Data Files.
2. Use the “Type a question for help” box to ask the following question: “How do I
rename an object?” Click the topic “Rename a database object” and read the dis-
played information. Close the Microsoft Office Access Help window and the task
pane. Then, in the Redwood database, rename the Table1 table as Donor .
3. Open the Donor table, print the table datasheet, and then close the table.
4. Use the Simple Query Wizard to create a query that includes all the fields in the
Donor table exceptthe MI field. (Hi nt: Use the
buttons to select the
necessary fields.) Name the query Donors .
5. Sort the query results in descending order by the Class field. (Hi nt: Use a toolbar
button.) Print the query results, and then close and save the query.