Creating a Registration Database - Newbie

[pappion]

I am creating a training registration database to track who attends and the classes they attend. Two tables are listed below as example. However, I am not sure how to list events which have the same name (see below). Have looked for sample of how registration database design - with no luck.

I also want to include the number of spaces available in each class and the number of spaces remaining. Any help will be greatly appreciated.

Same Event different start dates
Introduction to Sewing Start Date: 07/01/03
Introduction to Sewing State Date: 08/15/03

Attendees Table
AttendeeID
First Name
Last Name
Department

Event Table
EventID
Event Name
Location
Start Date
End Date
Start Time
End Time
Number of Seats Available

 

[psemianonymous]

This is too much to ask. Ask smaller questions? I am trying to help, so here is what I can give:

1. Events with the same name have different Event ID's, so they should be fine.

2. Number of spaces available: I think your instructor wants you to create a third table "Attendance" which holds the AttendeeID AND EventID to log the attendance info. THEN, do a count of all the people attending a certain Event, subtract that from the total seats available, and you have your count.

Good luck on your assignment.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm