Tables

Hello Charlotte,

Hope you enjoyed your Microsoft Access introduction course with Best STL.

Thank you for your question regarding setting up tables in Access.

If you were to use a single table for all the data relating to the exam results you may as well use an Excel file and analyse the data with a PivotTable or use autofilters to view your data.

Of course, you can do this in Access with one table, but the downside of doing this is that a lot of repetitive data will appear in the table. To normalise this it will be necessary to create a few tables which should be linked via foreign fields.

I would have a Candidate table, an Exam table and a Results table and if the candidates are from several different departments or companies then I would create a Department/Company table.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer