How to Make a Phone Book in Access

By Qiana Eaglin

Phone book
i phone book image by Jovan Nikolic from

Microsoft Access is a database that you can use to create a personal phone book. In Access, a phone book is a report you can customize to display the contact information for your family, friends, and business associates. You can customize your phone book to include such information as first name, last name, address, phone numbers, and email address.

Access 2007 supplies you with several templates that make it easier for you to create a phone book. You can use a template as is or modify it to meet your specific requirements.

Open Access by clicking "Start" > "Programs" > "Microsoft Office" > "Microsoft Office Access 2007." This will open the Getting Started with Microsoft Office Access window.

Click "Contacts" under the Featured Online Templates section.

Specify a file name for your address book, and then click "Download." This will display the Getting Started with Contacts window.

Close the Getting Started with Contacts window unless you want to view the videos listed.

Click "New Contact." In the Contact Detail window, on the "General" tab, type information about your contact, such as their first name, last name, address, and phone number. You can also indicate one of the following categories for the contact: personal, business, or family.

Click "Save and New" to continue specifying names and contact information you want to include in your phone book. When you are done specifying contacts, click "Save and Close."

Use the column headings to arrange your contacts as you want to view them in the database. Note that they will appear in alphabetical order, based on the contact name, in your phone book.

Double-click "Phone Book" to create and view your phone book.