?
Solved

What direction show I be looking at in building a equipment check out database

Posted on 2011-02-14
2
Medium Priority
?
520 Views
Last Modified: 2012-05-11
Right now we just have a sign out sheet created in excel. But we are looking at building a database to keep track of who, how often a piece of equipment is checked out, and when it is checked backin. We would like to keep it in the same format as our current check out sheet.

I figured I would need a table for the equipment with a relationship to a table for checking out and checking back in. But I am not sure if I should also have a table that is a merge of the two to get the report to display the way we currently have it.

I am open to any better ideas or better method of database creation.

I have attached the excel file we are using for our sign out sheet.
Equipment-Checkout-Sheet--New-.xls
0
Comment
Question by:Everwulf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 34886609
If you have a table for the equipments and a table for the "movements", when you want to create a report, you just need to build a Query that will join the information from both tables so that you can display it on the report. You movements table should have a field that is a key from the equipments table so that you can relate one with the other. You don't need to build a third table to join the data from the two tables, the query is used just for that. Then you can use this query as the source for your report.

jppinto
0
 

Author Closing Comment

by:Everwulf
ID: 34887031
Thats what I was hopeing for. I work from that direction. Thank you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question