Access 2003 training courses

A roadmap to Access 2003 training:

1. Know Access

Course What you’ll learn
Get to know Access What's in a database, and how to plan one
Access Security I: Introduction to security What you can do and should do to help protect your data and your computer

2. Database objects: tables, forms, and reports

Course What you’ll learn
Table that data Table basics: Keys and fields and field properties, working in Design view, defining relations in relational databases
Forms I: Create a form to enter and view your data Form basics: Types and parts of forms, creating and customizing a form, formats for forms
Forms II: Use subforms How to view and enter data in two or more tables at once, by putting forms inside other forms
Reports : Show off your data Reports basics: How to create, preview, customize, and format a report

3. All about queries

Course What you’ll learn
Queries I: Get answers with queries How to plan, create, and run basic queries
Queries II: Limit your results and calculate values How to focus queries on specific data, and how to have queries perform calculations for you
Queries III: Create parameter queries that prompt users for input How to work with queries that can use different values every time anyone runs them
Queries IV: Working with complex criteria How to create queries with multiple conditions and wildcards

4. Use controls

Course What you’ll learn
Combo boxes, list boxes, and other controls How to add and customize controls, set their properties, bind them to data in tables, have them perform calculations, and make their appearance change automatically

5. Label data

Course What you’ll learn
Create labels from your database How to create and customize labels, with a wizard or without

6. Work with an existing database

Course What you’ll learn
Work with a database you didn't create How to see what's in a database, and how to change it effectively

Note     You can also download shorter PowerPoint versions of some training courses, or you can download the Quick Reference Cards that summarize each course.

And that's not all – the whole

schmeer

Online training isn't just for Access. It's also available for the other programs in the Microsoft Office System. Because the more you know, the better you do.

 
 
Applies to:
Access 2003