Access with VBA

• Course Overview
• Course Content
• Customer Reviews

Course Overview

---

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Access with VBA which gives you the opportunity to interact with a Access with VBA instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

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

Customer Reviews

---

---

---

...more