Access Inventory Template

I need a Access database template for an inventory control system.

General Description

I have multiple storage locations (3 warehouses) which dispatch items to different areas (about 11) all within the same building and network. The system should work something like this. The different area request the items and amount (must be able to request as eaches or shipper) via Access, the request arrives to the storage location only if it stores that item. After getting the request the storage locations dispatches the items at which time they get subtracted from the system which tracks the quantity available. If the available quantity goes below minimum order amount the item owner (each item has needs primary and secondary owner) should receive an email (we use Outlook) indicating that the item and quantity available. I also want the capabilities to analyze the transactions to see item usage by location/cost and determine slow moving items.


Item Users

Users in the different areas which use and request the items in the database. Must request items in a form which must be able to filter items by usage locations. They need to be able to order in eaches or a shipper (box).

Storage Locations Users

Users who work in the area which holds the items. Must receive item request from item users via access. they dispatch the items wish then must be discounted from the available amount. Must be able to discount in eaches or shipper.

Item Owners Users

Users which are responsible for the ordering the items they own in the database. Each item must have a primary and secondary owner. Owners might own multiple items. It is their responsibility to reorder the items they own. They (both the primary and secondary owners) must be automatically notified by email (outlook) if any of their items has gone below the minimum order quantity. After ordering they must enter ordered amount as in transit.

Logistic User

Analyze transaction history to determine usage by area/cost and determine slow moving items.

The system will not have more than 15 active users at anytime, all within the same network. All users should work through ease to use forms. This should give a good indication of what I am looking for, I will provide additional information.

Taidot: Microsoft Access, Visual Basic

Näytä lisää: access inventory template, inventory template access, inventory access template, access inventory template multiple locations, inventory template, access inventory, visual basic cost, the active network, cost template, inventory access database template, looking access inventory template network, access inventory control template, transaction history, moving and storage, inventory database, dispatch, active filter, visual basic ordering system, access order, microsoft template access, inventory control template, access database transaction, database template access, inventory control system access, access control database

Tietoa työnantajasta:
( 0 arvostelua ) San Juan, United States

Projektin tunnus: #1708190

Myönnetty käyttäjälle:


I have 15 years exp in access design. I can assist. Donna

$250 USD 3 päivässä
(30 Arvostelua)

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


From our point of view it's a rather complex project with the database running on an external server. Several user roles have to be introduced with different functionality for each role. A certain high level of program Lisää

$2400 USD 30 päivässä
(26 arvostelua)

I have experience in this project

$220 USD 13 päivässä
(15 arvostelua)

Done previouly this type of work.I am interested .Can Send u [login to view URL] chk Pm

$250 USD 6 päivässä
(16 arvostelua)

Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]

$450 USD 30 päivässä
(3 arvostelua)

Dear Sir, Please read my PM.

$250 USD 5 päivässä
(13 arvostelua)

I can provide Template Access database according to requirement details

$70 USD 1 päivässä
(0 arvostelua)

Tenho uma grande experiencia em Access/vba, com certificação microsoft em office. Mais informações de uma olhada no meu profile. Obrigado

$200 USD 3 päivässä
(0 arvostelua)

Hi I am having 8 Plus Years of Experience in the following technologies 1. VB6/VB.NET/C#.Net 2. SQL Server 3. Crystal Reports 4. Access and in the following Domains 1. Inventory - Managing Stocks, Reorder le Lisää

$250 USD 5 päivässä
(0 arvostelua)

HI sir , We already have a database and a complete software for inventory.

$250 USD 14 päivässä
(0 arvostelua)