How to Create Your

Friends and Family Database File

(updated for Access 2002)

Here are the steps to follow to create your Friends and Family database file on Microsoft Access. Please read and follow the directions carefully.

1. Be sure you have your list of names, addresses, and phone numbers (of family and friends). You must put at least 5 people into your data base file.

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 "Friends" 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. Your fields should be Last Name, First Name, Street Address, City, State, Zip, Phone, E-mail.

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 – call it Friends and Family – and click OK.

10. Click NO in the next box (Primary Key). Your table is saved.

11. Click on the name of your table - Friends and Family – in the window. Click on the OPEN box to enter data (the actual names and addresses).

12. Type information into a box and type ENTER. If you do not know some information, leave the box blank and just type ENTER.

13. When you finish typing, click the X in the upper right corner of the box. Your data will be saved for you. You may now exit Microsoft Access.

Back