Topics Search

Inventory/Asset tracking database.

Inventory/Asset tracking database.
Views: 32
I am not sure if excel will do this or maybe an access database. At home I have 2007 and work has 97, so there is our first issue.

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.
Sponsored Links:

More topics

 

Help asset tracking database

Preview
I'm developing a simple asset tracking database. The assets I want to include are Laptops, workstations, and printers. I want to be able to know the exact location of the asset, be able to change the status of an asset and any other important information. I think it's also important to keep track of the asset location changes.
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 !
 

Table Design for Assets Inventory with Multiple Asset Type/Asset Attribute Combos

Preview
I need to set up a database for tracking fishing supplies inventory. The problem is that for each type of asset (rods, reels, jigs, hooks, etc.) there are different combinations ofattributes that need to be entered.

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.
 

Simple inventory tracking database.

Preview
And a very beginning Access user. I'm working on a project to create a simple inventory tracking database. I have created tables as follows.

Is this a good design for inventory database?
 

Quick Filter Field - MS Access "Asset Tracking Database"

Preview
I am working from the MS Access "Asset Tracking" database template. Using the "Asset List" form (I renamed it Equipment List). I have populated the table with my data. I have also switched out, renamed and added some new fields to the equipment (formerly asset) table.

The filter quick search macro no longer works. It says:

"The ApplyFilter action requires either the Filter Name or Where Condition Argument is set"
 

Bar-Coding

Preview
I need to set up an Inventory Tracking System in an Access Database using bar-coding technology. I need to have each asset tracked via a bar-code. This will require a bar-code sticker to be generated and placed on each asset. We will use a scanner to check bar-coded items in and out.

Has anyone ever done this? Which 3rd party bar-coding software is the best and the most user-friendly that works with Access
 

Inventory Tracking

Preview
I'm trying to create a basic inventory tracking database for multiple products. I have a table of products, purchases, and sales. The common field is ProductName, which is my primary key in products. I managed to make 2 seperate queries totaling the purchases and sales by product.

What I need is a table combining the two and subtracting sales from purchases to give me the total inventory of each product. I know this isn't too difficult but I haven't messed with Access in 5 years or so and am coming up blank
 

Theory... Inventory Serialization

Preview
In my Inventory Database, I have purchasing functions and issuing function and inventory tracking functions. Because I have a PO Details table which includes lines for each inventory item and its current price on any given PO, I really have a defacto serial number for each part/PO combination. For job costing purposes, this would be very useful to develop. I can think of several directions to take in order to tie Part, Price, PO Line and Job together to establish a true cost but none of my thoughts seem to efficient to me.

On a theoretical basis, how would you do this
 

tracking and receiving inventory in multiple locations

Preview
Heres what I need:
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.
 

Form Auto population

Preview
I guys,
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, I created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when I open up Asset Register Form - I can input all the information and it will be saved in Asset Register Table, but I have to input Building ID manuly for the same building, and I have about 300 items ;(. How do I automate this proccess, so building ID populates automaitcly for all items when I enter information (and saves it in Asset Register Table)?
Please inform me if I made very stupid mistakes in my database, any critisism will be appreciated, I am trying to learn Access
 

Form Auto population

Preview
I guys,
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, I created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when I open up Asset Register Form - I can input all the information and it will be saved in Asset Register Table, but I have to input Building ID manuly for the same building, and I have about 300 items ;(. How do I automate this proccess, so building ID populates automaitcly for all items when I enter information (and saves it in Asset Register Table)?
Please inform me if I made very stupid mistakes in my database, any critisism will be appreciated, I am trying to learn Access