Inventory Database

MS Access Tutorial: How To Make an Access Inventory Database (a video tutorial)
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.

Sponsored Links:

Related Topics

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.


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


retail and wholsale in a ms access 2007 database
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


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?


Inventory/Forecast Database Design
I'm a little lost on where to begin on designing an inventory fasting database. I have my tables set up, current inventory, actuals, backlog etc. what needs to talk to each other, building the reports to show what the forecast each month, quarter, annually, .


DB For Inventory Control
Recently I'm working on a database for inventory control for a repair shop. The main purposes of this database is to provide a report of the parts replaced to repair a unit, check if the stock level is enough for further repair, and check how much is our inventory value.
I made the tables of this inventory, but I don't if it would work fine.


Inventory Database: Automatic Adjustments?
I have a database for inventory, consisting of around 70 different computer parts. My skills in Access are limited to this project.starting from scratch and reaching this wall.

My goal is to create a form, which prompts the user to select the configuration of a new computer. After selecting the configuration, I would then like the inventory database to automatically be adjusted to the specifications.

Basically, each item selected for the computer would decrease 1, after the "order" is completed. A Basic Inventory Adjustment.

If this is confusing, I will gladly describe it the best I can through another thread or email if you need.


DB For Inventory Control
Recently I'm working on a database for inventory control for a repair shop.
The main purposes of this database is to provide a report of the parts replaced to repair a unit, check if the stock level is enough for further repair, and check how much is our inventory value.
I made the tables of this inventory, but I don't if it would work fine. The relationship is attached please help check and give some suggestion


Database Design - Many to Many Issues
I've created an inventory database but I am having trouble getting the reports that I want out of my data. I have a Projects table with pertinent info relating to each construction project my company is currently working on.

I have an Inventory table with pertinent inventory information. I have a MaterialTransfer table that has fields: MaterialTransferID, ProjectFrom, ProjectTo, and other pertinent date, time,

I then have a Detail table that allows the user to enter the InventoryItem and Quantity. This hasMaterialTransferID as a foreign key connecting the Detail table to the MaterialTransfer table.

Unlike examples I've seen where inventory transactions work as items coming in or going out, I need to show items moving between the different projects. I want to be able to create a report that is grouped by Project.

I want it to show all the Inventory Items that have come into that Project and all of the Inventory Items that have come out of that project as sums. So the ProjectNumber will be the header and there will be a line for each inventory item (not all of the inventory items, only the inventory that has come in or out of that particular project). Then there will be a sum in, a sum out, and a delta for each line.


Inventory System
Anyway, I've decided to begin reworking my company's database (which is an ENORMOUS task) and have run into a few hangups. The first of these hangups is the inventory system.

I'm trying to figure out the best way to set up the table(s) for our inventory. Currently, there are two "main" types of inventory item: Glass and Non-glass.

The Glass inventory items are stored based on the following characteristics (which are ONLY used for glass inventory items):

* Height (number, ##0.000)
* Width (number, ##0.000)
* Color (number, integer ID field connected to a "colors" table)
* Light Transmission/Transparency (number, #0%)
* Thickness (number, 0.000)

My question is this: Do I use separate tables for the Glass inventory and the Non-glass inventory? Or should I combine the two and just leave a bunch of null fields for the non-glassinventory items? There are about 100 different glass items in our current inventory and about 400 non-glass inventory items.


To index or not to index
I have a table of stuff stored in a repository and an attached table of inventory dates, linked one-to-many by an Autonumber ID field. I regularly need to find the oldest or newest inventory dates (or all, in order by date) for each item record in the inventory table, which is normally an automatic case for indexing. But this stuff is not inventoried very often, so far, only two out of over 80,000 records have three records in the inventory table, all others have zero, one or two inventory records. This is NOT going to change. It will likely be decades before there are as many as ten inventory records for any item record, and then it will not be for very many. I doubt if this database will live to see the day, although I'm trying to make it as useful and robust as I can.


Inventory Database
I am building an inventory database for my collectibles business. I am limited in the construction of the database so that I can easily use it with my opencart import function.

I currently have 8 tables that are identical in structure but are for different product lines...


Simple Inventory
I'm trying to use a query to show my current inventory. I produce chili and have ingredients and when ever I use an ingredient I would like it to be removed from my inventory and whatever I created will be added to my inventory or query.


Access Well Customized Inventory management Database
I'm currently looking to hire someone with very well known microsoft access programming.
I need someone to program an automatic inventory system to with with my ecommerce webstore and other selling locations.

I also have an question before starting. Does this person needs to locally program the inventory database from scratch at my local computer, or is he able to do it somehow online and add it to my access.


Inventory Database / Scanner / Server
I'm working on converting an Excel Spreadsheet over to an Access Database for an inventory of products for a small-business.

The goal is to allow users to scan products into and out of the inventory using a barcode scanner either at the warehouse, or in the field.

All of this I am able to grasp, but from a hardware standpoint I'm lost.


Extract old part number data from an access inventory database
Trying to extract old part number data from an access inventory database. I need to find records where the on hand, on order, on backorder for a part number are all zero. the problem is that this database also has a field for branches, so I want to pull records only where none of the branches have inventory.

so that if one branch still has inventory I don't want thatrecord returned.

what I was using was
select branch, partnumber, [on hd], [on or],[on bo] from inventory where [on hd]=0 and [on or]=0 and [on bo]=0

which obviously gives me results dead partsbut does not filter out part numbers that may still be active at some branches. I cannot figure out how to filter that. Would a recursive select be best or use union?


Inventory template question
I downloaded the inventory template from MS and am trying to implement it into my existing database, but it is very difficult because of the complexity of the template. Could someone explainthe meaning/workings of the where condition of "1=0" that is in the openform action attached to the cmdNewInventoryItem button on the inventory list form?
Also, I wish there were less complex templates that could realistically be used as a starting point for database construction.


Inventory template question
I downloaded the inventory template from MS and am trying to implement it into my existing database, but it is very difficult because of the complexity of the template. Could someone explain the meaning/workings of the where condition of "1=0" that is in the openform action attached to the cmdNewInventoryItem button on the inventory list form?
Also, I wish there were less complex templates that could realistically be used as a starting point for database construction. Does anyone if and where such things exist?


Inventory / Mfg database
Having a little trouble creating tables/queries/etc that will accurately track our inventory. I don't seem to have a problem with creating tables/forms, etc that are used for receiving inventory - but the sales part is causing me grief.

We don't actually sell these inventory parts individually - they make up part of a larger product. What I want to do is create a form to input the number of products sold that automatically takes out the individual parts out of the inventory. I don't really know how to make tables that will allow me to do that


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