Concluído

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

Habilidades: Microsoft Access, Programação de Banco de Dados, Visual Basic, SQL

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Woodbridge, Canada

ID do Projeto: #31825412

Concedido a:

(321 Comentários)
7.9

27 freelancers estão ofertando em média $190 nesse trabalho

(262 Comentários)
8.1
(114 Comentários)
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 Mais

$150 CAD in 2 dias
(252 Comentários)
7.1
(78 Comentários)
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 Mais

$30 CAD em 1 dia
(101 Comentários)
6.3
(66 Comentários)
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 Mais

$250 CAD in 5 dias
(32 Comentários)
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 Mais

$500 CAD in 14 dias
(13 Comentários)
4.8
(4 Comentários)
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 Mais

$60 CAD in 7 dias
(37 Comentários)
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 Mais

$250 CAD in 3 dias
(1 Comentário)
3.6
(5 Comentários)
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 Mais

$250 CAD in 7 dias
(1 Comentário)
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 Mais

$30 CAD in 7 dias
(4 Comentários)
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 em 1 dia
(4 Comentários)
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 in 7 dias
(4 Comentários)
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 Mais

$140 CAD in 7 dias
(2 Comentários)
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 Mais

$200 CAD in 7 dias
(0 Comentários)
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 Mais

$180 CAD in 5 dias
(0 Comentários)
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 in 2 dias
(0 Comentários)
0.0