Microsoft Access 2003 Tutorial

See Microsoft Access Tutorial for a tutorial on a more recent version of Access.

This Microsoft Access tutorial is aimed at anyone who wishes to learn how to use Microsoft Access. It assumes a basic understanding of databases and how they work.

If you don't currently have an understanding of how databases work, don't despair - I have written a basic database tutorial just for you! That tutorial covers the basic concepts of databases, and the examples use Microsoft Access, so that will make it easier for you once you return here.

Table of Contents

This tutorial consists of the following lessons

  1. About Microsoft Access
  2. Create a Database
  3. Create a Table
  4. Adding Data
  5. Create a Form
  6. Modify a Form
  7. Create a Query
  8. Modify a Query
  9. Create a Macro
  10. Convert Access Database to Excel
  11. Microsoft Access versus SQL Server
  12. Summary

Update

Since this tutorial was written, there have been many subsequent updates to Access. Here's the latest Access tutorial.