Intro to Microsoft Access

Learn how to use Microsoft's powerful and award-winning database to store, locate, and print just about any type of important information. In this six-week online workshop, you'll learn how to create tables, relationships, custom data entry forms, queries, reports, mailing labels, and macros. You'll also learn how to merge the data in your Access tables with Microsoft Word form letters.

View dates this course will be offered.

Requirements:

For this class, you will need Microsoft Access 95 or 97 or the Microsoft Office Professional 95 or 97. You'll also need Internet access, e-mail, and the Microsoft Internet Explorer or Netscape Navigator web browser.

Syllabus:

Week One
Lesson 1	Creating a table: the basics
Lesson 2	Creating tables (continued): customizing the fields
Week Two
Lesson 3	Creating relationships between tables
Lesson 4	Creating custom data entry forms with the Wizard
Week Three
Lesson 5	Creating custom data entry forms from scratch
Lesson 6	Adding controls to a data entry form
Week Four
Lesson 7	Performing queries on your tables
Lesson 8	Creating basic reports
Week Five
Lesson 9	Advanced reporting techniques
Lesson 10	Super advanced reporting techniques
Week Six
Lesson 11	Automating Access with Macros
Lesson 12	Exporting Access tables for use in Word form letters

Other Microsoft Office Courses

Other Courses