Access VBA for Beginners: Day 2

Service Description

Access VBA for Beginners: Day 2 builds on the programming fundamentals introduced in Day 1 and shows participants how to use VBA to create more capable Microsoft Access applications. Participants move beyond individual lines of code and begin combining variables, conditions, loops, procedures, functions, forms, queries, and Access objects to solve practical database problems. The class also introduces techniques for working with records and handling errors so applications behave more reliably when something doesn't go as expected. Throughout the class, participants continue improving the database used in Day 1, transforming it from a basic Access database into a more automated application. By the end of Day 2, participants will be able to write, modify, test, and troubleshoot practical VBA code and will have a strong foundation for continuing into more advanced Access development. What You'll Learn Review Day 1 VBA fundamentals Create reusable Sub procedures Create custom Function procedures Pass information to procedures using arguments Return values from functions Understand variable scope Work with For...Next loops Work with For Each...Next Work with Do...Loop Use VBA with forms and controls Open forms and reports using VBA Filter records from code Run queries and Access commands Work with DoCmd Use DLookup, DCount, and other domain functions Work with records programmatically Introduction to DAO recordsets Find and update records with VBA Validate user input Build more sophisticated event-driven behavior Create basic error handlers Understand On Error Display useful error information Use the Immediate Window Step through and inspect code Debug common logic problems Organize code so it's easier to maintain