Đã hoàn thành

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.

Kĩ năng: Microsoft Access, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) San Juan, United States

ID dự án: #1708190

Được trao cho:


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

$250 USD trong 3 ngày
(30 Đánh Giá)

10 freelancer đang chào giá trung bình $459 cho công việc này


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 Thêm

$2400 USD trong 30 ngày
(26 Nhận xét)

I have experience in this project

$220 USD trong 13 ngày
(15 Nhận xét)

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

$250 USD trong 6 ngày
(16 Nhận xét)

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 [url removed, login to view]

$450 USD trong 30 ngày
(3 Nhận xét)

Dear Sir, Please read my PM.

$250 USD trong 5 ngày
(13 Nhận xét)

I can provide Template Access database according to requirement details

$70 USD trong 1 ngày
(0 Nhận xét)

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 trong 3 ngày
(0 Nhận xét)

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 Thêm

$250 USD trong 5 ngày
(0 Nhận xét)

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

$250 USD trong 14 ngày
(0 Nhận xét)