By Tom Wickerath
Question:
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)?
When this template first opens, it displays the Contact List form, with the Navigation Pane reduced in size. Click on the small double arrow, on the left-hand side (red rectangle in image below), to expand the Navigation Pane. You can also close the Contact List form at this time.
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:
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.
Double-click on the Contact table to open it (blue arrow). 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 (red arrow), 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.
Last Updated: Jan. 27, 2008
Copyright © 2007 - 2008 Tom Wickerath. All rights reserved.
About the author: Tom Wickerath is a chemist at The Boeing Company in Seattle, Washington, USA. He works in the Analytical Chemistry Group of Boeing's Materials & Process Technology (M&PT) organization. In the early 1990's, Tom became interested in the use of database technology to avoid many of the inefficiencies involved in using spreadsheets for the analysis of large amounts of data. Tom has taught Microsoft Access courses to college students for three years at Bellevue Community College in Bellevue, Washington. He has also been an active member of the Pacific Northwest Access Developer's Group (PNWADG) since the days of Access 2.0 and served as an officer of this group from 1998 to 2002. As a longtime Access expert, Tom has given presentations on complex Access subjects, including tools designed for Access developers, to the Seattle Access Group, the PNWADG and to Boeing Company personnel. Tom has provided his expertise to Microsoft Access developers and users for years in the Microsoft Access Newsgroups in UseNet, and he was awarded MVP for Microsoft Access in April, 2006. Check the Microsoft.Public.Access Newsgroup for Tom's latest expert advice and feel free to post any questions in these Newsgroups. Special Note From The Author: "If you find that any of these tips save you a lot of time and frustration with your database development, please consider making a tax deductible contribution to the Northwest Kidney Center, located in Seattle, Washington, USA. I've seen first hand how valuable their work is. With your help, they can do more research in the treatment and prevention of kidney disease, provide increased financial assistance to patients in need, and generally make kidney patients' lives more comfortable. You can even use PayPal to make a quick and easy donation online, and you'll feel better knowing that you have contributed to a better quality of life for those in need. Thanks." -- Tom Wickerath http://www.nwkidney.org/nkc/howYouCanHelp/donate/index.html For questions regarding this tutorial, please contact Tom at: |
Tom does not accept unsolicited requests for help. Contact Tom only if you have questions or feedback on this article.
@ |
MEMBER OF PROJECT HONEY POT Spam Harvester Protection Network provided by Unspam |