Em Andamento

Warehouse Inventory Access 2003 Database

OBJECTIVE: Create a new database with front-end interface and reports

DESCRIPTION: This Access 2003 database will manage inventory in a warehouse. It will include a data entry form(s) and work order reports. Items stored in warehouse belong to customers; therefore, customer data must be recorded. Data must be recorded to track which employee performed which action(s) for which customers on which items in which locations at what date/time.

DATABASE TO USE: Access

OPERATING SYSTEM: Windows XP

PROGRAMMING LANGUAGE TO USE: Not sure - developer should suggest (if one is needed)

DATABASE SIZE: 5,000- 10,000 records

NUMBER OF SCREENS FOR FRONT END: I'm not sure

NUMBER OF REPORTS: Less than 10

TECH SUPPORT REQUIRED: None required

EXPERIENCE LEVEL OF CLIENT: I have general knowledge about what I need

ADDITIONAL INFORMATION:

Customer Table: Customer ID; Company Name; Mailing: Address, City, State, ZIP; Delivery: Address, City, State, ZIP; Contact person 1; Contact person 2; PIN for contact person 1; PIN for contact person 2; Phone 1; Phone 2; Email address; Route.

Item Table: Item ID; Type; Description; Item Retention; Customer ID; Item Status

Item location Table: Location ID; Location description; Location notes; Item ID.

Work Order Table: Work Order ID; Customer ID; Item ID; Location ID; Employee ID; Date/Time; Item action (Add, retrieve, refile, remove).

Employee Table: Employee ID; First Name; Last name.

Call log Table: Log ID; Employee ID; Employee name; Date/Time; Notes

Need form(s) to add, retrieve, remove, and refile items, should include employee ID and date/time of action.

Add: new item comes into the warehouse

Retrieve: item is taken from the warehouse with the intention of returning it at a later time

Remove: item is taken from the warehouse with NO intention of returning it at a later time

Refile: item that has been retrieved returns to the warehouse

Need work order reports to display customers’ orders.

Multiple types of storage items: Small box, medium box, large box, and file.

Locations: 5000 locations total

Small boxes are stored in locations 1-1250

Medium boxes are stored in locations 1251-2500

Large boxes are stored in locations 2501-3550

Files are stored in locations 3551-5000

DELIVERABLES: Access database file(s) and any other files including source code that was used

Habilidades: Processamento de dados, Área de trabalho do Windows

Ver mais: warehouse inventory access database, access warehouse database, access 2003 inventory database, access warehouse inventory database, warehouse access database, inventory access 2003, warehouse access 2003, warehouse database access, warehouse inventory access, access 2003 warehouse, access 2003 inventory, access warehouse inventory, access database warehouse, access 2007 warehouse inventory, warehouse inventory database access, access 2003 database inventory, access 2003 warehouse database, inventory access database 2003, database access 2003 warehouse, access 2003 warehouse inventory, inventory calculation access 2003, warehouse database access 2007, warehouse database example access, access 2003 inventory system, database inventory location

Acerca do Empregador:
( 0 comentários ) Magnolia, United States

ID do Projeto: #151935

Premiar a:

KellogITSolution

Hi Please check your PMB for my bid. Thanks

$30 USD em 6 dias
(7 Avaliações)
3.4

8 freelancers estão ofertando em média $81 para este trabalho

trupti

Please check PMB. Thanks

$85 USD in 7 dias
(1 Comentário)
1.6
ProExpert

Please check PMB........

$100 USD in 10 dias
(1 Comentário)
1.0
EllisRemoteDBA

Hi, I have extensive experience in Databases - MS SQL Server, Oracle and MS Access. I hold Microsoft Certification (MCDBA SQL 2000 and MCTS SQL 2005) and I work as a Senior DBA for a large public sector organisation Mais

$100 USD in 4 dias
(0 Comentários)
0.0
OnQuailty

Dear Sir/Madam,I have several years experiences on DB,I can do it quickly,Thanks!

$60 USD in 3 dias
(0 Comentários)
0.0
kachhapbk2

Sir, I have +7 years of working experience in MS Access. I could design a clutter free and a decent database for you if given a chance. Regards, B K Kachhap

$80 USD in 5 dias
(2 Comentários)
0.0
fieryflash

Please check PMB. I could design simple and suitable database for you.

$90 USD in 10 dias
(0 Comentários)
0.0
meccassi

Sir, We will do the projects as per your requirements. We have professional team for software development, web designs, development & hosting. meccassi.

$100 USD in 10 dias
(0 Comentários)
0.0