How to create an access database with multiple information for each employee.

[mateymoo]

I am trying to create an access database for employees. Each employee has a list of qualifications that I want to include but am not sure how to have multiple entries for each employee.
The information I need to include is basic stuff. like name, address etc and then their list of qualifications, including date, received, eductaion provider, date to be reviewed etc.
Would appreciate any help with this, as I have not used access for years and am having great difficulty trying to achieve this.
Thanks

[colintis]

you can try to make another table to store employees' qualifications (as one-to-many relation), using a combination of employee number and a unique qualification information as primary keys to link to the employee information table.

[NeoPa]

That sounds like good advice. I'd also have a quick browse through Normalisation and Table structures to remind yourself of some of the basic concepts. I suspect it may help you get your head back into things.

Welcome to Bytes!