Microsoft Access Database Development With VBA
Microsoft Access Database Development With DBA

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 shows how to visually and programmatically develop databases in VBA using the various libraries available in Microsoft Access 2016.

An electronic book (ebook) version of these lessons is available for purchase.
Lessons Summary
Microsoft Access Databases Topics
Creating a Database MAOL AXS-App DAO ADOX
Opening a Database MAOL AXS-App DAO ADOX
Creating a Table MAOL SQL DAO ADOX
Referencing a Table MAOL   DAO ADOX
Opening a Table MAOL   DAO  
Deleting a Table MAOL SQL DAO ADOX
Adding a Column MAOL SQL DAO ADOX
Deleting a Column MAOL SQL DAO ADOX
Adding a Record MAOL SQL DAO  
Updating a Record MAOL SQL DAO  
Deleting a Record MAOL SQL DAO  
 
SQL Keywords
ALL ALTER AND
AS ASC BETWEEN
BY CONSTRAINT CREATE
DEFAULT DELETE DESC
DISTINCT FOREIGN KEY GROUP BY
HAVING IN INDEX
INNER JOIN INSERT IS
KEY LEFT OUTER JOIN LIKE
NOT NULL OR
ORDER BY PRIMARY KEY REFERENCES
RIGHT OUTER JOIN SELECT TABLE
UPDATE VALUES WHERE
SQL Operations
+ * & [] <>
VBA Keywords
AND DO ELSE CASE ELSEIF
FOR GOTO IF IS NEXT
OR ORDERBY RESUME SELECT THEN
TO   OPTIONAL   WHILE
Microsoft Access Topics
Using a Win32 Function Not In List Combo Box Message Boxes
The Collection Class Input Boxes Enumerations
User-Defined Types   The Numeric System
Conditionally Opening a Form or Report
Example Applicatins Databases
Compound Interest Optical Disc Publisher
Bethesda Car Rental Fun Department Store
Georgetown Dry Cleaning Services College Park Auto-Repair
College Park Auto-Repair (File Processing)
College Park Auto-Repair (XML)
Calling an External Application - FunDS
Time Sheet Calculations
Built-In Functions
Choose IIf InputBox   MsgBox Switch
Windows Controls
Button Check Box Combo Box Label List Box
List View Radio Buttons Text Box Toggle Button Web Browser
Databases in Lessons
Databases Lessons
Altair Realtors1 7, 17
Altair Realtors2 37, 38
Brokerage Company1 23, 24
Brokerage Company2 25
Ceil Inn1 20
Eastern Shore Communications and Production Entertainment 29, 33
Fun Department Store1 27, 28, 39, 41
Gas Utility Company 28, 29
Kolo Bank 33, 34, 34, 39, 40
States Statistics1 19
States Statistics2 28, 35, 36, 37, 38
Sweet Star Clothers 29, 30, 34, 41
Watts' A Loan 30, 33, 34, 35, 40, 41
Whirl Water Shine 27, 28, 29, 40

Lessons Resources

Microsoft Access Microsoft Excel VB Language C# C++
FunctionX Press Microsoft SQL Server VBA Excel Visual C# Visual C++
  ASP.NET XML Visual Basic Java
Copyright © 1997-2018, FunctionX