Feedback on db model (simple)

[aucho22]

Good morning everybody,

I am looking for some feedback on my db design Please note I am a beginner but I am really trying to learn Access (so much fun ). Can I please have some feedback on my structure? I would use a db to track qualifications in training...

I did 3 tables:
tblIndividual (IndividualID, Firstname, Lastname, DOB, Role, Shift)
tblTraining (TrainingID, Title, SkillArea, Frequency)
tblQualif (QualifID, IndividualID, TrainingID, LastTimeCompleted, RequalificationDate)

I am in the early stage of the db design but possibly the user would be able to add training names through forms, individual names, and update qualifications once training has been completed.

I am not sure about the 3rd table (tblQualif) as there would be a lot (a lot!) of lines/records so it may not be the "nicest" way to structure my db, but neither am I sure there is an other way?

I will appreciate any feedback!

Thank you,
Aucho22

 

[GinaWhipp]

Well, you're missing a couple of Junction tables, such as...

tblIndividualsTraining
tblIndividualsQualifications (only counts if people have more than one qualification)

And, since you're new to this, here's some links that should help...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102

And, for fun, have a look at...
http://www.access-diva.com/dm7.html

Don't think about the record count as you will not be using the Tables for display, you'll be using Forms which you can make look more presentable.

 

[aucho22]

I am never too sure about these junction tables...

Thank you very much for the treasure of links! Very useful to my learning!
Aucho22

 

[GinaWhipp]

Glad to help!

Once you get your tables created you can upload for us to have a look. Much like building a house where the foundation is the most import part, so it is with Access tables...