Help with Database Set Up.

[despatcher]

I have been tasked with setting up a database for all employees the info contained is along the following lines:

Employee Number:
Name:
Qualification Status:
Qualification Run Out Date:

To name but a few of the parameters

I have currently set up the start up screen, main switch board and the complete employee records table with form (for simple viewing/input).

My problem is this we have four departments that require access to the database

Admin - Require access to all employee records (View)
1 Dept - Require access to their employees (View and update records)
2 Dept - Require access to their employees (View and update records)
3 Dept - Require access to their employees (View and update records)

Currently i have created one complete employee record table (Admin) how do i break this down for each department so that when the info within each one is updated it in turn updates the main Admin table?

I started by copying and renaming the Admin table for each department but this never updated.

Any help and info would be appreciated.

On a slightly less important note for the time being at least can i password protect each command button on the main switchboard?

 

[Robert88]

Hi despatcher,

You'll only need one table for this, just include a department field.

Then use a query for each department (dept 1,2,3) to get information for each department, then for admin have another query that has all information.

Robert88