How can I make only part of a field default.  I want the area code in a phone number to default?

I have office xp pro 2002 and the file format in access
say 2000 but give me the option to convert to 2002 should
I do this??
John

In responses to your advice below I have the paper and
drawings out and I can get some of the entitys to match
with the attributes some are obvious but I have fields
(like, list any local schools or historic sites or any

I am building a database for classical music CDs.  A CD
can have many Works.  A Work can be on several CDs. A
Soloist can perform different Works on different CDs.  I
have 3 tables for CDs, Works and Soloists each with a

I'm sure someone out there has done this but if not here's
my problem.  I have created a database with 12 tables.  I
have also created a form so that the data can be
displayed.  I have several text and combo box controls on

I have a Access2000 db split. Extensive forms have
already been created based on queries. I have now gone
back to back-end to set referential integrity to prevent
users from deleting data.  Users can't delete a record in

Is it possible to save a table resulting from a parameter
maketable query with table name the same as the value
entered as the parameter(s)?  
I have an address table that is queried for locality or

I am designing the database structure for an online store that carries a wide variety of products. For example, hats, briefcases, pens, etc
Under normal circumstances I would put all the products in one table, but in this case each product type has specific information that ...

I have been creating tables programmatically and it would be nice to be able
to add descriptions to the fields at the same time.  Is this possible?

As I tried to save a report, I got error messages that it could not be saved,
then everything in the database disappeared.  I tried repair and compact with
no results.  I tried to import its contents into a new database, but it appears
to be  empty.    Can a corrupted database be ...

Here's the code I have, but I get the message "Invalid
Operation":
Public Sub pChangeSize()
   On Error GoTo pChangeSizeError

I want to use VBA code to change a table field attribute of an external
database (opened by Opendatabase with exclusive option). Actually, I want to
change an Autonumber to a Long. But I get Invaild operation error message
(error code 3219).

I ask this question due to remarks I saw in relation to
another question on these boards.
In my current application I have a child table based on
two parent tables. Therefore when I append data to this

When sending database to telemarketers they are getting an
error message "unrecognizable database format".
They are able to open other databases. I am able to open
it on my end.What could be the problem?

I'm starting to learn more things but I don't want to bug
you guys each time can you recommend a good step by step
Microsoft Access Book using VBA (keep in mind I'm not a
programmer).