Microsoft Access 2003 Training – Level 3
Delegates completing the Access advanced course will be able to use the full functionality of this powerful programme and its many features. This is of particular relevance to anyone wishing to produce professional relational databases that can be used to provide multiple reports from complex and varied data.
The shortcuts and benefits that the delegates take away from the course will save anyone involved in the production of complex databases hours in producing them, and a deeper understanding of the extent and variety of reports that can be gleaned from the data. This includes the creation of a switchboard, Macro techniques, cross tab and aggregate queries.
Course Outline:
Crosstab Queries - Creating A Crosstab Query
- Modifying A Crosstab Query
- Formatting Crosstab Query Values
- Basing A Crosstab Query On A Query
- Using Criteria In Crosstab Queries
- Adding Parameters To A Crosstab Query
Aggregate Queries - Creating An Aggregate Query
- Working With Aggregate Queries
- Creating Queries With Multiple Aggregates
- Aggregating Calculated Fields
- Applying Criteria To Aggregates
- Creating An Aggregate From A Query
Macros - Creating A Macro
- Running A Macro
- Modifying An Existing Macro
- Documenting Macros
- Creating A Print Macro
- Using Conditions To Enhance A Macro
- Creating A Sequence Of Conditions
| Macros On Forms - Creating An Event Macro
- Creating A Group Macro
- Setting Form Properties
Data Access Pages - Creating A Data Access Page
- Apply A Theme To A Data Access Page
- Working With Data Access Pages
Creating A Switchboard - Creating A Switchboard
- Creating Sub Menus
- Creating A Menu Item
- Linking The Menus
- Modifying The Menu Forms
- Changing The Startup
|
