Завершен

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

Навыки: Microsoft Access, Программирование баз данных, Visual Basic, SQL

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Woodbridge, Canada

ID проекта: #31825412

Поручен:

(321 отзывов(-а))
7.9

27 фрилансеров(-а) готовы выполнить эту работу в среднем за $190

(262 отзывов(-а))
8.1
(114 отзывов(-а))
7.4
VladimirLilenko

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 Больше

$150 CAD за 2 дней(-я)
(252 отзывов(-а))
7.1
(78 отзывов(-а))
6.5
royalcalif

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 Больше

$30 CAD за 1 день
(101 отзывов(-а))
6.3
(66 отзывов(-а))
6.5
kevivu

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 Больше

$250 CAD за 5 дней(-я)
(32 отзывов(-а))
5.4
Softeria

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 Больше

$500 CAD за 14 дней(-я)
(13 отзывов(-а))
4.8
(4 отзывов(-а))
4.7
crypthne

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 Больше

$60 CAD за 7 дней(-я)
(37 отзывов(-а))
4.7
liveexperts123

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 Больше

$250 CAD за 3 дней(-я)
(1 отзыв)
3.6
(5 отзывов(-а))
3.3
trevollpereira

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 Больше

$250 CAD за 7 дней(-я)
(1 отзыв)
3.0
ArturNasonov

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 Больше

$30 CAD за 7 дней(-я)
(4 отзывов(-а))
2.5
ExpertSoul

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 за 1 день
(4 отзывов(-а))
2.8
hharrati

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 за 7 дней(-я)
(4 отзывов(-а))
2.3
maurineted5

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 Больше

$140 CAD за 7 дней(-я)
(2 отзывов(-а))
1.2
polonska

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 Больше

$200 CAD за 7 дней(-я)
(0 отзывов(-а))
0.0
jnyambura417

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 Больше

$180 CAD за 5 дней(-я)
(0 отзывов(-а))
0.0
delahoussayec

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 за 2 дней(-я)
(0 отзывов(-а))
0.0