Microsoft Access 2002

Microsoft Approved Courseware
This text is a comprehensive instructional tool designed for users of Microsoft Access. This self-paced, self-instructional guide provides you with all the instruction necessary to become a knowledgeable user of this popular database software.

Features
Comprehensive Review Exercises and hands-on activities placed throughout the text
Beginning, intermediate, and advanced capabilities of Access
Coverage of advanced features such as the Expression Builder, hyperlinks, and macros
Also includes coverage of Access BASIC for advanced procedures
Internet capabilities
 
25 to 40 hours of instruction.

Table of Contents

Unit 1 Access Basics
Lesson 1 Getting Started with Access
Lesson 2 Using Access's Menus, Dialog Boxes and Help Feature
Lesson 3 Creating a New Database
Lesson 4 Entering and Editing Data
Lesson 5 Creating and Using Basic Forms
Lesson 6 Maintaining Data Integrity

Unit 2 Managing Reports, Labels, and Relationships
Lesson 7 Creating, Modifying, and Printing Basic Reports
Lesson 8 Creating Mailing Labels
Lesson 9 Relating Multiple Tables

Unit 3 Finding Information
Lesson 10 Sorting, Finding, And Filtering Figures
Lesson 11 Basic Queries
Lesson 12 Enhanced Queries
Lesson 13 Creating Interactive Queries
Lesson 14 Creating Multiple Table Queries
Lesson 15 Using the Expression Builder and Building Summary Queries
Lesson 16 Creating Advanced Queries

Unit 4 Advanced Access Features
Lesson 17 Creating Reports from Queries
Lesson 18 Advanced Report Features
Lesson 19 Advanced Form Features and Hyperlinks
Lesson 20 Creating Basic Macros
Lesson 21 Creating Advanced Macros
Lesson 22 Modifying Macros

Unit 5 Access Power Features
Lesson 23 Writing Access Basic
Lesson 24 Editing Access Basic Statements

Appendix: Access and the Internet
Glossary
Index

 

Phone: 800-386-3171 Phone: 360-876-5540 Fax:    360-876-5562 Our hours are: 8:30 A.M. to 3:30 P.M. Monday through Thursday