Inventory/Asset tracking database.

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:

Related Topics

Help asset tracking database
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
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.
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"
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
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
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
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
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
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
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


FIFO Value
This database does a really good job of keeping track of inventory on a FIFO basis but it does not keep track of the value of the inventory on a FIFO basis so that one can calculate profits when comparing cost to sales price. When a sale draws from inventory from different receipts (and, therfore, possibly different costs) it is desirable to know the exact cost of the product sold.

Since the code is tracking the inventory as FIFO (by lots), can I track the cost associated with each lot and tie the cost to each individual sale line


Business-Based Functions
An asset is an object of value. It could be a person, a car, a piece of jewelry, a refrigerator. Anything that has a value is an asset. In the accounting world, an asset is a piece of/or property whose life span can be projected, estimated, or evaluated. As days, months or years go by, the value of such an asset degrade.


Unique incremental field
I'm working on an asset tracking db for our use in house. Very simple structure.
tblClientGeneral has a client_id and a client_name. tblAssetTag is linked by client_id 1-M.

I originally was using autonumber random to generate the a unique asset tag but realized quickly that that can give a negative number and also it's not exactly good practice.

Now I'm a little stumped. My primary key is just an id field. So what is the best way to create a field that will generate an auto increment number for my asset tags. They must be unique. I'd like 8 digits with no preceding 0's and all positive.

I've seen a few things but I'm not sure what is the best way to go about this


Searching column history
I've got an inventory DB in access 2010 where I track our assets. In my asset table there's a "comments" field (memo type) with the comment history. I got this from the northwind assets db or the access built in inventory db, don't recall which one. Anyway, the comment history has been awesome but I need to search the history and I can't. For example 1 asset in the history, if I view the history, I can see was first assigned to jsmith but when I search for "smith" it doesn't appear because it's in the comment history.


Tables for Different Types of Inventory
I am currently creating a database for a diamond/jewelry shop. There are very different characteristics for diamonds compared to finished jewelry and mounts. It seems to me that it makes the most sense to keep them in separate tables (as you can see from the diagram.)

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.


Inventory Database, Local Network Only
I am working with a company and want to get into making database's and inventory list but I want to be able to automate it. this is what I am looking to do:

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.


Adding multiple columns
I have the below query -

SELECT [QA Tracking].[State], ([QA Tracking].[Misnumbered Check Number]+[QA Tracking].[X-Post Not Rej/Flag]+[QA Tracking].[Check Rejected for Incorrect Reason]+[QA Tracking].[Mis-Keyed Vendors]+[QA Tracking].[Vendors Not Charged]+[QA Tracking].[Vendor Charged Incorrectly]+[QA Tracking].[Altered Error]+[QA Tracking].[Missed EE's Not Flagged/Rej]+[QA Tracking].[Check S/B Paid]+[QA Tracking].[No Issuance Keyed/Checked]+[QA Tracking].[Check S/B Rej]+[QA Tracking].[Stale Date Missed]+[QA Tracking].[Missing Signature(s)]+[QA Tracking].[Invalid MICR Line]+[QA Tracking].[Invalid Flag(s) Not Checked]+[QA Tracking].[Processor]) AS [Total Project Errors]
FROM [QA Tracking];

But when I run it in Access, nothing is showing up in the Total Project Error column for any of the States


Inflows and outflows of product over time
Learning objectives: gain more experience creating tables, relationships, and queries; gain more experience building multipart
forms; create an event-driven procedure to update inventory levels on receipt of a shipment; understand the difference between inventory tracking and inventory management. (pdf file, install Acrobat Reader to rad this tutorial)


retail and wholsale in a ms access 2007 database
please is it possible to have a store inventory, retail inventory ,wholesale inventory separately in ms access database?
the sale point will be one it will just reflect where the item is coming from.
for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
would be glad if any help is rendered


Microsoft Access User Interface Sample: In-House Inventory Tracking
In-House inventory use. Designed to manage the components of machines and also machines themselves produced by my company.