MS Access data validation tool

We have a database in Access that is split into front end and back end. Occasionaly, a sister company will make changes to the data in the back end 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.

Also, we need to check all the values in the table are within a valid range. The maximum and minimum values witll be defined with another table with the criteria for use based on one of the values in the original table.

Skills: Microsoft Access, Excel, Visual Basic, Database Programming, Data Processing

See more: ms access data entry, ms access data entry experience, ms access data entry multiple users, ms access trap validation text errors, ms access web customer registration database, data validation export database, ms access data entry form, ms access data entry form examples, ms access data entry forms, tim finch contract mysql ms access vba sql server database developer, data validation in database, ms access inventory and sales database, ms access connect to oracle database, export ms access table to oracle database, ms access data entry form new record, ms access data types list, ms access data entry form download, ms access inventory and sales database pdf, ms access vba close current database and open another, ms access data entry form examples download

About the Employer:
( 0 reviews ) Canada

Project ID: #31554389

34 freelancers are bidding on average $166 for this job

(474 Reviews)

ID : 31554389 Greetings, If the project needs an onsite visit , deployment & More

$140 CAD in 7 days
(259 Reviews)

[login to view URL] I have gone through your project requirements. I will develop tool in access to compare two tables in backend It will compare the two tables to find any differences and highlight them. Then if the changes are More

$140 CAD in 3 days
(501 Reviews)

Hello! I am ready to carry out your interesting project. You can read reviews about my work at: From the Microsoft Access, of course, familiar. Regards, Vladimir

$150 CAD in 3 days
(249 Reviews)
(192 Reviews)

I have read through the requirements and am confident of delivering as needed. I have a few queries: 1. Is it possible to get a copy of the front end and back end? 2. Do you need the comparison tool as MS Access scrip More

$250 CAD in 3 days
(52 Reviews)
(68 Reviews)
(55 Reviews)

Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please More

$150 CAD in 7 days
(91 Reviews)
(35 Reviews)
(52 Reviews)
(15 Reviews)

Quality work quickly Regards

$500 CAD in 5 days
(15 Reviews)
(49 Reviews)

Helllo there Are you want just tool or manually to do this i can do manully within very short time Regards ILYAS

$60 CAD in 1 day
(64 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

$100 CAD in 7 days
(36 Reviews)

I would like to assist you. Kindly advise me for further instructions. I used to code in dBase III or Clipper 5. Currently, I code in SQL, Visual Basic, Visual Basic For Application (VBA) C#, and R. Full-blown up softw More

$250 CAD in 15 days
(14 Reviews)

Hi I'm an Access VBA developer. I can build the function you need to do the work. I'd start by using a union query and grouping all of the values. This will produce a 2nd (or 2+) records for every record that is diffe More

$250 CAD in 1 day
(7 Reviews)

I am an accounting, MS ACCESS,STATS, economics, marketing and finance and excel expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across More

$50 CAD in 3 days
(8 Reviews)

Dear Sir, Madam, I am proficient in MS Access, I have long years experience developping applications with. Looking forward to collaborate with you. Thanks and regards.

$50 CAD in 1 day
(8 Reviews)