Microsoft Access is a development environment used to create computer-based databases. To complement it, it ships with a programming language called Visual Basic For Application (VBA) and various libraries. This language and the libraries are used in a programming environment called Microsoft Visual Basic, which also ships with Microsoft Access.

This series of lessons teaches how to develop databases using VBA in Microsoft Access 2010. Some of the lessons assume that you already know Microsoft Access.

Resources for the Lessons

Data Analysis (MS Access) Data Analysis With SQL Introduction to Data Selection Filtering Records Sorting Records Sorting Records Microsoft Access Topics Conditionally Opening a Form or Report Data Joins Changing the Recordd Source of a Form     Create a Database MAOL AXS-App DAO ADOX Open a Database MAOL AXS-App DAO Create a Table MAOL DAO SQL ADO ADOX Reference a Table MAOL DAO ADOX Open a Table MAOL DAO ADO Delete a Table MAOL DAO  SQL ADO ADOX Add a Column MAOL DAO SQL ADOX Delete a Column MAOL DAO SQL ADOX Create a Record MAOL DAO SQL Delete a Record MAOL DAO SQL ADO Create a Query MAOL DAO * MAOL: Microsoft Access Object Library * AXS-App: Access.Application * DAO:  Microsoft Data Access Object Library * ADO: Microsoft ActiveX Data Object * ADOX: Microsoft ActiveX Data Object Extensions for Data Definition Language and Security Example Applications/Databases Compound Interest Optical Disc Publisher   Bethesda Car Rental Fun Department Store Georgetown Dry Cleaning Services

SQL Operators * +  & [] <>   SQL Keywords ALTER ALL AND AS ASC BETWEEN BY COLUMN COUNTER CREATE DELETE DESC DISTINCT DISTINCTROW DROP FROM GROUP IN INSERT INTO IS LIKE NOT NULL OR ORDER PRIMARY REFERENCES SELECT TABLE VALUES   WHERE Databases Topics Message Boxes Input Boxes User-Defined Types Enumerations The Collection Class Using the Win32 API Not In List (Combo Box)     Windows Controls Check Box Combo Box Label Text Box VBA Access 2007