Access Advanced 6 continues our in-depth study of Macros and Event Programming. If you're serious about building quality databases with Access, and you want to learn how to automate your database with Macros and Events, which is a good pre-cursor to VBA programming then don't miss out on this course. Contents include:
- SQL Search Field Boxes
- Build Dynamic SQL Statements
- Separate WHERE Conditions
- Data Macros
- Macros Tied to Changes in Table Data
- Before Change Event in Table
- Automatically Calculate Unit Price w Cost
- After Update Event in Table
- Create a System Log Table
- Lots more
Click here for more information on Access Advanced 6, including a course outline, sample videos, and more. This course was recorded using Access 2016, but most of the topics covered are valid for all versions of Access from 2007 on. This class follows Advanced Level 5. The next class in the series is Developer Level 1.