Course Content
Access and VBA
- Course and Lesson Objectives
- Introduction to Access and VBA
- Your first VBA code
- VBA Structures, Variables, Comments, Constants
- More VBA Code
- Messages and Input Boxes
- Database Tables Design
- Database Tables Design
- VBA code
VBA and Forms
- Objectives
- The Database Tables
- Properties, Methods and Events
- The Database Table Relationships
- Creating the Members Table Form
- Adding fields to the Members Form
- Macros and VBA command buttons
- Finishing off the Members Form
Testing and Debugging
- Lesson Objectives
- Database with Members Test Data
- The VBA Editor
- The VBA Editor
- Testing and Debugging
- Testing and Debugging Part 2
- The Events Form
- Public Procedures
- Other Database Forms
- Database with Forms
Database Main Menu Design
- Objectives
- Main Menus and User Interface Design
- Main Menu Part 1
- Main Menu Part 2
- Main Menu Part 3
- Main Menu Part 4
- Login Form
- Login Form Part 2
- Database with Menu and Login
Further Database Development
- Objectives
- Database with Menu and Buttons
- Payments subform
- The results form modifications
- Membership Card Report
- Membership Card Report Part 2
- A stand alone installer database
- A stand alone installer database part 2
- The Final Database