Microsoft Access - Macros and Introduction to Prog
| Duration- | 2 Days |
| Objectives- | To build on a reasonable level of database design experience that has been gained from the Introduction and/or Intermediate course. |
| Who Should Attend- | People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases. Sharing and security is also covered. |
| Experience- | This course assumes a reasonable level of database design principles. |
1 Access Macros
-Using Access 97 Built in Macros
-Access (Basic) Macro Sequences
-Assigning Macros to Command Buttons
-Using Macros in a Menu System
-Creating a Basic Menu System with Macros
2 Access 97 Macros Built in VBA
-Overview of VBA
-Macros
-Creating Macros
-Opening a Macro
-Adding and Action to a Macro
-Opening the Macro or Module Windows from a Form or Report
-Creating a Macro
-Creating a Macro Group
-Setting Action Arguments in a Macro
-Entering an Expression in a Macro Action Argument
-Using Conditions in a Macro
-Running a Macro
-Running a Macro from another Macro, or from a Visual Basic Procedure
3 Controls I
-Controls
-Labels
-Text Box
-Check Box
-Option Button
-Option Group
-Toggle Buttons or Option Buttons
-List Boxes
-Combo Boxes
-Drop-down List Boxes
Please note that sections of this course can be mixed with other courses to create your own bespoke training package.