Help with Key Checkout Access Database

[Darth21]

Hello,



I am trying to create a Keycheckout database from my company.

First, I want to be able to track the keys the employees check out.
Second, I want to set permission on the keys, for example..If an employee is in the Food Service Department he can only check out food service keys and not Merchandise or Games and so on...

The tables that i created are

TblEmployees, which has ID, LastName,FirstName, Department, EmployeeID, JobTitle
The second table is: TblActivity which has ID, Date, Time Checkedout, TImeCheckedIn, EmployeeID
The third table is TblKey which has...ID, KeycheckoutID, Department, Location, Key Set which is what set have like Key 1, 2, or 3.

If i want to set permission by department do i need to make a department table? How would i link these tables together. I created a database, but having trouble compressing it, but if anyone wants to see it, i have not problem uploading it.

Does anyone have any ideas?

Thanks Brian

[Darth21]

Hello,

I am trying to create a Keycheckout database from my company.

First, I want to be able to track the keys the employees check out.
Second, I want to set permission on the keys, for example..If an employee is in the Food Service Department he can only check out food service keys and not Merchandise or Games and so on...

The tables that i created are

TblEmployees, which has ID, LastName,FirstName, Department, EmployeeID, JobTitle
The second table is: TblActivity which has ID, Date, Time Checkedout, TImeCheckedIn, EmployeeID
The third table is TblKey which has...ID, KeycheckoutID, Department, Location, Key Set which is what set have like Key 1, 2, or 3.

Here is the Keycheckout database, if anyone wants to take a look at it.

Thanks, Brian

[burrina]

why in tblemployee do you have a employeeid as text?
why in tblactivity do you have a Date_ ,? why the _ after Date?
tblkeyset you have keycheckoutid as a number?

Normally you create a Fake Key (FK) to link the tables together.
Example, you have a orders table and a orderdetails table.
orders table would have a primary key of orderid and then the orderdetails table you would have a Fake Key (FK) as orderid
and data type as a number so tables can be linked together. of course there are many ways to do this!
What is the relationship between tbactivity and tblemployee or tblkeyset?
How do these tables relate to one another? Ask yourself, what do I need to see that is in both tables or in all three?

[Darth21]

The reason why I have employeeid as a text, I want to scan that field using a barcode scanner and the text limits the number to 8, because each employee ID only have eight numbers, maybe I am doing it wrong.

I want to be able to see the activity of the keys, by employeeID table. The TblKeyset table just has the department, location and what keys in that table, which probably cannot be linked together.

I am not sure if I'm doing this right with setting up the tables.

[burrina]

NO, your ok, was just curious!

[geomodeler]

Hi Everyone,

Anyone have Excel sheet VBA convert to Access? Share please

Thank you

Andre

[Darth21]

I want to set permissions in Access, how can I restrict an employee in my key checkout database from checking out keys that are not in their department. What kind of table do i create or is it visual basic coding?

Help, Brian