Welcome to RABBOTT.COM	How to Create a Database File In Microsoft Access

Back

1. Be sure you have your data ready to put into a database file. Decide on the fields (categories) you need for your data. Example: Name, Address, e-mail, etc..

2. Log in and choose Microsoft Access.

3. In the box that appears on the right, choose "Blank Database".

4. Tell the computer to save your work in your personal folder. In "File Name" type in the name for your file and click CREATE.

5. In the next window, click on the TABLES box. Click on the NEW box. Then double click on "Create Table in Design View."

6. In the "New Table" box, click on "Design View" and click OK.

7. Type in the name for each field, then click the down arrow. Each field should be in a separate box. Examples: Name, Address, E-mail, etc.

8. Close the table by clicking on the X in the upper right corner. (Answer YES when the computer asks you if you want to save the changes in the design of the table.)

9. Type in a name for your table and click OK. Your table name can be different from you’re your file name. You can have more than one table in a file.

10. Click NO in the "Primary Key" box unless you want the computer to automatically number your data entries. (In that case, answer YES.) Your table is saved.

11. Click on the name of your table in the window. Click on the OPEN box to enter your data.

12. Type information into a box and type ENTER. If you do not have information for a box, leave the box blank and just type ENTER. Be sure to put the proper data in the proper field. NOTE: Information in any field can be added or changed at any time.

13. When you finish typing, click the X in the upper right corner of the box. Your data will be saved for you.