Topics Search

Inventory Database

Inventory Database
Views: 161
MS Access Tutorial: How To Make an Access Inventory Database (a video tutorial)
Sponsored Links:

More topics

 

Inventory Database, Local Network Only

Preview
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

Preview
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

Preview
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.

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?
 

Inventory/Forecast Database Design

Preview
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

Preview
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?

Preview
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

Preview
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

Preview
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

Preview
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.