Microsoft Access 2003 - Level 2
Location: Latham
Ensure data integrity with normalized table structure, lookups, and
referential integrity. Create complex queries. Enhance forms and reports with
calculations and advanced features. Use PivotTables and PivotCharts.
Recommended Preparation:
Access 2003 -
Level 1 or equivalent knowledge.
Lesson 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Lesson 2: Working with related tables
- Lookup fields
- Modifying Lookup fields
- Subdatasheets
Lesson 3: Complex queries
- Joining tables in queries
- Creating calculated fields
- Summarizing and grouping
values
Lesson 4: Advanced form design
- Adding unbound controls
- Graphics
- Adding calculated values
- Adding combo boxes
|
Lesson 5: Advanced reports
- Creating customized headers and footers
- Adding calculated values
- Subreports
Lesson 6: PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
Lesson 7: Internet integration
- Hyperlink fields
- Working with data access pages
Optional Topic: Charts
- Charts in forms
- Charts in reports
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3074 |
Wed Sept 15 |
8:30am-4:30pm |
|
