Microsoft Access 2007 - Level 1
Location: Latham
Understand database concepts, explore Access components, add and edit table
data, set data entry rules, create queries, forms and reports.
Recommended Preparation:
Welcome to Windows XP or
Welcome to Windows Vista or equivalent knowledge.
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 and queries
- Performing operations in queries
Lesson 6: Using forms
- Creating forms
- Using the Form Wizard
- Using Design view
- Finding, sorting, and filtering records
Lesson 7: Working with reports
- Reports
- Modifying and printing reports
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 2616 |
Tues Apr 6 |
8:30am-4:30pm |
|
# 2782 |
Wed June 2 |
8:30am-4:30pm |
|
