To understand Microsoft Access, you need to understand how an Access database works first. Get Access help with this free lesson.
This tutorial will not teach you how to build a database from scratch. It is designed for people who plan to use a pre-existing database, most likely in the workplace.
The tutorial begins with a basic introduction to Access. You will become familiar with the structure of an Access database and learn how to navigate various windows and objects contained in it. As the tutorial goes on, you will learn how to enter information in a variety of ways. You will also learn how to sort, retrieve, and analyze information by running queries. After you understand how to use your database, you’ll be introduced to tools that let you modify its structure and appearance.
By the end of this tutorial, you will be able to use a database with confidence. You should also be able to alter it to best suit your needs.
If you’ve read the description and believe this tutorial fits your needs, go ahead and jump in. As mentioned, it is primarily designed to teach people how to use an existing database, but no matter what your eventual goal is this tutorial can provide you with a solid foundation.
If you’re planning to create a system to keep track of personal information, carefully consider whether you need the full functionality of Access in your database. While Access is an extremely useful tool, setting up a new database can be difficult and time consuming. If you don't necessarily need the full connectivity of a relational database, consider managing your information with Excel instead. If you decide to create your own database, review our lesson on Designing Your Own Database for resources on database creation.