Find Jobs
Hire Freelancers

Categorize some data in MS Access VBA program

$30-250 CAD

Completed
Posted about 4 years ago

$30-250 CAD

Paid on delivery
If you know VBA, MS Access 2016 then this is easy for you! 1. Import: Form to import data from a csv file and puts it in a temp table. Data is always in same format. 2. a) Categorize: The data from 1 above in one of the fields contains a bit of string that you need to use to categorize it. b) Categorize 2: form shows you the data record by record and tries to match it with the same text in a category table (category table would only contain a substring of the string in the data table). c) If matched, the program adds all the values in the matching row from category table to the data and puts that new data in a "review" table. The original data gets appended to a "processed" data table d) if unmatched, the program asks the user to categorize it with the option to remember the categorization for future. The user is asked which part of the data string is to be used for categorization. Then this is added to the category table. e) Review stage: when temp table is empty, the "review" table is shown just to double check. User can make any adjustments as necessary. Categories values in the category are all from drop downs boxes sourced from data tables. This could be a subform on a form - user is asked to hit ok when done, this action ***appends*** all data from review table to categorized table and closes the form. e) Quality control: Once all the above is working, we can add the quality control stage - it won't add to the categorized table if a string made up of all the values concatenated together from import data matches anything else in the categorized database. It will be the easiest if we just do each stage separately. Once verified we move to the next stage (import, categorize, review, quality control) *** must be done in MS access 2016 *** you will be supplied with the category table and sample csv Should only take around 3-4 hours to do this including testing. Thanks for bidding!
Project ID: 23603397

About the project

16 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! This will require a user interface with few forms and some of the VBA coding. I think you are right about the time required for this. Can you send a CSV file? Regards, Branislav Mihaljev
$185 CAD in 7 days
5.0 (285 reviews)
7.8
7.8
16 freelancers are bidding on average $120 CAD for this job
User Avatar
Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar.
$100 CAD in 1 day
4.9 (220 reviews)
6.9
6.9
User Avatar
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 let me know so that we can discuss the timelines, budget and scope accordingly. Thanks Regards Jawad
$200 CAD in 7 days
5.0 (88 reviews)
5.8
5.8
User Avatar
Hi, I'm an MS-Access / VBA expert, and have experience in data import and quality control routine development, and I would LOVE to do this job for you. I can complete and deliver the Access database with all requested functionality, within a week or less, completed work fully functional to spec. Good quality work done. Thank you for considering my bid. Best wishes, Larry ~ Larry Anselof Technology Solutions - Providing a quality and reliable freelance software development service since 2004 ~
$140 CAD in 7 days
4.9 (47 reviews)
5.8
5.8
User Avatar
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a view what/how I can code for your project via Ms Access. Besides, I can provide access to any my MS Access application. I can code all based on your instructions via ms Access 2016 - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$250 CAD in 2 days
4.7 (60 reviews)
6.2
6.2
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$180 CAD in 2 days
4.9 (69 reviews)
5.6
5.6
User Avatar
Hi I'm an Access VBA developer with over 20 years experience. Data manipulation, creating functions in vba is my strongest skill. I love challenges like this and as I say, something I'm really good at. Get in touch, I'll do the work just as you need it. Many Thanks Darren
$140 CAD in 7 days
5.0 (6 reviews)
4.3
4.3
User Avatar
I can provide a complete Access application which you can use to categorize the data coming from CSV file. As I see it, you do have some (string matching) rules already present in the category table but they are not complete. Thus, new rules (new strings) should get added to the category table over the period of time as user uses the application. Right? I have FULL CONFIDENCE of helping you out here. A question though: How EXACTLY would the data from CSV file be matched with corresponding values from category table? Will there be multiple words, or even sentences, in the CSV file as data that will be matched? Further, will category table contain a single word that should be matched with CSV or will it contain multiple words? I am asking this because I want to know how the substring matching should work. Will the matching be carried out across words or at whole word boundaries? It will be beneficial if you provide some concrete examples of how matching should be done. Although new to Freelancer.com, I have extensive experience in Access, SQL, VBA, and allied technologies. I am completely familiar with Access Object Model and must tell you that it is very rich for programmatic manipulation.
$79 CAD in 2 days
4.9 (7 reviews)
3.5
3.5
User Avatar
Hi, I am a Software Professional developing software in MS Access with VBA for last 22 years. I would like to develop the database using MS Access 2016 as per your requirements.
$100 CAD in 3 days
3.6 (10 reviews)
3.9
3.9
User Avatar
I am a systems analyst with more than 7 years of experience in the management of Excel datasheets and Access databases in a multi-national company. Advanced level competence in data analisys for decision making and advanced knowledge of all Office tools. Design of databases, forms, querys, macros, reports, etc. I am available now, send me a text message with more information and I will answer asap.
$110 CAD in 3 days
5.0 (4 reviews)
2.8
2.8
User Avatar
Hello There, I have read your work requirement description. From the description it come to know about you have large csv files that you want categorized and want to create proper user friendly reports. I have created so much number of systems On Microsoft Access and all are running on 2016 version. I Have 5+year of experience of making databases using excel and Access. I will be right guy for it. And as per your term I will do it in few hours. Thanks for Sharing work.
$40 CAD in 1 day
5.0 (2 reviews)
1.2
1.2
User Avatar
I am ready for the following tasks: 1. Import: Form to import data from a csv file and puts it in a temp table. Data is always in same format. 2. a) Categorize: The data from 1 above in one of the fields contains a bit of string that you need to use to categorize it. b) Categorize 2: form shows you the data record by record and tries to match it with the same text in a category table (category table would only contain a substring of the string in the data table). c) If matched, the program adds all the values in the matching row from category table to the data and puts that new data in a "review" table. The original data gets appended to a "processed" data table d) if unmatched, the program asks the user to categorize it with the option to remember the categorization for future. The user is asked which part of the data string is to be used for categorization. Then this is added to the category table. e) Review stage: when temp table is empty, the "review" table is shown just to double check. User can make any adjustments as necessary. Categories values in the category are all from drop downs boxes sourced from data tables. This could be a subform on a form - user is asked to hit ok when done, this action ***appends*** all data from review table to categorized table and closes the form. please send me a message to discuss further. thanks
$100 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Friend, I can do this as I have done similar work before. I will not charge if the work is not up to the mark. Please send me the file and I can play around and no cost to you. Thanks
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Im going through your Project Details,we can do some sample before,first we can quick chat & discuss about it. Thanks ....
$30 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI i'm a native italian and i know Access 2016. If you send me the files i start immediatly the job. best regards
$100 CAD in 2 days
0.0 (1 review)
1.0
1.0

About the client

Flag of CANADA
Mississauga, Canada
5.0
205
Payment method verified
Member since Apr 19, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.