Other Tutorials

Databases

MS Access 2007
MS Access 2003
SQL Server
ADO
ADO.NET

Web Development

HTML
ASP
ASP.NET
VBScript
JavaScript
FunctionX FunctionX Press MS Access Visual Basic C++ Builder C# Visual C#


Libraries
  Microsoft Access
  VBA
  SQL
  DAO
  ADO
  ADOX
 

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 FunctionX site provides lessons, examples, and tutorials on how to use VBA in MS Access.
An electronic book (ebook) version of this site, with additional materials, is available for purchase.

Fundamentals

Windows
Computer Networking

Computer Languages

C++
C++/CLI
Managed C++
C#
VBasic
J#
Java
Object Pascal

Programming Environments

Visual Basic
Visual Basic .NET
Visual C++
Visual C++ .NET
C++ Builder
Visual C#
Visual J#
Delphi

Presentations

MS PowerPoint
StarImpress

Spreadsheets

MS Excel
StarCalc

Libraries

Win32
XML.NET

References

Numeric System
Geometry
Links
I am a MOUS Master
 

Lessons

1.   Introduction to VB Access 13. Details on Data Entry
2.   Objects and Collections 14. Data Entry and Built-In Functions
3.   Data Types and Variables 15. The Queries of a Database
4.   DAO, ADO, ADOX, and SQL 16. Printing
5.   Procedures and Functions 17. Relationships and Data Integrity
6.   Conditional Statements 18. Data Joins
7.   Error Handling 19. Details on Creating Queries
8.   The Tables of a Database 20. Data Analysis
9.   The Columns of a Table 21. Using Queries
10. The Forms of an Application 22. Introduction to Record Sets
11. The Windows Controls of a Form 23. Data Views and Stored Procedures
12. The Records of a Database
 

Sample Solved Exercises

Time Sheet

This is an example of locating a record in a table and taking action accordingly. For example, it checks if a record exists already. If so, it would be updated. If it doesn't exist yet, then a new one is created.

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).

 

Topics

Update Many Records
Create Default Values
Toolbars
Call a Procedure
Combo Box (Not In List)
 
Examples
 Tick Counter
 CD Publisher
 Color Changer
 Progressive Clock
Controls
Scroll Bars
Progress Bar
Up Down
 
 

How-To

General

ADO

Microsoft Access and DAO

Print an Invoice
Conditionally Open an Object
Pass Argument By Value
Locate a Record
Add a New Record
Create and Execute a Command
Update Many Records
Edit a value of a cell
Add a New Record
Edit a Record
 
 

How-To General Topics

Find the Name of the Week for a Date
List the values of a particular column throughout a table
 

ADO.NET

Data entry using the DataRow class

VB.NET VC# VC.NET
 
Handy External Articles
 

Last Update: Tuesday, December 07, 2010 08:50

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

 

Databases Created

Database

Start

Continue

End

Department of Records and Statistics Lesson 1 Lesson 14
Exercise1 Lesson 2, Lesson 3 Lesson 4
Exercise2 Lesson 3 Lesson 5
Exercise3 Lesson 6
GCS1 Lesson 8 Lesson 9 Lesson 10
GCS2 Lesson 11 Lesson 12
College Park Auto Shop1 Lesson 12 Lesson 13
Solas Property Management Lesson 14 Lesson 16
ROSH Lesson 15, Lesson 16 Lesson 22
Yugo National Bank Lesson 16 Lesson 17, Lesson 19 Lesson 21
Car Inventory Lesson 18
Solas Property Rental Lesson 20 Lesson 21

 

 

Mirror Site Copyright 2002-2009 FunctionX, Inc.