MS Access data table comparison tool

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

Skills: Microsoft Access, Database Programming, Visual Basic, SQL

See more: data decrypted ms access database, extract images stored ms access database long binary data format, ms access create table show, ms access data entry, ms access data entry experience, ms access data entry multiple users, ms access stack table, ms access data entry form, ms access data entry form examples, ms access data entry forms, ms access update table from another table, ms access data entry form new record, ms access data types list, ms access data entry form download, ms access project for school management database, how to use ms access 2007 to create a database, ms access data entry form examples download, ms access data analysis tutorial, ms access inventory table, ms-access data macro after update

About the Employer:
( 0 reviews ) Woodbridge, Canada

Project ID: #31825412

Awarded to:

(321 Reviews)

27 freelancers are bidding on average $190 for this job

(262 Reviews)
(114 Reviews)

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 wit More

$150 CAD in 2 days
(252 Reviews)
(78 Reviews)

Hi Mr. Employer, I have a lot of experience in Access and I can do this project in an effective manner with 100% accuracy report to your requirements. I had gone through your project proposal and I would like to discus More

$30 CAD in 1 day
(101 Reviews)
(66 Reviews)

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 du More

$250 CAD in 5 days
(32 Reviews)

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 conve More

$500 CAD in 14 days
(13 Reviews)
(4 Reviews)

I'm an experience .NET developer, have been in this field for more than 5 years and working with many .NET related project (using C#/VB/ASP.NET with Angularjs). I also a MS Access and VBA developer, I've been in this f More

$60 CAD in 7 days
(37 Reviews)

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 More

$250 CAD in 3 days
(1 Review)
(5 Reviews)

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 More

$250 CAD in 7 days
(1 Review)

Hello, Dear client! I've just read your description and guarantee to complete perfectly your job. I have 10+ years experience in the fields such as your requirement. You will get a good result after hiring me. My main More

$30 CAD in 7 days
(4 Reviews)

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 in 1 day
(4 Reviews)

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 in 7 days
(4 Reviews)

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 t More

$140 CAD in 7 days
(2 Reviews)

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 f More

$200 CAD in 7 days
(0 Reviews)

MASTERS SOFTWARE ARCHITECTURE EXPERT IN Visual Basic SQL Microsoft Access Database Programming HELLO, I have understood your SPECIFICATIONS for the task. I have over 5 YEARS’ experience in this field and have adverse More

$180 CAD in 5 days
(0 Reviews)

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 in 2 days
(0 Reviews)