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
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 in the UK. This role has exposed me to many aspects of database development and administration including SQL Server Installation, performance tuning and monitoring, backup and recovery, Database and Server Security, the design and implementation of new systems, converting Access databases to SQL Server. Moving transferring data between data sources - Access to SQL Server Oracle to SQL Server etc (ETL). I am certified in DTS and I also have experience using other ETL Solutions.
The jobs I have undertaken on RAC include writing 10 articles on the SQL Server 2000 Installation process, converting a SQL Server database to access and developing a time sheet application with both front and back end developed in access.
I also have experience of ASP and PHP web application technologies.
If you interested in my services please can you answer my following questions so I can further understand what is required from this project:
- When does the projet need to be completed?
If I can be of any further use please do not hesitate to contact me.
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
Sir,
We will do the projects as per your requirements.
We have professional team for software development, web designs, development & hosting.
meccassi.