Microsoft Access - Advanced
Microsoft Access 2002, 2003 or 2007
Prior Knowledge:This one-day course aims to build on a reasonable level of database design experience that may have been gained from attending the Microsoft Access Introduction course and the Microsoft Access Intermediate training course. This module introduces you to macros and custom toolbars. Tasks include creating and using macros and working with switchboards. You will also learn how to create custom toolbars and export data to Excel and Word.
Aims and Objectives
By the end of the course participants will be able to understand
- Database Concepts & Design
- Types of Relationship
- Creating Links & Referential Integrity
- Using Switchboards
- Create, opening and use a switchboard form
- Adding a command button to a switchboard
- Setting startup options
- Working with macros
- Opening the macro design window
- Creating a macro Assigning an argument to an action
- Saving a macro
- Running a macro
- Editing an existing macro
- Running a macro using the Tools menu
- Assigning a macro to a control
- Creating a command button
- Adding a condition to a macro
- Creating a group macro
- Creating an Autoexec macro
- Creating a Custom Toolbar
- Exporting Data to Excel and Word
