Microsoft Access 2016 Tutorial
Learn MS Access 2016, starting with the basics. Create a database, tables, add a form, query data, and more.
- 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
Microsoft Access 2016 is the eleventh full release of Access. Initially released in September 2015, it marks 23 years since the first version was released in 1992. Microsoft Access has come a long way since then.
Access 2016 is included in the Office 2016 suite (PCs only). If you have a copy of Access you'll be able to do all the examples. Even if you have an earlier copy of Access, you should still be able to complete the examples, as most of the tasks are basic, fundamental tasks that are inherent in most versions of Access.
This tutorial is for beginners. No knowledge of Access is required, although a basic understanding of databases will help.