How to Create a Microsoft Access Database

Microsoft Access is a comprehensive database application available as a standalone program or as part of Microsoft's Office suite of programs. Databases are a data filing system designed to have information located in a single place that is easily accessed by the source program. While typically used in a business environment, databases can be used for personal data storage as well. By following a few simple steps, you can create an Access database.

Instructions

1. Download the Microsoft Access application. If you do not have the program, check out the link below.

2. 

   Launch Microsoft Access. Click once on the "Blank Database" link on the "New File" task pane.

3. 

   Use the "Save in" drop down menu to select a folder in which to save the database. Change the name of the file, if necessary, by typing into the "File name" field. Click once on the "Create" button.

4. 

   Double click on the "Create table by using wizard" listing on the Database pop up window. This is the easiest option if you are new to creating databases.

5. 

   Use the "Table Wizard" to select a type of table to create. The Table wizard has many sample options for personal and business use. In this example, a personal address table is selected. After you select the type of table you want to create, click once on the single arrow to move individual field categories that you want to use for your table. Click once on the double arrow to move all of the categories at one time. Click once on the "Next" button after you have finished selecting fields for your table.

6. 

   Change the name of your table from the default name by typing into the "name" filed. Decide whether or not you want the "Table Wizard" to create a primary key for your table. While you can assign the primary key on your own, allowing the "Wizard" to assign it could save confusion if you are new to the process. Click once on the "Next" key.

7. 

   Choose how you want to enter the data into the table. The "Table Wizard" offers three options. Experienced users may choose to modify the table. Inexperience users should select to enter data directly into the default table or one that the "wizard" creates. Click once on the "Finish" button after you have made your selection.

8. 

   Enter the data into the table. You will notice in the example, that the primary key automatically numbers each entry. You can switch from field to field by pressing the "Tab" key one, or by clicking once in each field. Make certain to click once on the save button from time to time to ensure your database information is saved.

References

• Microsoft Access Help Page

Resources

• Microsoft Access Downloads Page