This is my first attempt at designing a database from scratch (Access 2010). I want to be sure I am on the right track. I wish to design a database for my association’s members to track their continuing education hours. We have 300+ members; members have from one to many different state licenses for a number of disciplines (building inspector, electrical inspector, etc.) Each license requires 30 hours of documented education per three year cycle. The cycle date varies as to the original issue date of the license. Individual education classes vary as to the number of credit hours given and to which license the class qualifies for. Some classes qualify for one or two disciplines, others cover all disciplines.
The end product I wish to achieve would be a form where the member only has to type in a class number in a new record, the record updates from the CONEDClasses table, and the members total license credit hours is shown for each license they hold. Eventually the member would print a list of the classes attended per license to send in to the state for license renewal.
Here is where I have started. I will need to join completed tables and looking for suggestions to move forward. Thank you in advance.
tblMEMBERS
pkStateIDnumber
txtFirstName
txtMiddleName
txtLastName
???LicensesOwned
tblAVAILABLESTATELICENSES
???BuildingInspector
???ElectricalInspector
about 10 more
tblCONEDCLASSES
pkStateClassNumber
txtClassName
txtClassInstructor
numClassCreditHours
???ApprovedLicenses