Jenni,

It sounds like you have never created a database so I'm going to suggest you
start here...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

AFTER you review and RE-review the above you need to set up some tables...

tblCompanyProfile
cpCompanyID (PK - AutoNumber)
cpCompanyTypeID (FK - Long ~ relate to tblCompanyTypes)
cpCompanyName (Text, 75)
cpSalutation (Text, 4)
cpFirstName (Text, 50)
cpMiddleInitial (Text, 2)
cpLastName (Text, 50)
cpCredentials (Text, 20)
cpNickname (Text, 50)
cpEIN (Text, 20)
cpPositionTitle (Text, 50)
cpAddress1 (Text, 30)
cpAddress2 (Text, 25)
cpCityID (FK: Text, 20)
cpStateID (FK: Text, 20)
cpPostalCode (Text, 15)
etc...

tblCompanyTypes
ctCompanyTypeID (PK - Autonumber)
ctComapnyType

tblCompanyActivities
caDate
caPriorityID (High, Medium, Low)
caActivityID (FK - Long - relate to tblActivities)
caNotes (Prefer you don't use a Memo field data type here)
caDone (Yes/No)

tblActivities
aActivityID (PK - Autonumber)
aActivity

....without more information that's as far as I can go.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jenni" wrote in message
...
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?