Need SIMPLE Access Database Built

Need SIMPLE Access Database Built

Closed - This job posting has been filled and work has been completed.

Job Description

I need to create
Simple access database 2003.

With these fields…

Contact Table
Saturn (external database) ID Number (PRIMARY KEY)
ROI (internal database) ID Number
First Name
Last Name
Address 1
Address 2
City
State
Postal Code
Country
Home Phone
Work Phone
Mobile Phone
Membership Status (VS, AC, VS/AC)
Donor Rating (numeric value – 0-12)

Call History
Saturn ID Number (PRIMARY KEY)
ROI ID Number
Date
Time
Type (email, postal, phone, visit, other)
Action Needed (Return Call, Thank You, ASK, Other)
Notes (free form text that can handle up to 200 words)