Use the Contacts Web Database template to target your customer marketing more efficiently

The Access 2010 Contacts Web Database helps you understand your customer and partner details by making it easier to manage and essential information. This template enables you to quickly start tracking name and address information, phone numbers, e-mail addresses, and even attach pictures, documents, or other files relevant to each contact.

The following video shows a brief scenario of how this template might be used.

If you haven’t already downloaded the template, click the link to download the Contacts Web Database Template.

Now, read on to learn how you can start using this template with your available contacts list to help run your business more efficiently.

In this article


Start the database for the first time

The first time that you start the Contacts database, Access displays a Getting Started page. You should also see the following tabs that you can click to add, edit, or locate your contacts information.

getting started screen for contacts database template

Tabs Features
Getting Started Information on using the template.
Address Book Add and edit contact names and information.
Datasheet Datasheet view of contacts.
Report Center Quick view and access to the reports in the database.

Learn more about the Contacts web database

You can click links on the Welcome to Contacts web database page to learn more about using the template by watching the videos or find helpful information on customizing your database, hire a specialist, or provide feedback about the template. The next section explains how to build your contacts database, use it for reports, ways to manage the database and resources for next steps.

Ways to add new contacts

The process of creating a database by using a template is the same for Web databases and client databases.

  1. Click the Address Book tab and click Add New.

 Tip    You can also enter the data in the datasheet, click the Datasheet tab and click New in the ID field.

  1. In the Contact Details form, fill in the information that you have.
  2. If you want to add another contact, click Save & New, and repeat step 3. Otherwise, click Save & Close.

 Tip    If you have an existing contacts list created in Microsoft Excel, you might save time by importing the data into your database.

For more information, see Import or link to data in an Excel workbook.

Top of Page Top of Page

View and edit contacts

Access provides a couple of ways to view or edit your contacts. You can open the Contact Details form either the Address Book tab or the Datasheet tab. The Datasheet view might be a better option for just viewing the information or making minor edits and the Contact Details form for more detailed changes.

View and edit contacts on the Address Book form

  1. Click the Address Book tab.
  2. In the pane on the left, click the name of the contact you want to view.
  3. To add a comment about the contact, type the comment in the Add a Comment box, and then click Save.
  4. To edit other information about the contact, click Edit Details, edit the information as needed, and then click Save & Close.

View and edit contacts on the Datasheet form

  1. Scroll to the contact that you want to edit, and click in the ID column.
    Access opens the Contact Details form.
  2. Make the changes that you want, and then click Save & Close.

Edit the items in a drop-down list

Most drop-down lists in the Contacts Web Database can be edited to suit your needs. Use the following procedure:

  1. Click the down-arrow to display the list. If the list is editable, the Edit List Items button will appear just below the list.
  2. Click the Edit List Items button.
  3. In the Edit List Items dialog box, type the list items you want, one on each line.
  4. Optionally, select a default value from the Default Value list.
  5. Click OK.

Top of Page Top of Page

Attach files to a record

If a form or datasheet contains an Attachments field, you can use that field to attach pictures, documents, or other files to the record. Use the following procedure:

  1. Double-click the Attachments field.
  2. In the Attachments dialog box, click Add.
  3. Browse to the file you want to attach, and then click Open.
  4. In the Attachments dialog box, click OK.

Top of Page Top of Page

Search for a contact

Search boxes are included on the Address Book form and the Datasheet form. To search for a contact:

  • Type any part of a name, company, address, or phone number in the search box, and then click the search icon or press ENTER. Access filters the records to those that contain the search terms you entered.
  • To clear the search, delete the contents of the search box, and then click the search icon or press ENTER.

the search text box on a web database

Top of Page Top of Page

View and print reports

Select a report format that works best for your needs, template has the following five reports under the Report Center tab:

Report Name Format
Address Book Displays contacts and details in a directory format.
Contacts Details Displays field names along with the contact information.
Phone Book Displays contacts and the phone numbers.
Printable Labels Displays contacts in label format.
Contact List Displays contacts in alphabetical order.

View a report

  • Click the Report Center tab, and then under Select a Report, click the report that you want to view.

Print a report

  1. Click the report to preview it, and then click Open in New Tab.
  2. On the File tab, click Print, and select the print option that you want.

Top of Page Top of Page

Publish the database to Access Services

If you have access to a SharePoint server that is running Access Services, you can publish the Contacts Web Database to the server and share it with your team. Use the following procedure:

  1. Click the File tab, and then click Publish to Access Services.
  2. In the Server URL box, type the URL of the SharePoint server that you want to use.
  3. In the Site Name box, type the name you want for the database. This will become part of the URL.
  4. Click Publish to Access Services.

    Access publishes the database to the server. If all goes well, Access displays a success message which contains a link to the new Web database.

Next Steps

As you begin to use the Contacts Web database to manage your contacts, you will most likely think of new ways in which you want to query or filter your data. You may also discover that you want to modify the database to better suit your needs. This section has some links that take you to more information about the typical tasks and modifications that you can do.

For help with finding, filtering, or querying data in Access
For ways to modify your database
How to use this template on a web server
More information about creating new database objects
Safeguard your data

Top of Page Top of Page

 
 
Applies to:
Access 2010, Access 2007