FunctionX Tutorials

Lessons

Introduction to VB Access

Objects and Collections

Data Types and Variables

Procedures and Functions

Built-in Procedures and Functions

Built-in Objects and Collections

Conditional Statements

Error Handling

The Forms of an Application

The Structured Query Language

The Windows Controls of a Form

The Tables of a Database

The Columns and Rows of a Table

Data Entry

Introduction to SQL

The Records of a Table

DAO

The Reports of a Database

Introduction to ADO

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). This site provides lessons, examples, and tutorials on how to use VBA in MS Access.

Topics

Data entry using the DataRow class
VB.NET	VC#	VC.NET

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
	Survey Creation
	This exercise is an approach to creating a survey using (only what is available in) Microsoft Access. We also cover creating a sample (pie) chart.
	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).
	Convenience Store
	This exercise is inspired from watching how a convenience store is managed in a village or small town.
	The Associates
	This example examines a technique used in some communities to save money without involving a bank.

Topics

Default Values

Combo Box New Item

Pass Argument By Value

Call a Procedure

Controls

Scroll Bars

Progress Bar

Up Down

Last Update: Thursday, August 18, 2005 19:48

Exercises: These are the files supposed to accompany the lessons of this site. If something is wrong with them, please let me know because I haven't checked them for a while. Download

     Topics

Fearing to open your (too many) bills will not make them go away. Find a way to deal with them. You know, they ain't going nowhere! Pseudo-Variables

The Command Button Wizard

Order Entry Form

Tax Amount Calculation

     How-To

Print an Invoice

Create Default Values

Add a New Record

This allows you to create a semi-independent form that a clerk can use to perform data entry

Add New Item From a Combo Box

Pass Argument By Value

Call a Procedure

Update Many Records

Here are two examples of updating records. In one example, we update some records based on a criterion. In another example, we update all records of a particular column.

     Controls

Scroll Bars

Progress Bar

Up Down

     Resources

Annie's Carry Out

Samples Databases

Some sample databases we work on some time to time. Some of them are not complete, meaning you can take over and correct them.
We have also included the sample databases that shipped with Microsoft Access 97 but that were not found in MS Access >= 2000

MOUS Topics

These are the same Microsoft Office User Specialist (MOUS) topics you can find on the Microsoft certification web site. They allow us to check on this site what topics we have covered or forgotten.

      Examples

Tick Counter

CD Publisher

Color Changer

Progressive Clock

Handy External Articles

How to Display Images in a Form or in a Report Without Storing the Images in a Table

Last Update: Thursday, August 18, 2005 19:48

Web functionx.com