Microsoft Access 2007 - 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 2007 -
Level 1 or equivalent knowledge.
Lesson 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Lesson 2: Related tables
- Lookup fields
- Modifying Lookup fields
- Subdatasheets
Lesson 3: Complex queries
- Joining tables in queries
- Calculated fields
- Summarizing and grouping values
Lesson 4: Advanced form design
- Adding unbound controls
- Adding graphics
- Adding calculated values
- Adding combo boxes
|
|
Lesson 5: Advanced reports
- Customized headers and footers
- Adding calculated values
- Subreports
Lesson 6: Charts
- Charts in forms
- Charts in reports
Lesson 7: PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
Optional topics
- Internet integration
- Hyperlink fields
- Working with Outlook 2007
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3207 |
Thur Oct 21 |
8:30am-4:30pm |
|
