Basic Access Help

[alex2300]

I new to Access and need some help designing a database to keep track of RSVP as they come in (RSVP for upcoming one day training course).

The database is to show participant details (such as first name, last name, position within their company, whether they’re an apprentice or trainee), the details of the company they work for (such as company name, company address), contact details (such as phone, email address), the date RSVP received and the venue of the course.

These are my questions:
1) How many tables i should create?
2) What will be the field names?
3) What will the primary keys be?
4) Type of Relationships between the tables?

Any help will be greatly appreciated..

[mcwilsong]

Try using one of the built-in templates. You can also take a look online at the Microsoft Office webpage and do a search for Access templates. I'm sure there are a few to choose from.

[blue4512]

I would start with three tables - event, companies, and attendees.

Event
-autonumber (primary)
-date
-name
-notes
-location

Company
-autonumber(primary)
-name
-address
-phone
-email
etc.

Attendees
-autonumber
-name
-phone
-Email
-company(Relationship-company)

RSVP
-autonumber(primary)
-name(lookup)
-event(lookup)
-company(lookup)
-rsvpDate (default date())
-notes