Getting Started

Optimizing Access Applications

When Microsoft introduced 32-bit Access, a number of new performance concerns came part and parcel with the new features and functions. Microsoft continues to make a conscious effort to enhance the performance of the Access database engine. Read more...

Creating Tables and Inserting Records

Learn how to create a table and insert records into a table. You will learn about data types, field sizes, and constraints. You will also learn how to update and delete records in a table. Read more...

Automating with Macros

This tutorial discusses how to create macros and how to attach them to events to get the desired response. See how to use macros to find records, display custom dialog boxes, and create an opening home document for an application. Read more...

Strings and Functions

This tutorial covers how to handle strings of text, how to use the built-in functions of VBA, and how to design professional message boxes. Read more...

Deployment

This tutorial covers the following: Creating a build process for Access-based applications. Ensuring that application dependencies are taken care of. Updating an application Licensing and registration. Read more...

Understanding SQL

This tuorial contains two major sections: SQL select queries and SQL action queries. Within the first section, you can find keywords used in SQL in alphabetical order. Read more...

Using DAO to Access Data

VBA is the programming language you use to programmatically interact with the Access object model. You use VBA to manipulate Access-specific objects, such as forms, reports, and so on. Read more...

Creating Select Queries

The many different types of queries that Access provides give you many different ways to select and view specific data in your database. Read more...

Creating and Editing Reports

Reports are the best way to put information from your database onto paper. In a report, you can choose how to display your data, including which information to include (which tables and fields). Read more...

Programming Basics: Decisions and Looping

When writing programs, it's important to understand how programs make decisions and perform looping. Looping is the process of carrying out the same set of instructions until certain conditions are met. Read more...