Microsoft Access 2016

Access 2016 is the database application in the Microsoft Office suite. Get Access help producing forms, queries, and reports using an Access database.

Microsoft Access 2016 provides a rich platform for developing database management solutions with easy-to-use customization tools. If no end-user customization is required (including report modifications), you can choose to distribute those Access 2016 solutions so that they run without requiring a full installation of Access 2016. To do so, you must package and distribute your application with the Access 2016 Runtime.

Access Basics

1. Introduction to Databases
2. Introduction to Objects
3. Getting Started in Access
4. Managing Databases and Objects

Working with Data

1. Working with Tables
2. Working with Forms
3. Sorting and Filtering Records

Running Queries and Reports

1. Designing a Simple Query
2. Designing a Multi-table Query
3. More Query Design Options
4. Creating Reports
5. Advanced Report Options

Database Design Tips

1. Modifying Tables
2. Creating Forms
3. Formatting Forms
4. Designing Your Own Database

More Access Tasks

1. Calculated Fields and Totals Rows
2. Creating a Parameter Query
3. Find Duplicates Query