When you open Access 2007 for the first time you will see this screen

Click on the circle on the top left and choose New

Choose Blank Database

On the right you can name the file of the database, for the purpose of this tutorial we will leave it as Database1.accb

Now that the database is setup we will see this screen

Double click on the top of the column and you will be able to rename it. For the purpose of this tutorial we will create an address book.

For the purpose of an introductory tutorial we will keep the database simple so we will have all of the address book items in one database.
Note: Because we plan to name this table “person” we prefix the name of the columns with “person_” this will help later in the tutorial. When naming the table or the columns you should stick with a delimiter such as a “-“ or “_” as most databases and functions within this database a space will either not work or cause problems.

Now we want to rename the table so we need to click on the X on the right (make sure you aren’t clicking on the top right X as that will close the program)
You will get a dialog box similar to the one in this picture; click yes to commit the changes to this table

Once you click on yes you will see a dialog box that is asking for the name of the table, for the purpose of this tutorial name the table “person”.

Once you click on “OK” the table will close, go ahead and double click on “person : Table” so we can add some more columns to this table.
Again, when you are done adding the columns click on the X to save the table
The columns that we will have when we are done are:
1. person_id
2. person_lname
3. person_mname
4. person_fname
5. person_gender
6. person_title
7. person_suffix
8. person_company
9. person_business_street
10. person_Business_Street_2
11. person_Business_City
12. person_Business_State
13. person_Business_Postal_Code
14. person_Business_Country_Region
15. person_Home_Street
16. person_Home_Street_2
17. person_Home_City
18. person_Home_State
19. person_Home_Postal_Code
20. person_Home_Country_Region
21. person_Business_Fax
22. person_Business_Phone
23. person_Business_Phone_2
24. person_Company_Main_Phone
25. person_Home_Fax
26. person_Home_Phone
27. person_Mobile_Phone
28. person_Pager
29. person_Account
30. person_Birthday
31. person_personal_email
32. person_work_email
33. person_Spouse
34. person_web_page

Ok so now that we have the columns done we need to fill them with some information.
For this tutorial start by inputting in:
Mr. John A. Doe Sr. John Doe’s Bait Shop 123 Some St. Suite 2 Some City, MI 48746 USA
Mr. John A. Doe Jr. John Doe’s Bait Shop 123 Some St. Suite 2 Some City, MI 48746 USA
Mrs. Jane A. Doe Jane Doe's Boutique 123 Some St. Suite 1 Some City, MI 48746 USA

Ok now we have a table within a database.

Next we will work on creating a query to use some of the information that we have in our table

Because we only have one table we will simply click “Add”

Click on “Close”

In this new window that opened you can click on the items that you want or need to query, for sake of the tutorial we will start with
person_fname person_lname person_suffix person_company

On the top left you will see “Run” with a red exclamation point, click on that

With this basic query we are able to see the person and the company name.

This is nice but we still don’t have contact information so we will click on the “View” button on the left and you will get back to looking at your query.