Microsoft Access XP Intermediate

 
NORTHWIND SAMPLE DATABASE
- Installing The Northwind Database

DESIGNING TABLES IN ACCESS XP
- Normalizing Data
- Establishing Relationships
- Working With Indexes
- Working With Data Types

DESIGNING QUERIES IN ACCESS XP
- Creating Action Queries
- Creating Parameter Queries
- Creating Calculated Columns In Queries
- Joining Tables

DESIGNING FORMS IN ACCESS XP
- Creating Data Entry Forms
- Working With Subforms
- Creating Pop-Up Forms
- Working With Switchboards

DESIGNING REPORTS IN ACCESS XP
- Working With Standard Reports
- Working With Pop-Up Reports
- Working With Subreports
- Working With Report Snapshots
- Developing Data Access Pages

 
PIVOTTABLES AND PIVOTCHARTS IN ACCESS XP
- Creating Pivottables And Pivotcharts
- Creating Pivottable Forms
- Creating Pivotchart Forms

IMPORTING AND EXPORTING IN ACCESS XP
- Linking To External Data Sources
- Importing Data Into Access
- Exporting Data From Access

BUILDING EXPRESSIONS IN ACCESS XP
- Using The Expression Builder
- Using Common Built-In Functions