Find Jobs
Hire Freelancers

Build a comprehensive Access Database

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I have a excel spreadsheet that lists all of our customers by their respective customer ID number. For each customer there are multiple returns to pay. So let's say for example, customer with ID number 2000 has 3 returns to be filed and paid. In this case the customer ID is listed 3 times on the spreadsheet. In order to reduce redundancy, I would like to have a database which allows to generate reports and pop up windows. In there we should be able to enter the customer ID and it will auto populate all the customer's information including address. Within that window there should be another drop down menu to select from several returns so that we an enter payment date, payment amount, discount received, eft date, and confirmation number. It should also list that tax accountant that is responsible for the customer.
Project ID: 20867846

About the project

38 proposals
Remote project
Active 5 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
38 freelancers are bidding on average $184 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD in 5 days
4.9 (360 reviews)
8.0
8.0
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have a database. The Access database will run on PCs. I will charge you $150* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Access, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$150 USD in 5 days
4.9 (313 reviews)
7.7
7.7
User Avatar
Hello! I am Branislav, Microsoft Access MVP for 2008 and 2009 (Most Valuable Professional title), professional Access, SQL and Office programmer for past 25 years, contributing editor of printed PC magazine and one of the top programmers on this platform with all projects completed and with an average rating of 5.0. Regarding the program and project, I think Access is a way better tool for this than Excel. With database, it is a lot easier to handle such data. We need to "normalize" data, so there will be no redundant entries at all. We can talk about the details in the chat if you like. Please check my profile where you can see screen-shots of some of the recent applications I have made using MS Access and reviews from other employers. That is just a small part of it - if you need something specific, let me know! I am online for most of the day and usually between 10 AM and 24 PM GMT time (UK time), including weekends. Not just while the project is alive, but also when it is completed, if you need my support. Best regards, Branislav Mihaljev
$180 USD in 7 days
5.0 (290 reviews)
7.7
7.7
User Avatar
Hi, Sir. Thanks for posting job. I read your requirements carefully. I am very interested in your work. I am expert in Database programming like Mysql, SQLite, MS SQL and MS Access. If you hire me, i'll do my best for you and I'll finish in time. Best regards.
$50 USD in 7 days
5.0 (160 reviews)
7.3
7.3
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$150 USD in 3 days
4.9 (199 reviews)
6.8
6.8
User Avatar
Hi, Would you like to see a quick demo of your project on building a Microsoft Access database that will generate reports in which customers ID will be entered and their information will be auto populated completed before you award the project? You can consider it professionally done in less than 24 hrs. Rather than just show you past similar projects, I want to exceed your expectations by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
$150 USD in 5 days
4.9 (55 reviews)
6.5
6.5
User Avatar
Hey, As you rightly mentioned, what you are looking for can be best accomplished using Access. I can create a setup for you that will allow you easily manage the customer data and show details when you enter the ID. I have done several similar projects. Please send a message to me and I would be able to share some examples. Look forward to hear from you. Best Regards, Rishi
$250 USD in 15 days
4.9 (124 reviews)
6.5
6.5
User Avatar
SHOWCASE I have done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-design-18665960/ • https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ • https://www.freelancer.com/projects/database-programming/data-base-search-options/ I can also produce a sketched prototype for this project and upload on YouTube. INTRODUCTION I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008
$120 USD in 15 days
4.8 (25 reviews)
6.0
6.0
User Avatar
i have extensive experience in Microsoft Access development with Marcos for excel i can handle this project please send me message to discuss your requirements in details
$222 USD in 3 days
5.0 (40 reviews)
5.4
5.4
User Avatar
Dear Client, I am interested in migrating your MS-Excel based record system in to MS-Access based system. It will created on MS-Access 2016 and all your current data will be migrated into the new system. Furthermore, the update/add records can be done on the Forms. Thank you. Regards, Shiv
$250 USD in 7 days
5.0 (12 reviews)
5.5
5.5
User Avatar
Thank you for giving me the opportunity to express my interest on your project. This project is related to my are of expertise. I can provide you best support on your project. let's have a chat and I am highly interested to take care of your project. I can create MS Access database with all these data points. I have some similar professional databases if you want i can show you some of the live. let's have a chat and have a look at my previous work before you hire me. I am confident on my skills.
$240 USD in 10 days
4.8 (32 reviews)
5.4
5.4
User Avatar
Hi, My name is Florin and i am a database applications developer. After going through the project description and studying the attached excel file screenshot, I can provide a simple and user friendly solution for your needs that will consist of two files: - a database file to store the records; - an interface file that will handle all the queries: add, view, edit, search, delete, export, reports etc. I can provide a demo in just a couple of hours, based on the description, if you'd be interested to see how it might look and work. Also, i will provide future support for the app (tweaks and updates) for as long as you need. I've been doing so for all of my apps. Thank you for your time! Florin
$150 USD in 7 days
5.0 (20 reviews)
5.2
5.2
User Avatar
Taking first glance of your project Build a comprehensive Access Database details it seems sound interesting to me. please initiate the chat stream to discuss complete details inclusing time and budget.
$150 USD in 7 days
5.0 (16 reviews)
4.8
4.8
User Avatar
Hi Nice to meet you. I have a lot of experience in data scraping. I can build web portal for import excel and show table. Just share me your excel file. Then I can send me more details. Regards Lian
$140 USD in 1 day
4.6 (13 reviews)
5.1
5.1
User Avatar
Hi, I have been an independent Access programmer in the New York Metro area for the last 20 years. Access is all I do, full-time. Hence I work quickly and efficiently and have a lot of great ideas from all the projects I have worked on. I have designed thousands of programs for hundreds of companies in the New York metro area. I have completed over 150 jobs on Upwork/Elance/Freelancer/Guru. I am available by phone or email, business and non business hours. and will be around in the future if you need little tweaks. I can respond quickly to requests. Better known companies I have worked for over the years are Shredit, Shiseido, Multi-Lok , The Alzheimer's Organization , Waterjel and Shop Rite
$250 USD in 7 days
5.0 (6 reviews)
4.7
4.7
User Avatar
I have many experiences in Excel, Access. I can show you my projects via chatting. I can complete your project successfully. Thanks.
$140 USD in 7 days
4.8 (19 reviews)
4.7
4.7
User Avatar
Hi there, Expert here! Sir i have read your project and its match with my 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
$180 USD in 1 day
5.0 (4 reviews)
4.0
4.0
User Avatar
Hello, I'd really like to work for you. I'm an excel and access expert and so your project should be no big deal. To clarify it. You have a big excel file with a lot of customer data. Some of the data like the adresses are redundant. Now you'd like to have a Access Database with a report where you can search for customers. It's not too difficult. I'll make 2 tables. 1 with the customer data like adresses and name and another table with an 1 to n relation. So 1 customers can have several datasets in the secon table. In the report you cann choose and edit the datasets per customer. Everything right? Than I'm a good choice because I've already made somthing similar not to long ago. Hope to hear from you so we can discuss the details via chat. Kind regards Emanuel
$180 USD in 3 days
5.0 (6 reviews)
4.2
4.2
User Avatar
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.
$100 USD in 5 days
5.0 (8 reviews)
4.3
4.3
User Avatar
Hi,I can build this application by Access DB , vb.net and crystal reports, I have experience in MS SQL server,asp.net and VB.net more than 12 years, please send more details to see how I can help you. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#,asp.net, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$190 USD in 7 days
4.9 (16 reviews)
4.0
4.0

About the client

Flag of UNITED STATES
Irving, United States
0.0
0
Member since Mar 29, 2019

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.