Need help creating a MS access Employee Equipment Tracking

I am starting to build an Access database that help me to keep track of Employees' equipment such as PC, Monitors, Printers,Blackberries, and software (Visio,Adobe;etc) and also I would like to keep track the date that each equipment has been installed. My idea is to have a table for each equipement and then the primary key of the employee table will be in each of the equipment tables. That way i create a one to many relatioship between employee and Pc and so on. The problem is that not every employee has a blackberry or a loptop, and most of employees have two monitors , so i am not sure if my idea will work well enough. Please can you assist me with this.
mitema2010Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AccessYourBiz_ComCommented:
I suggest using three tables: Employee, Equipment, and EmployeeEquipment
Anytime Equipment is given to an employee add a return in the EmployeeEquipment table. When it is returned you can delete the record.
If you want to keep history then you can include a "Status" field in the EmployeeEquipment table and instead of deleting the return in the EmpoyeeEquipment table, change the status to "Returned" and when you add a record to same, set the value of "Status" to be "Out" or something like that.
0
AccessYourBiz_ComCommented:
oops, I made a typo, see word in CAPS for correction.
"Anytime Equipment is given to an employee add a RECORD in the EmployeeEquipment table. When it is returned you can delete the record.
If you want to keep history then you can include a "Status" field in the EmployeeEquipment table and instead of deleting the RECORD in the EmpoyeeEquipment table, change the status to "Returned" and when you add a record to same, set the value of "Status" to be "Out" or something like that...
0
mitema2010Author Commented:
Thank you AccessYourBiz ,
I want to keep track of the barcode , serial number ,model and date of installation of each equipment that the employees have , so whic table should held all the data mention above?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

AccessYourBiz_ComCommented:
Keep them in the Equipment table. If you do want to keep history then you should keep the Date Of Installation in the EmployeeEquipment table. If you find this confusing then just keep it simple and put everything in the Equipment table.
0
mitema2010Author Commented:
Thank you again. I like the idea of 3 tables. So the EmployeeEquipment table have to have the primary key of the other two tables , right?
I am realizing that  I have to enter a record for each equipment that employees have ,but that  will create like 5 or more records per employee . Is it ok ?
0
AccessYourBiz_ComCommented:
"Thank you again. I like the idea of 3 tables. So the EmployeeEquipment table have to have the primary key of the other two tables , right?"

Yes, that is right.

"I am realizing that  I have to enter a record for each equipment that employees have ,but that  will create like 5 or more records per employee . Is it ok ? "

Yes that is ok. For each peice of equipment an employee has there will be a corresponding record in the EmployeeEquipment table.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AccessYourBiz_ComCommented:
I got so caught up in answering your question I forgot to say You are Welcome!! ;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.