Objective:
Participants will learn the advanced level of Microsoft Access 2003
Course Outline
1. Microsoft Access 2003 Advanced By CCK
- Importing And Exporting
- Linking To External Data Sources
- Importing Data Into Access
- Exporting Data From Access
2 Designing Tables In Access 2003
- Normalizing Data
- Establishing Relationships
- Working With Data Types
3 Designing Queries In Access 2003
- Creating Action Queries
- Creating Parameter Queries
- Creating Calculated Columns In Queries
- Joining Tables
4 Designing Forms In Access 2003
- Creating Data Entry Forms
- Working With Subforms
- Working With Switchboards
5 Designing Reports In Access 2003
- Working With Standard Reports
- Working With Subreports
6 Macros
- What Is A Macro?
- Conditional Actions
- Action Arguments
- Create A Macro
- Run Macros
7 Security
- Overview Of Access Security
- Create, Change, Or Remove Passwords
- About User-Level Security
8 Building Expressions
- Using The Expression Builder
- Using Common Built-In Functions
|