Mailing Lists in Access 2003

[Guest]

Hi,

I've been given the task to create a Mailing List in Access but really have
no idea where to start.

I have an elementary knowledge of Access, but it's been a few years since
I've used it so I'm stressin'

Any help, suggestions or links to FREE online tuts would be greatly
appreciated.

Thanks

 

[Duane Hookom]

A mailing list sounds like a table of people with addresses etc. I would
suggest starting with at least these fields:
tblMailingList
=====================
MailListID autonumber primary key
FirstName
LastName
StreetAddress
City
State
Zip

You might also want a status field or others.
You can use the form wizard to create a basic form for data entry.

 

[PC Datasheet]

Name, Address, City, State and Zip. Then you can use the label report wizard
to create mailing labels or link the data to Word to create a variety of
mailing documents.