Find Jobs
Hire Freelancers

MS Access data table comparison tool

$30-250 CAD

Færdiggjort
Slået op over 2 år siden

$30-250 CAD

Betales ved levering
We have a database in Access that is split into a front end and back end. Occasionally, our sister company will make changes to the data in their copy of some tables and send them to us. We need to compare the two tables to find any differences and highlight them. Then if the changes are acceptable a button on the form will update our copy of the table. The source table has about 35 columns and 5000 rows. There are two different tables that need to be compared. The tool needs to be general-purpose and able to compare any two tables and display the original on one line and the update data on the next row. Any differences should be highlighted in the second row. The form would show one row at a time, only where there is/are a difference, and show the complete record for both the original and update file. A separate project will be posted for a validation
Projekt-ID: 31825412

Om projektet

25 forslag
Projekt på afstand
Aktiv 2 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
$0 CAD på 2 dage
4,9 (326 anmeldelser)
8,0
8,0
25 freelancere byder i gennemsnit $190 CAD på dette job
Brug Avatar.
Hello! I'm a Databases Developer, Access, Excel and VBA expert more than eight years. I have completed many complex projects in my practice and I am ready to carry out your project in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir
$150 CAD på 2 dage
4,9 (253 anmeldelser)
7,1
7,1
Brug Avatar.
Hi There, I have reviewed your requirements carefully and I can definitely start immediately. But I have couple of questions on requirements, please ping me on chat to discuss more on that. Also I am 100% available during EST (New York Time) hours. I am expert in EXCEL/ACCESS/PYTHON/VBA/VB/.NET/SOAP/REST/API, SQL, MS Office, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts/graphs, formatting, templates, dashboard, etc. Around 16 years of experience in software development / architecture and worked on several complex enterprise level projects, Webscrapping (Facebook/ LinkedIn / Amazon / Aliexpress / eBay), Complex VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to work with you.. Have a nice day Thank you
$250 CAD på 5 dage
4,8 (32 anmeldelser)
5,4
5,4
Brug Avatar.
Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from you until your job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from you. Regards John
$155 CAD på 3 dage
4,8 (36 anmeldelser)
5,0
5,0
Brug Avatar.
I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can convert them to Rational DB, I can do its Normalization up to 3rd Normal form. I can show you my previous work related to DB. Please see my profile and reviews as well. Thanks
$500 CAD på 14 dage
4,7 (13 anmeldelser)
4,8
4,8
Brug Avatar.
Hello, kind regards, currently I have more than 10 years of experience in database processes (MS ACCESS, MYSQL, SQL SERVER, MARIADB, POSTGRESQL) in programming languages such as VB.NET, C #. I am the ideal person to help you in your project. Visit my profile without obligation.
$180 CAD på 7 dage
5,0 (22 anmeldelser)
4,4
4,4
Brug Avatar.
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
$250 CAD på 3 dage
5,0 (1 bedømmelse)
3,6
3,6
Brug Avatar.
Hi, I am a Database Developer, Access, Excel and VBA expert more than a decade now. I have completed many complex projects over the years, I am very efficient with building tables, forms, queries, custom functions and procedures. Outside my expert abilities, I am great at problem solving and can offer advice if needed to better solve your project. Much thanks in advance for considering me.
$250 CAD på 7 dage
5,0 (1 bedømmelse)
3,0
3,0
Brug Avatar.
Good day, I am an expert MS Access data table comparison tool I can start working immediately if you give me a go !!! ★★ MY EXPERTISE ★★ Visual Basic SQL Microsoft Access Database Programming
$140 CAD på 1 dag
4,3 (4 anmeldelser)
2,8
2,8
Brug Avatar.
Dear Sir, Madam, I am proficient in MS Access, I have been developing applications with for years. Looking forward to work with you. Thanks and regards.
$140 CAD på 7 dage
5,0 (4 anmeldelser)
2,3
2,3
Brug Avatar.
A Data Scientist with experience in SPSS, Python, R programming, R studio and anything related to data science and EXCEL guru, who is dynamic, reliable, resourceful, committed and organized with enthusiastic approach to succeed with a pleasant attitude. Possessing excellent analytical skill and good research background. Hit the chat button for more discussion. Regards Maurine
$140 CAD på 7 dage
5,0 (2 anmeldelser)
1,2
1,2
Brug Avatar.
Hello client, I wish you the best of luck in everything with you. As a professional developer, I have many years experiences of Database Please feel free to contact me and let’s discuss about your job in detail to finish your job correctly. If you award me the project, I can start working immediately and work full time. I would love to work with you. Look forward to hear from you soon. Thank you. Best Regards.
$200 CAD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi There, Is it possible to modify the structure of the source table? I am a seasoned DBA with background knowledge of different DBMS and SQL queries. Looking forward to hearing from you, Best regards
$150 CAD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
hi, i have rich experienced of C#/.NET, VBA, Access so that i can give you the perfect result. C#/.NET, VBA, Access is my top skill and i am majoring it for over 6 years. i have completed the several projects already so i have confident to complete your project 100%. if you want to discuss about the project, please contact with me. thank you.
$200 CAD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hello, I can help you with MS Access data table comparison tool I have more than 5 years of experience in below listed skills: Visual Basic SQL Microsoft Access Database Programming I have gone through your job posting and become very much interested to work with you. I am an expert in this field. For evidence you can see my profile. https://www.freelancer.com/u/globalseo614 I am a hard worker, productive and worthy of your attention I hope. Awaiting an affirmative response from you. Kinds Regards, Sunil
$150 CAD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Thank you for the detailed description of your project, 5000 rows is a lot to compare manually. I would suggest that you have a system developed that takes advantage of all of the automation power MS Access can offer by using VBA. I can imagine a system that that allows the user to simply choose the file from your sister company then runs a VBA module to compare each row/ field and tags the rows that need to be reviewed, Then the user can go through the tagged rows one at a time displaying the fields highlighted that are different. Once the row has been reviewed that row should have a field containing the data updated so that the user knows where they left off. I have over 40 years of experience as a software developer. The main focus of my career has been with GUIs starting with upgrading Mission Control Center for the Space Shuttle program at Johnson Space Center. Over the years I have implemented many projects with MS Access/ VBA that have amazed my clients as to how much of their tedious tasks I have been able to automate.
$250 CAD på 10 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for CANADA
Woodbridge, Canada
5,0
1
Medlem siden okt. 8, 2021

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.