Learn Complete MS Access Basics [Guide]

Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a part of the Microsoft Office suite of applications, included in the professional and higher editions. This is an introductory tutorial that covers the basics of MS Access.

Audience

This tutorial is designed for those people who want to learn how to start working with Microsoft Access. After completing this tutorial, you will have a better understating of MS Access and how you can use it to store and retrieve data.

Prerequisites

It is a simple and easy-to-understand tutorial. There are no set prerequisites as such, and it should be useful for any beginner who want acquire knowledge on MS Access. However it will definitely help if you are aware of some basic concepts of a database, especially RDBMS concepts.

Chapters

Home

Overview

RDBMS

Objects

Create Database

Data Types

Create Tables

Adding Data

Query Data

Query Criteria

Action Queries

Create Queries

Parameter Queries

Alternate Criteria

Relating Data

Create Relationships

One-To-One Relationship

One-To-Many Relationship

Many-To-Many Relationship

Wildcards

Calculated Expression

Indexing

Grouping Data

Summarizing Data

Joins

Duplicate Query Wizard

Unmatched Query Wizard

Create A Form

Modify A Form

Navigation Form

Combo Box

SQL View

Formatting

Controls & Properties

Reports Basics

Formatting Reports

Built-In Functions

Macros

Data Import

Data Export