Microsoft Office Tutorials and References
In Depth Information
4. Use the Simple Query Wizard to create a query that includes the GuestName, City,
StateProv, and Phone fields (in that order) from the Guest table. Name the query
5. Sort the query results in descending order by StateProv. ( Hint : Use a toolbar button.)
6. Print the query results, and then close and save the query.
7. Use the AutoForm: Columnar Wizard to create a form for the Guest table. Use the
Microsoft Access Help task pane to search for information on how to find a specific
record in a form. Select the topic “Find a record in a datasheet or form in Access,”
then choose the topic related to finding a record by record number. Read the dis-
played information. Close the Microsoft Office Access Help window and the task
pane. Use the record number box to move to record 16, and then print the form for
the current record only. ( Hint : Use the Selected Record(s) option in the Print dialog
box to print the current record.) Save the form as GuestInfo , and then close it.
8. Use the AutoReport: Tabular Wizard to create a report based on the Guest table. Maximize
the Report window and change the Zoom setting to Fit. Use the Two Pages button on the
Print Preview toolbar to view both pages of the report in Print Preview. Print the first page
of the report in landscape orientation, and then close and save the report as Guests .
9. Set the option for compacting the GEM 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.)
10. Convert the GEM database to Access 2002–2003 file format, saving the converted file
as GEM2002 in the Brief\Case4 folder. Then convert the GEM database to Access 97
file format, saving the converted file as GEM97 in the Brief\Case4 folder. Using
Windows Explorer or My Computer, view the contents of your Brief\Case4 folder,
and note the file sizes of the three versions of the GEM database. Describe the results.
11. Close the GEM database.
The purpose of the Internet Assignments is to challenge you to find information on the
Internet that you can use to work effectively with this software. The actual assignments are
updated and maintained on the Course Technology Web site. Log on to the Internet and
use your Web browser to go to the Student Online Companion for New Perspectives
then navigate to the assignments for this tutorial.
Use the Internet to find
and work with data
related to the topics
presented in this
SAM Assessment and Training
If your instructor has chosen to use the full online version of SAM 2003 Assessment and
Training, you can go beyond the “just-in-time” training provided on the CD that accompa-
nies this text. Simply log in to your SAM account ( http://sam2003.course.com) to launch
any assigned training activities or exams that relate to the skills covered in this tutorial.