COURSE
DESCRIPTION FOR
PRODUCE LETTERS, LISTS AND CATALOGS USING ACCESS AND WORD
Master efficient ways to use Access and Word together to
create custom form letters and lists. You will also discover how to create
a catalog for use in print and on an intranet or Internet. The class is
instructor-led with lots of practical exercises. Learn to:
- Create a group of form letters in Word using information
from an Access database.
- Use various techniques in Word and in Access to sort
and select specific records to merge.
- Create quick lists of Access data in Word documents.
- Create a catalog in Word using data from an Access database
and see how to prepare it for use on the Internet or an intranet.
LENGTH
One four hour session.
PREREQUISITES
Introductory knowledge of Word (Word - Level 1)
and intermediate knowledge of Access (Access - Level 2). You also
must have a good understanding of basic Microsoft Windows, file management
and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Fast form letters
Begin with your Access data table
Create the form letter
Select the data source
Add merge fields to the main document
Merge the data and the letter
Lab Activity 2: Query the data
Sort the merged form letters
Filter records
Change the data source to an Access query
Prompt the user for criteria
Lab Activity 3: Quick lists
Publish data with Word
Insert a list of data
Keep a list up to date
Lab Activity 4: Create a catalog
Set up the main document
Insert the fields and merge the data
Dress up the catalog
Use your catalog on the Web
Appendix: QuickSteps
NECESSARY SOFTWARE AND HARDWARE
- You will need Windows 95 or Windows 98 plus Access 97
or higher, Word 97 or higher, and Netscape Navigator or Internet Explorer.
- A printer (optional).
OTHER ACCESS CLASSES
- Access - Advanced. Create
advanced queries, work with macros and design forms and reports.
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
· Create And Normalize A Database From Excel Using Access
· Customize Your Reports Using Access
· Manage, Plan And Analyze Your Inventory Using Access
| 
