FunctionX Press FunctionX Microsoft Access C# Visual C# ASP.NET (C#) Java Visual Basic ASP.NET (VB) SQL Server Visual C++/CLI
Microsoft Access Database Development With VBA
Microsoft Access 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 computer databases using Microsoft Access and VB. These lessons were developed using Microsoft Office Access 2007. Some of the lessons and topics assume that you already know a little bit about form and report design using Microsoft Access and its Ribbon.

Lessons Summary

   

Databases How -To

Databases How -To Create a Database MAOL AXS-App DAO ADOX
Open a Database MAOL AXS-App DAO
Create a Table MAOL DAO SQL ADO
Reference a Table MAOL DAO
Open a Table MAOL DAO
Delete a Table MAOL DAO  SQL ADO
Add a Column MAOL DAO SQL ADO
Delete a Column MAOL DAO SQL ADO
Create a Record MAOL DAO SQL ADO
Update a Record MAOL DAO SQL ADO
Delete a Record MAOL DAO SQL ADO
Create a Query MAOL DAO
Delete a Query MAOL DAO  SQL ADO
Example Databases * MAOL: Microsoft Access Object Library
Access.Application
* 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 Databases

SQL Operators and Keywords
Compound Interest
This is an example of calculating the interest accrued on a loan. The calculations are performed depending on an interest rate and the type of frequency (monthly, annually, etc).
 

Databases Created or Used in the Lessons

Exercise1: Lesson 2, Lesson 3, Lesson6
Exercise2: Lesson 4, Exercise 5, Lesson 11
gcs1: Lesson9, Lesson 10
cpar1: Lesson 11, Lesson13
Solas Property Management1: Lesson 15
 
Lessons Resources
Previous Version of this Web Site

 

SQL Operators and Keywords

* +  &
[] <>  ADD
ALTER ALL AND
AS ASC BETWEEN
BY COLUMN COUNTER
CREATE DELETE DESC
DISTINCT DROP FROM
GROUP IN INSERT
INTO IS LIKE
NOT NULL OR
ORDER PRIMARY REFERENCES
SELECT TABLE
UPDATE VALUES WHERE
 

Databases Topics

Message Boxes Input Boxes
Enumerations User-Defined Types
The Collection Class Using the Win32 API
Not In List (Combo Box)
 

Windows Controls

Check Box Combo Box Label
Text Box
 
 

Sample Solved Exercises

Georgetown Cleaning Services

This is a better version of the application of the same name referred to in the lessons. This time, we use the DateTimePicker control to help the user specify when the cleaning items and dropped and when they are expected.

Payroll

This application simulates the calculation of overtime in a payroll simulation

CD Publisher

This examples shows how to use the UpDown ActiveX control

 
 

C# Key Win32 Microsoft Excel Microsoft Access ADO Object Pascal C++/CLI StarImpress SQL JavaScript
Yevol.com Visual Basic 6 VBA Excel Visual Basic Language Oracle Delphi C++ Builder MS PowerPoint HTML VBScript

Copyright © 2005-2011 FunctionX, Inc.