Microsoft Access Database Development

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

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

	* MAOL:	Microsoft Access Object Library
	* MAOL:	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

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

Microsoft Access 2010 Database Programming With VBA

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


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