Closed

Database for client & inventory management

I have a subscription company and need to be able to do the following (all on my iphone):

1) When a client subscribes, I need to be able to fill out a quick form (as the one attached). This one pre-populates certain items after I fill in the info - you can see in the excel file (VBA). I need it to do the same. For instance once I know the age, the excel file tells me what pre-set box to pack and also the birthday month gets highlighted.

2) I need to be able to move the client from "active" to "cancelled" at the click of a button. Right now I print this sheet out and move it from active to cancelled in a physical folder. I need to be able to do that on my phone.

3) When it is time to send the client his/her monthly box, I need to be able to scan each item (they all have bar-codes) with my phone and have the database show what I packed for the client this month. It should also check for duplicates so I don't send the client the same item.

4) At the same time I need it to keep track of inventory. I have a Excel file with each item I have currently along with each item's bar-code. Ideally when I scan an item for a client's box, it should subtract 1 from that items total in my inventory. It should alert me when I am low.

Skills: Excel, Microsoft Access, PHP, Software Architecture, Visual Basic

See more: access database bakery inventory management, mysql java database project inventory management, inventory management database design, access inventory management database, inventory management mysql php database, php inventory management project database, microsoft access 2007 inventory management database template, access 2007 inventory management database, inventory management database script, access database inventory management, openoffice database inventory management, free inventory management database using open office, ms access inventory management database free, database design inventory management system, database server inventory management

About the Employer:
( 0 reviews ) United States

Project ID: #16691071

23 freelancers are bidding on average $193 for this job

cgullapalli

HI, I am good at Excel and vba. I have reviewed the file provided and the description. Looking forward to discuss further in the chat and get more clarity on the work scope. Happy to work on the project after a s More

$250 USD in 2 days
(687 Reviews)
7.7
schoudhary1553

Hello, I have the good knowledge of Database for client & inventory management. I have more than 5 years of experience in Excel, Microsoft Access, PHP, Software Architecture, Visual Basic. We have worked on several More

$200 USD in 3 days
(247 Reviews)
7.4
imagicaworld

Hi We understand your requirements and our aim is to analyze your requirements in a logical way and give you the perfect solution. Please see my past work:- [login to view URL] waiting for your kind More

$155 USD in 3 days
(58 Reviews)
6.1
kanwarcheema

Hello sir, I have read your project description given here and qualifications it needed to complete the job. I would like to discuss it in more details, so that you can be sure that I can do this job. Before tha More

$250 USD in 8 days
(44 Reviews)
6.0
$155 USD in 1 day
(74 Reviews)
6.2
pkcyber

I can develop web application for you which you can access on any phone or computer. It will contain all features as you described in project description.

$250 USD in 10 days
(34 Reviews)
5.6
SohaibRehman17

Hi sir , Sir i have 7 years experience with your project skills i can provide you quality work on time Can you please come to the chat box so we can easily discuss about project details.. Thank you

$200 USD in 3 days
(39 Reviews)
5.4
$155 USD in 3 days
(14 Reviews)
4.9
dvcontact

Hi, I have read very carefully your project details about developing a program for client inventory management. I am absolutely sure that I can complete this project professionally. Before you award this project, I More

$150 USD in 3 days
(24 Reviews)
5.2
$155 USD in 3 days
(6 Reviews)
4.0
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$200 USD in 7 days
(16 Reviews)
4.2
$155 USD in 3 days
(8 Reviews)
3.6
crocodile305

Hi.. How are you? I saw your description carefully. Owing to my rich experience in this field , i can say i can do this perfectly. I have many top skills like Excel, Microsoft Access, PHP, Software Architecture, More

$155 USD in 3 days
(4 Reviews)
3.4
binishimran

I am a researcher and can do this task efficiently. Relevant Skills and Experience [login to view URL]

$333 USD in 3 days
(0 Reviews)
0.0
mfouda2030

Hey, I'm interested in your project. Please send me a message so that we can discuss more.

$155 USD in 10 days
(0 Reviews)
0.0
bhargavrajput

I will give you free support till 3 month

$111 USD in 10 days
(0 Reviews)
0.0
$388 USD in 10 days
(0 Reviews)
0.0
Clandestine12212

This seems challenging and which is the only reason I wish to give this a try. *************************************************************************************************************************************** More

$222 USD in 3 days
(0 Reviews)
0.0
manjunath024

I am a Developer, Web designer and computer programmer with over 4 years of experience on both client and server sides. I have advanced skills in CMS, PHP, MySQL, Javascript, HTML, Jquery, Magento, and CSS to name a f More

$222 USD in 3 days
(0 Reviews)
0.0
poonamsabharwal

I HAVE GONE THROUGH THE SUBSCRIPTION OF WORK. I UNDERSTAND SUBSCRIPTION FORM TO BE FILLED BUT I DON'T UNDERSTAND FIN DATE?. PLEASE CLARIFY WHAT IS THE FIN DATE? REST OF THE INFORMATION YOU REQUIRED BY YOU IS CLEA More

$155 USD in 3 days
(0 Reviews)
0.0