Access 2016 is the database application in the Microsoft Office suite. Get Access help producing forms, queries, and reports using an Access database.
For more information about Access and an overview of what's included in this tutorial, view this video.
To understand Microsoft Access, you need to understand how an Access database works first. Get Access help with this free lesson.
In Access objects include tables, queries, forms, and reports. These objects in Access help keep your database usable.
Become familiar with the Access database environment, including Access help with the ribbon, navigation forms, and more.
When working with an Access database you're working with many Access objects simultaneously. Learn to manage them here.
In Access tables are arguably the most important object. Use tables in Access to store all of your data to run queries and reports.
In Access forms ensure you're entering the right data in the right location. Use forms in Access to keep your Access database accurate.
When working in Access sort data to make it easier to work with. In Access filter data as well so you see only what you want to see.
When designing an Access query it can be simple or more complex. In Access simple query guidelines let you pull important data.
When designing an Access query it can be simple or more complex. In Access complex query guidlines let you do more with data.
In Access query design is essential for getting the data you want. Use query design in Access to design almost any query you want.
An Access report lets you present data in a visually appealing way. Also use reports in Access to share data others can't manipulate.
There are many types of reports in Access 2016, as well as various advanced options for modifying an Access report. Learn them here.
Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.
Creating forms in Access can make entering data more convenient. Learn how to create and modify Access forms here.
Learn all about formatting Access forms to make your Access database look more professional, consistent, and user friendly.
In Access database design is a complex task that often requires training. Fortunately within Access templates exist to get you started.
An Access calculated field lets you calculate data. An Access totals row adds up an entire column of data. Learn how to use them here.
Learn how to run an Access parameter query to find the data you need using variable criteria in your search terms.
Learn how to run an Access duplicates query to erase duplicates. Use the Access find duplicates query to strengthen your database.
In Access query criteria is essential for a strong Access database. Use this query criteria quick reference guide for Access help.
If you'd like to work with Office 2016 download it online or buy the software from Microsoft. Learn about buying Office 2016 here.