This Microsoft Access tutorial will show you how to use Microsoft Access to create a simple database with all the common features such as tables, forms, queries, and macros.

This tutorial is for beginners. No prior database knowledge is assumed.

This is a three-part tutorial. It consists of the following articles.

Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields

Here’s what’s included in this article:

  • Create a blank database.
  • Create a table.
  • Add four fields to the table, name/rename them, and set up their data type.

Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships

Here’s what’s included in this article:

  • Design view.
  • Add field properties to a field.
  • Add two more tables (for the relationship)
  • Set up a relationship between three tables.

Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros

Here’s what’s included in this article:

  • Create a query (so you can “search the database”).
  • Create a form for data entry.
  • Create a macro (so that a multi-step task can be done automatically – at the click of a button).

About Microsoft Access

Microsoft Access (commonly referred to as “MS Access” or just “Access”) is a relational database management system (RDBMS). It allows you to create and maintain relational databases.

Access provides an easy way for non-technical users to start building databases. It also provides an easy way to create forms for data entry, and reports for emailing and printing.

Access even provides “wizards” that guide you through some of the most common tasks.

These features help make Microsoft Access one of the easiest database systems to learn.