MicroKnowledge Access XP/2003 Intermediate

Access XP/2003 Intermediate

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 XP/2003 Basic 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