Hi all,

I am pretty new to access and have been playing around with it the last few weeks. I feel like this is a pretty basic question but it has stumped me for the past two days. I am setting up a faculty database and I am trying to set up their certifications and expiration dates. Each faculty member can be certified by four different groups (ACLS, ATLS, PALS, BLS) and they are certified as either a "Provider" or "Instructor". Right now it is just set up like an excel sheet with the faculty members name, their unique userid (combination of their first and last name) followed by their certifications and expiration dates so it would look something like this.

alex jones / aljo3 / ACLS / Provider / 6/30/2012 / BLS / Instructor / 07/24/2013

I assume I should be setting up at least two tables with Faculty Members on one table and a separate table for certifications. Do I make a separate table for each certification group or can they all go on one? I believe in the end I will want to set up some type of lookup function or combo /listbox.

Playing with Access has been a good learning experience and I am looking forward to someday not being such a newbie. Any advice or extra reading materials would be greatly appreciated.