Microsoft Access Level Two
1 or 2 day course depending on experience and requirements
This
course is aimed at delegates who understand the structure of Access
databases and how to create and edit basic Tables, Forms, Queries and
Reports. At the end of the course the learner will be able to customise
Access, create PivotTables and create and edit Macros. During the course
the learner will practice their skills with skill reviews and exercises.
An evidence of learning form will be completed during the course and
verified by the trainer. This can be used to prove competency in the areas
covered by the learner. A certificate of completion will also be issued.
·
Customising Access Menus and Toolbars
· Importing and Exporting Data
·
Setting Access Options Including Error Checking and Macro Security
·
Creating, Editing and Assigning Macros
· Exploring Advanced Macros
including Using the Visual Basic Editor
· Creating Data Access Pages
and using Existing HTML Pages
· Modifying Data Access Pages by Adding
Themes
· Creating PivotTables and PivotCharts
· Editing
PivotTables and Charts
· Using and Setting Up Parameter Queries
·
How to Create and Use Cross Tab Queries
· Establishing Referential
Integrity
· Using Cascade Update and Cascade Delete
· How to
Define Fields for Indexing
· Exploring Advanced Reporting Features
·
Setting up Advanced Queries and Normalizing Your Data
