Find Jobs
Hire Freelancers

Convert Access file to simple mySQL app

$30-250 USD

Cancelled
Posted about 15 years ago

$30-250 USD

Paid on delivery
I have an Access database that we use to input sales for a non-profit coffeehouse ministry. Since we use volunteers to do everything for the ministry, I would like to get this procedure done on our website so that it can be done from any location instead of one person having the access database to work with. I have a small budget for this project but I think it should be simple since it is all based on Access data entry into tables, queries, and a couple of reports (one report but it has a sub-report on it). I am open to other suggestions but I was thinking of converting the file to mySQL and having a simple web app handle the input and reports. The database is attached and if you go to the Favorites, there is a list of operations that are performed. Some of these could be eliminated if using a program. Here is the overview of what they do: 1 - Enter Shift PLU data - This is where the user types in the Price Look Up Number and the quantity sold. This is done into a temporary table just to make data input easier. Only the PLU No and Qty are input and Step 4 appends those records along with other data (the sales date and info from the PLU table. I did it this way so that the date, shift, and price didn't have to be input for each line. We could input directly into the Sales table if the date & shift can be input just once and then 'carried over' into each record AND the price can be pulled from the PLU table and saved. The price is not totally necessary if this would put me over budget. 2 - Enter sales tax and paid outs. This is just a shortcut to input information into the SalesTotals table. 3 - Enter paid out receipts. This is just a shortcut to input information into the PaidOuts table. 4 - Print shift report and check totals. This is just a proofing report that prints the data to make sure it totals out correctly. This would be eliminated if information is input into the Sales table directly instead of using a temporary table and append query to put the data into Sales. 5 - Update Shift PLU to Sales Database. This is an append query that asks the user for Date and Shift and then appends each record from the temporary Shift table to the Sales table along with the price from the PLU table. This would be eliminated if sales are input directly into the Sales table. 6 - Clear temporary Shift data. This is an update query that deletes all records in the temporary Shift table. This would be eliminated if the sales information is input directly into the Sales table. 7 - Print Final Sales Report. This is a shortcut to the report that we would need as output (2009 Sales Report - Single Shift). It is based on a query of several tables to produce the output needed. If the subreport containing the PaidOut records is not possible, that might be OK . . but let me know up front. All other reports and queries can be ignored. Thanks for your bid on this project.
Project ID: 391023

About the project

14 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $172 USD for this job
User Avatar
Hello, I am web application developer from China, i read your post detail, but not see the attached database, can you send it to me on PMB so that i can try its functions first, thanks!
$250 USD in 5 days
5.0 (157 reviews)
7.7
7.7
User Avatar
please see pmb
$250 USD in 5 days
5.0 (28 reviews)
6.3
6.3
User Avatar
I can do for you.
$240 USD in 6 days
5.0 (29 reviews)
5.6
5.6
User Avatar
Hi, You have explained everything so well that I don't have any more questions. PHP/MySql is the best choice. Give a go ahead and I will get it started immediately. Thanks Venkat
$250 USD in 4 days
4.6 (21 reviews)
5.6
5.6
User Avatar
no prob, give me the details
$100 USD in 2 days
4.8 (61 reviews)
4.9
4.9
User Avatar
Kindly check your PMB for details.
$200 USD in 5 days
5.0 (7 reviews)
4.4
4.4
User Avatar
Please check PM.
$56 USD in 3 days
4.5 (2 reviews)
3.8
3.8
User Avatar
I am a professional programmer and have been engaged with a software development company. I am confident to do the job to your complete satisfaction. Please feel free to ask any queries or details. Thanks and best wishes for your project
$95 USD in 7 days
4.8 (3 reviews)
3.5
3.5
User Avatar
*** satisfaction guaranteed ***
$120 USD in 4 days
5.0 (6 reviews)
2.7
2.7
User Avatar
Hi, I can provide an easy to use, graphically pleasing web based php/sql database application. I will also offer support for any bugs and future developments. Regards, Matt
$150 USD in 7 days
5.0 (1 review)
2.6
2.6
User Avatar
it's quite simple. let's start right now.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, Kindly check your PMB for my profile and the details. Regards ANup
$100 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I could probably not only write the web and database application you seek, but I could host both the application and the database as well.
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Mt. Vernon, United States
5.0
32
Member since Sep 13, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.