Student Database

[jlc668]

I need help making a simple database. I need it to have a list of students with their contact information, and a few other fields. Then I need to be able to log every course that each student takes. In the end I would like it to generate a report that is a transcript for each student listing all of their information and the courses they have taken. I have tried many times and just do not understand enough about access to make it all work just right. Any help would be appreciated.



Fields needed for tables:
Fields would be:
First Name
Last Name
Employment Type (List County, Private or State)
County (List in Excel Attachment)
Title
MAB License Number
Address
City
State
Zip
Phone
Email
Certified: Check Box
Year Certified
Re-certified
Re-certification Type
Track II Designation (List AEI, AEII, MAE)
AEI Year
AEII Year
MAE Year
IAAO Member (Check Box)


Table of Courses Taken
Courses-List attached, would need to be able to add additional courses over time
Fields for each course would be, course name Date Taken, Status (Pass, Fail, Attended)



I have attached the database I have started.

[June7]

Student database is a common topic in forum. Have you searched?

MS offers a couple of student database templates. Have you looked at?

[Dal Jeanis]

1) Hop over to MVP Roger Carlson's Access library at http://www.rogersaccesslibrary.com/ and read his tutorials about database design. You need to have a basic grasp of those principles before you decide which sample database to start with.

THEN

2) google/bing "access sample student database" and you'll find several templates to start from.

AND LASTLY

3) Check out this site http://www.databaseanswers.org/data_models/index.htm for a large number of industry-specific data models to get ideas from.