OBJECTIVES:
On completion of the course participants should have built on knowledge and skills gained on the Access Basic course and be able to use some of the advanced tools of Access to build a database application, linking and automating the objects in their database. The main focus of the second day will be in the use of Macros.
AUDIENCE:
Anyone needing to further enhance and automate Access databases. The course will not cover writing modules using Visual Basic.
DURATION:
Two Days
PRE-REQUISITES:
To have attended the two day Access Basic course and used the product since and be confident with most of the skills learnt, or to have used Access to create databases. You should have created databases including tables, forms, queries and reports and be at a stage where you wish to enhance it further. During the course you will work on databases that have already been created.
CONTENTS:
| Tables and Relationships | Sorting and Grouping Reports |
| Accessing data from other applications | Multi-User Databases |
| Expressions and Functions | Action Queries |
| Crosstab Queries | Form and Control Properties |
| Form and Report Templates | Running Macros from Command Buttons |
| Running Macros from Event Properties | Automating your Database |
| Pivot Tables | Pivot Charts |
Back to top