The Northwind Database
- Installing the Northwind Database
Designing Tables in Access
- Normalising Data
- Establishing Relationships
- Working With Indexes
- Working With Data Types
Designing Forms in Access
- Creating Action Queries
- Creating Parameter Queries
- Creating Calculated Columns in Queries
- Joining Tables
| Designing Forms in Access
- Creating Data Entry Forms
- Working with Subforms
- Creating Pop-Up Forms
- Working with Switchboards
Designing Reports in Access
- Working with Standard Reports
- Working with Pop-Up Reports
- Working with Subreports
- Working with Report Snapshots
- Developing Data Access Pages
|
Working with Pivot Tables and Pivot Charts
- Creating Pivot Tables and Pivot Charts
- Creating Pivot table Forms
- Creating Pivot chart Forms
Importing and Exporting
- Linking to External Data Sources
- Importing Data into Access
- Exporting Data from Access
Building Expressions
- Using the Expression Builder
- Using Common Built-In Functions
|
