Microsoft Access Database Development With VBA
Microsoft Access 2010 Database Development With VBA

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.

Lessons Summary

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

The Structured Query Language (SQL)
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


Microsoft Access Microsoft Excel Windows C++ XML Delphi C# HTML ASP.NET (VB) VBScript Win32
FunctionX Press VBA Excel Microsoft SQL Server Visual C++ Microsoft Word Object Pascal Visual C# Oracle ASP.NET C# JavaScript Visual Basic

Copyright © 2000-2013 FunctionX