How to Build an Access Database
This guide will show you how to begin to build your first MS Access database. Learning Access can seem like a daunting task, but once you get started you will discover the power of this tool.
Other People Are Reading
Things You'll Need
- Knowledge of Microsoft Office
- Patience to learn a valuable new skill set.
Instructions
-
-
1
Once you have opened MS Access 2007, click on create blank database. Name your database as prompted. Don't worry, you can change this name later if you need to and this doesn't effect the functionality of the database.
-
2
Click create. You will be taken to your first table. This is where you tell the database what your categories are. You will want categories for each piece of data you are collecting. For example, you may want categories for last name and one for first name and another for address.
-
-
3
Double click on the add new field heading. This will allow you to name the field. You can then name any other fields that you want in this table. Don't forget to click the windows button and then save as.
-
4
There is much more to MS Access. You can run powerful queries off the tables you create and create relationships between tables so data is matched up properly. You can create reports that pull data from tables or queries that you build. The reports will update as you update data to the table. You can also build custom forms that allow users to enter data or access queries and reports.
-
5
Hopefully I have gotten you interested in starting to learn about MS Access. You can become a valuable resource to your company or even better organized at home with the use of this tool.
-
1
