I'm relatively new to access, i have used and edited other databases, but this is my first attempt at creating my own.
Im in the Military, and i am trying to create a database to track all my soldiers, and their different certifications and qualification and when they all expire.
SO i made a table with these columns:
Rank, Last Name, First Name, Platoon, Phone Number, DOB
I populated it with 75 different names. But i need to be able to track about 12 different certifications for each soldier, then pull a report to give me a list of every soldier and list 1 certification and when they expire, like weapon certification.
Do i make new tables for each certification? if so how do i link the data in that table to one name in the personnel table.
or just new columns on each name for each certification?
I have a database put together already but its not working for my needs :banghead:, so i a, attempting a redesign. any help would be appreciated. im operating out of access 2010 at work and 2013 at home.
Im in the Military, and i am trying to create a database to track all my soldiers, and their different certifications and qualification and when they all expire.
SO i made a table with these columns:
Rank, Last Name, First Name, Platoon, Phone Number, DOB
I populated it with 75 different names. But i need to be able to track about 12 different certifications for each soldier, then pull a report to give me a list of every soldier and list 1 certification and when they expire, like weapon certification.
Do i make new tables for each certification? if so how do i link the data in that table to one name in the personnel table.
or just new columns on each name for each certification?
I have a database put together already but its not working for my needs :banghead:, so i a, attempting a redesign. any help would be appreciated. im operating out of access 2010 at work and 2013 at home.