Microsoft Access Advanced Course Outline
Course Aims
This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations.
Course Outline
Database Design
Reviewing the Basics
Advanced Form Design
Using Advanced Form Features
The Form Worksurface
Creating a Calculated Control
Adding a Graphic to a Form
Multi-Table Forms; Using the Subform Control
Switchboard Forms
Working with PivotTables and PivotCharts
Creating PivotTables and PivotCharts
Creating PivotTable Forms
Creating PivotChart Forms |
Importing and Exporting
Linking to External Data Sources
Importing Data to Access
Exporting Data From Access
Working with Macros
Automating Tasks
Introducing the Macro Design Toolbar
Creating Macros; Testing and Debugging Macros
Modifying Macros
Conditional Programming in Macros
Adding Macros to Forms and to Reports
Filtering Data; Documenting Macros
Customising Access
Configuring Access Options
Configuring AutoCorrect Options
Customising Menus and Toolbars
Managing & Maintaining Databases
Optimising Databases with Table Analyzer and Performance
Analyzer
Documenting Databases with Documenter Analyzer
|
Target Audience
Existing users of Microsoft Access for Windows who wish to customise forms, queries and reports.
Assumed Knowledge
A basic knowledge of Microsoft Access gained through use of the product or by attending an "MS Access Intermediate" course.
Related Courses
Access Introduction and Intermediate; Windows; other MS Office Applications.
|
