How do i modify the contact field lists in Access 2007?

A

Access 2007 newbie

Access comes with a generic Contact template that I would like to modify.
How do I add / remove some of the fields in the Contact template (for example
the web field).

Thank you.
 
T

Tom Wickerath

When this template first opens, it displays the Contact List form, with the
Navigation Pane reduced in size (for lack of a better term). Try following
these steps:

1.) Click on the small double arrow, on the left-hand side, to expand the
Navigation Pane. You can also close the Contact List form at this time. You
will likely see a grey space where this form was opened.

2.) With the Navigation Pane expanded, you should see "Contacts Navigation".
Click on the small arrow just to the right of this. This arrow is directly to
the left of a double-arrow used to minimize the Navigation pane.

3.) Select Object Type from the dropdown list. This will allow you to see
various objects in the database, grouped by object type. Examples of objects
include Tables, Queries, Forms, Reports, Macros and Modules.

4.) Double-click on the Contact table to open it (this database only has one
table). You should see the various fields present. At this point, you can
click on the icon just below the Office button that looks like a triangle
with a pencil and ruler, to open this table in design view. This view should
allow you to easily add and remove fields.

Note: You may need to open the Contacts Extended query to add / remove
fields from this query as well. Then, you'll need to add / remove the
applicable fields from your forms and reports.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top