Inventory/Asset tracking database.
I have been asked to provide a simply 'database' for the uniform lady, so she can do away with paper and keep a better track of what is going on in her uniform store. not the organisation. As they are tight as a fishes backside.
She wants to record detail like what current stock she has, when she receives new stock, she can add it and when a staff member asks for new uniform, she can record what has been asked for against the employee's record and again. and the current stock adjusts.
In total there are only about 80 people in the company, but the company supplies 30 \- items, which can be broken down into 4 major categories Mens, Ladies, unisex and safety gear, ofcourse all come in a variety of sizing.
a section for current stock and then a record for each employee with the requested the new uniform, what date it was issued and what uniform was issued.
What would be a better platform to use Excel or Access. At this stage I don't know which way to turn. Maybe you know of something that has been designed, built and available.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
It is also important to be able to make queries by department, by type of asset.
Here is a screenshot of the tables I tought I can create. I have knowledge in Database development but this is my first real project. I don't know what other table I should consider !
Eventually I would like to be able to create a form for adding new assets to the database, but am having trouble structuring my tables in a way that allows me to create the form that I want.
The form that I envision would pop-up and give me the option to type the new assets name in a text box, and select the asset type from a combo box. After these are filled out, there will bea "next" button that moves me to a new pop-up form.
This new pop-up form will allow me to enter specific data about the asset I have just entered. The dilemma is that when I select "Rods" for asset type, I should be able to enter specificdata that would not apply to a selection for "Reels." I am having a lot of trouble designing my tables to give me this kind of freedom in my forms.
Is this a good design for inventory database?
The filter quick search macro no longer works. It says:
"The ApplyFilter action requires either the Filter Name or Where Condition Argument is set"
The company I work for has inventory at our physical location (our shop) and we also have inventory on trucks. I need to track the inventory in the shop and trucks so that when items get below a certain preset level I can run a report to find out how many of each part I need in each location.
Create purchase orders and receive the inventory to whichever location I need it at. I would like to at some point be able to track where the parts are going.
1. Setup deposit ( This is where everything gets entered if they get shipment of new items and automatic adds to inventory database )
2. Inventory database ( this is where all items are stored and organized, with pictures of items and add to invoice type feature )
3. Invoice ( this is where items are placed when they are sold and are removed from inventory database )
Thank you guys for your help and this place looks great for me to startthank you.
The relationship between ID/Primary Keys and Secondary Keys seems awkward the way I have it. This database will be used for tracking inventory in the shop and invoicing customers.