HR Database relationships

[matt123]

Hello All,

I am new here and relatively new to access databases.

I have been given the task of creating a database for HR Records for approx 100 employees. I want to include tables for Contact Details, CRB Check numbers/dates, Venues/offices and contracts to start.

I have created the tables but I am not too sure on how relationships work.



Am I heading in the right direction with this? Any help would be gratefully received!

[RuralGuy]

Have you studied any of the templates available?

[matt123]

Where do I find them? Does that mean my relationships are wrong?

[RuralGuy]

You find them by launching Access without a file to open. The Northwind sample is also extreamly helpful as an example.

[matt123]

Jesus! That is quite advanced. This will take a while to study! Thanks for the advice.

[RuralGuy]

There is also a ton of templates on-line. Have fun.

[yogesh9139]

want gud example