Suljettu

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.

Taidot: Microsoft Access, Excel, Visual Basic, Tietokantaohjelmointi, Tietojenkäsittely

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

Tietoa työnantajasta:
( 0 arvostelua ) Canada

Projektin tunnus: #31554389

34 freelanceria on tarjonnut keskimäärin $166 tähän työhön

(474 arvostelua)
8.4
illuminesoft

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

$140 CAD 7 päivässä
(259 arvostelua)
7.5
Prashantskin

[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 Lisää

$140 CAD 3 päivässä
(501 arvostelua)
7.2
VladimirLilenko

Hello! I am ready to carry out your interesting project. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir

$150 CAD 3 päivässä
(249 arvostelua)
7.1
(192 arvostelua)
6.8
hits

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 Lisää

$250 CAD 3 päivässä
(52 arvostelua)
6.7
(68 arvostelua)
6.5
(55 arvostelua)
6.2
jawadaman

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 Lisää

$150 CAD 7 päivässä
(91 arvostelua)
5.8
(35 arvostelua)
5.9
(52 arvostelua)
5.6
(15 arvostelua)
5.8
maysam

Quality work quickly Regards

$500 CAD 5 päivässä
(15 arvostelua)
5.4
(49 arvostelua)
5.4
PERPETUAL0

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

$60 CAD 1 päivässä
(64 arvostelua)
5.0
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ää

$100 CAD 7 päivässä
(36 arvostelua)
4.7
tbrifki64

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 Lisää

$250 CAD 15 päivässä
(14 arvostelua)
4.5
oxleyda73

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 Lisää

$250 CAD 1 päivässä
(7 arvostelua)
4.3
huzaifarizwan995

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 Lisää

$50 CAD 3 päivässä
(8 arvostelua)
4.0
hharrati

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 1 päivässä
(8 arvostelua)
3.8