Microsoft Office Tutorials and References
In Depth Information
Session 1.2
8. Set the option for compacting the Seasons 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.)
9. Close the Seasons database.
Case Problem 1
Data File needed for this Case Problem: Videos.mdb
Lim’s Video Photography Several years ago, Youngho Lim left his position at a commer-
cial photographer’s studio and started his own business, Lim’s Video Photography, located
in San Francisco, California. Youngho quickly established a reputation as one of the area’s
best videographers, specializing in digital video photography. Youngho offers customers
the option of storing edited videos on CD or DVD. His video shoots include weddings
and other special events, as well as recording personal and commercial inventories for
insurance purposes.
Apply
Use the skills you
learned in the tutorial
to work with the data
contained in a video
photography database.
As his business continues to grow, Youngho relies on Access to keep track of information
about clients, contracts, and so on. Youngho recently created an Access database named
Videos to store data about his clients. You’ll help Youngho complete and maintain the
Videos database. Complete the following:
1. Open the Videos database, which is located in the Brief\Case1 folder provided with
your Data Files.
2. Open the Client table, print the table datasheet, and then close the table.
3. Use the Simple Query Wizard to create a query that includes the ClientName, Phone,
and City fields (in that order) from the Client table. Name the query ClientList . Print
the query results, and then close the query.
4. Use the AutoForm: Columnar Wizard to create a form for the Contract table. Save the
form as ContractInfo , and then close it.
5. Use the AutoReport: Columnar Wizard to create a report based on the Contract table.
Print the first page of the report, and then close the report and save it as Contracts .
6. Set the option for compacting the Videos database on close. (Note: If you are working
from a floppy disk, check with your instructor or technical support staff to confirm
that you should set this option.)
7. Close the Videos database.
Case Problem 2
Data File needed for this Case Problem: Fitness.mdb
Parkhurst Health & Fitness Center After many years working in various corporate set-
tings, Martha Parkhurst decided to turn her lifelong interest in health and fitness into a
new business venture and opened the Parkhurst Health & Fitness Center in Richmond,
Virginia. In addition to providing the usual fitness classes and weight training facilities, the
center also offers specialized programs designed to meet the needs of athletes—both
young and old—who participate in certain sports or physical activities. Martha’s goal in
establishing such programs is twofold: to help athletes gain a competitive edge through
customized training, and to ensure the health and safety of all participants through proper
exercises and physical preparation.
Apply
Apply what you learned
in the tutorial to work
with the data for a new
business in the health
and fitness industry.
 
Search JabSto ::




Custom Search