|
| Course Number | MO1456 |
|
| Duration | Four Hours |
|
| Audience | Any new or current user looking to learn how to use Microsoft Access 2007. |
|
| Details | This course introduces participants to the Access environment and provides a foundation in creating table structures. Select query creation and modification are presented. After attending this course, participants will be able to create tables and fields, and to query the database for specific information. |
|
| Course Outline | Lesson 1: Getting Started
Database concepts
Exploring the Access environment
Getting help
Lesson 2: Databases and tables
Planning and designing databases
Exploring tables
Creating tables
Lesson 3: Fields and records
Changing the design of a table
Finding and editing records
Organizing records
Lesson 4: Data entry rules
Setting field properties
Working with input masks
Setting validation rules
Using indexes
Lesson 5: Basic queries
Creating and using queries
Modifying query results |
|
| Sponsor | TD |
|
| |
