Corporate Deduping Module
April 9, 2013
1) Objective: The objective of this module is to determine if the records marked Dup in the Verify column in tblCorp are actually duplicates.
2) Method: The method we want to use to determine is the following
a. The program will go to the first record with a Dup in the Verify Column.
b. The program will then take the first 7 characters of the record in the CoMstrName and check if the 7 characters are located in another record.
i. If the program finds a record with the same 7 characters in the same order then it will leave the Dup column unchanged.
ii. If the Program does not find a record with the same 7 characters in the same order then the program will clear the Dup characters from the Verify Column for that record.
c. This process will be completed for each of the records in the table.
3) The programming should be done in VBA and be incorporated as a Module in the Access Program.
4) It should also be easy for the user to change the number 7 to select fewer or more characters.
5) The size of tblCorp in production will exceed 50K Records
Hi, thank you for your detailed specification. I have over 12 years experience building complex database systems in MS Access and could complete this project for you within an hour.
$40 USD en 1 día
4,9 (23 comentarios)
5,5
5,5
17 freelancers están ofertando un promedio de $69 USD por este trabajo
Using VBA would work well for this project. I could design it so a Input box will appear asking you how many characters you would like to evaluate. I am thinking this would probably take 4-5 hours.
For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create. Please feel free to ask any questions I am always willing to share my experience.
Best of luck with your search.
Michael
p.s. I am based in Phoenix AZ, MST, in case you would like to call and discuss
Hi There, MS Access with VBA is my speciality, I'd like to work on this project! I've worked on many data integrity type projects which include this type of work.
Hello. I have already created a proof-of-concept design for your problem and believe I could deliver a solution within 2 hours, perhaps longer if tweaks are required.
Please let me know if you have any questions.
Thanks for the opportunity to bid on your project.
I submit my bid having read your tender advert and understanding requirements of same!
If awarded, I will bring over 19 years of technical programming experience along with very strong Ms Access (All Versions) experience to bear to ensure that your application is delivered in a timely and professional manner.
Please contact me if you need clarifications on any or all aspects of my bid.