Microsoft Access VBA - Create your own Databse applications

Learn VBA fundamentals for Access, including keywords, statements, procedures, subroutines, functions, modules, and variables, and understand how VBA code is shared across Office apps.

Explore how Microsoft access objects, including tables, forms, queries, and reports, relate via collections, and learn key concepts—methods, properties, and events—for automating these objects with code.

Master VBA branching constructs in Access, using if then else and selected statement, applying date function to check if start and end dates exceed a year, with a message box.

Automate Microsoft Access VBA reporting with a select case driven by an option box to generate, save, print, email, or export to Excel using DoCmd.

Create a public VBA function that opens a save-as file dialog, captures the chosen path and file name, and saves reports to a user-selected destination.

The lecture shows that in VBA, the sequence of statements matters: declare and initialize variables, then execute functions to print, generate, or email reports.

Action queries automate updates, appends, deletes, and make-table tasks, enabling repetitive analyses without exporting to Excel; disable alert confirmations in Access options and restart the database.

Explore delete queries for selective data removal, then validate, append, and update records with a small project that transfers data to sales and produces an exception report.