
Excel
Macros and VBA
Learn to automate Excel with Macros and the VBA programming language
- VBA terms and syntax
- Create and record macros
- Variable and constants
- Interacting with users
- Decision structures
- Loops
This is a 12-hour course

Excel
VBA Forms
Learn to enhance your macros with user-friendly fill-in-the blank VBA forms
- Create forms
- Add labels, text boxes, images, drop downs, buttons, check boxes and more
- Program the form
- Update sheet with form data
This is a 6-hour course

Access
Overview
Overview course ideal for those who need to understand and use an existing Access database.
- Parts of an Access Database
- Front- and back-end files
- View, enter and delete data
- Find and sort data
- Run reports
- Create simple queries
This is a 6-hour course

Access
Introduction
Provides an introduction to building Access databases.
- Parts of an Access Database
- Using Views
- Fields, Records and Tables
- Basic Table Relationships
- Create Queries
- Create Forms
- Create Reports
This is a 6-hour course

Access
Queries
Learn to create simple and advanced queries to extract database data
- Review Query Basics
- Query Calculations
- Multi-table Queries
- Sorting and Filtering Data
- Interactive Queries
- Exporting Queries to Excel
This is a 6-hour course

Access
Action Queries
Learn to create action queries and advanced select queries.
- Update Queries
- Append Queries
- Make-table Queries
- Delete Queries
- Cross-tab Queries
- SQL Queries
- Union Queries
This is a 6-hour course

Access
Forms and Reports
Learn to develop and modify forms and reports
- Edit existing forms and reports
- Keyboard shortcuts
- Properties, anchors and layouts
- Headers and Footers
- Drop-downs list boxes, buttons and images
This is a 6-hour course

Access
Advanced Forms & Reports
Create advanced forms and reports in Microsoft Access.
- Option Groups
- Toggle buttons
- Sub-forms and sub-reports
- Tabs for multiple layers
- Dialog boxes
- Linked forms
- Dynamic reports
This is a 6-hour course

Access
Macros
Lean to automate your database with Access macros.
- What is a macro?
- Create a general purpose macro
- Create an embedded macro
- Make macros interactive
- AutoKey macros
- AutoExec macros
This is a 6-hour course

Access
VBA
Learn to automate your Access database with the Visual Basic for Applications programming language.
- Modules vs Macros
- Converting macros into modules
- Learn the VBA language
(Objects, Properties, Methods, and Arguments) - Event driven programming
This is a 12-hour course

Access
Special Topics
A custom course where you pick one or more special topics. Here are some examples:
- Create a menu
- Add user security and password protection
- Email from Access
- Interface with Excel, Word or PowerPoint
- Any additional topic of your choosing.
Usually a 6 hour course