Suoritettu

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

Taidot: Microsoft Access, Tietokantaohjelmointi, Visual Basic, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Woodbridge, Canada

Projektin tunnus: #31825412

Myönnetty käyttäjälle:

(321 Arvostelua)
7.9

27 freelanceria on tarjonnut keskimäärin $190 tähän työhön

(262 arvostelua)
8.1
(114 arvostelua)
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 Lisää

$150 CAD 2 päivässä
(252 arvostelua)
7.1
(78 arvostelua)
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 Lisää

$30 CAD 1 päivässä
(101 arvostelua)
6.3
(66 arvostelua)
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 Lisää

$250 CAD 5 päivässä
(32 arvostelua)
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 Lisää

$500 CAD 14 päivässä
(13 arvostelua)
4.8
(4 arvostelua)
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 Lisää

$60 CAD 7 päivässä
(37 arvostelua)
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 Lisää

$250 CAD 3 päivässä
(1 arvostelu)
3.6
(5 arvostelua)
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 Lisää

$250 CAD 7 päivässä
(1 arvostelu)
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 Lisää

$30 CAD 7 päivässä
(4 arvostelua)
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 päivässä
(4 arvostelua)
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 päivässä
(4 arvostelua)
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 Lisää

$140 CAD 7 päivässä
(2 arvostelua)
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 Lisää

$200 CAD 7 päivässä
(0 arvostelua)
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 Lisää

$180 CAD 5 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
0.0