Find Jobs
Hire Freelancers

Access Database Needing Queries and Reports Made

$30-250 USD

In Progress
Posted about 8 years ago

$30-250 USD

Paid on delivery
I need an access database created for sales reporting. I don't know a ton about access and excel can only get me so far. We sell 20 products with 4 offices and 31 sales people. The need for more reporting is getting too difficult to manage in excel. I already built a shell but it looks like a 10th grader did it lol. Need input screen (20-25 fields) Need Queries and Reports (approx 20) Need to be able to import records from excel and not override existing data Extra info: report sold data vs sales targets by product, sales rep, and office I need to be able to enter estimated sales with multiple lines (eg you sell one customer 3 products), then to update that sales number later once actual payment received. I also need to be about to track # sold cases and # sold coverages against targets. The sooner the better. I already have 1800 rows of data for Q1 and am anxious to not have to do this manually every month. If this works out I may have another database for you to build to house my existing customer base. Thank you!
Project ID: 10115371

About the project

10 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
p.s I'll build an Access app just on you need. Again : In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$250 USD in 3 days
4.7 (83 reviews)
6.5
6.5
10 freelancers are bidding on average $200 USD for this job
User Avatar
Hello! I work with different DB for last 5 years and have created hundreds of different solutions database ( from simple Excel to much more powerful MsSQL/MySQL DB).Even my rating at this site not very high, i really know what i am doing. A have all skills You need for this project (and can show You examples for your confidence with similar tasks I have done). So for your task i will use next solutions : - Userforms will be user-friendly and allow you use key words for search and browse customers. - Split DB ( Frontend and backend splinted ) will allow multi-access for different users at one time If You need somebody who can manage really difficult thing, I am right person, i have good background in VBA, and all my DB work with 100% accuracy and performance. Hope for Your respond, Regards, Vlad.
$247 USD in 7 days
5.0 (65 reviews)
7.7
7.7
User Avatar
Hello I read the task and I'm not sure about price. I saw that other candidates proposed less budjet. 20 queries and reports? This is big number when I don't know anything about complexity and calculations. I can do VCL application form for input. If you have guidelines this can help with understanding of work.
$300 USD in 7 days
5.0 (88 reviews)
7.5
7.5
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks regards Jawad
$250 USD in 3 days
5.0 (87 reviews)
5.8
5.8
User Avatar
Hi... I would like to work on this project and let me know the details and have a discussion on your requirement... Thanks!!
$150 USD in 3 days
4.7 (15 reviews)
3.5
3.5
User Avatar
hi, i will be more than happy to provide you a solution as i do have ms access included in this is vba. I am also a certified ms sql server developer. please feel free to contact me and i look forward working along with you. kind regards,enrico
$86 USD in 3 days
4.9 (9 reviews)
3.2
3.2
User Avatar
Hi Sir/Ma'am, I would like to take this opportunity to work on this project. I having 4 years of experience in field of merchandising planning and analysis in retail.
$222 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fort Lauderdale, United States
0.0
0
Payment method verified
Member since Apr 3, 2016

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.