Microsoft Access Tutorial
Learn Microsoft Access, starting with the basics. Create a database, tables, add a form, query data, and more.
This tutorial uses Access 2016. For other versions, see below.
- Introduction to Access
- Create a Database
- Create a Table
- Create a Table in Design View
- Create an Input Mask
- Add Data to Table
- Import Data from a CSV File
- Create a Relationship
- Create a Lookup Table
- Create a Query
- Create a Query with User Input
- How to use the Expression Builder
- Export Data to Excel (and XML)
- Create a Form
- Add a Combo Box to a Form
- Create a Report
- Create a Macro
- Backup a Database
- Split a Database
- Make an Executable Database
- Install the Northwind Database
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.
More Access Tutorials
-
Access "How To" Articles
Large list of "how to" articles that show step-by-step instructions for doing common tasks in Access.
Includes mini-tutorials for doing things like, creating a totals row, creating a parameter query, password protecting your database, doing a mail merge, and much more.
Go to Access Howto -
Introduction to Databases
If you don't currently have an understanding of how databases work, no worries — I have written a basic database tutorial just for you!
This 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.
Go to the Database Tutorial
Previous Versions of Access
Here are tutorials from previous versions of Access.
-
Access 2013 Tutorial
Microsoft Access 2013 is the predecessor to Access 2016. There's not much difference in functionality between Access 2016 and 2013, so you could do both tutorials with either 2013 or 2016.
Go to Access 2013 Tutorial -
Access 2003 Tutorial
Check out what Access used to look like back in 2003! See how far Access has come since the early days.
Go to Access 2003 Tutorial