Build a Microsoft Access Database (format 2013 or 2016) with 797 records, and populate each record with one of the 797 records available from this URL: [login to view URL]
The Access Database file should have the following field layout:
LSRP License Number
Company or Organization
Every field should be formatted as "Text", even fields that contain non-alpha content such as "LSRP License Number", "Phone Number", and "Zip".
Any field that is not populated in the online data should exist in the Access Database, but have a null value.
We are seeking a fixed price bid.
Acceptance criteria: All 797 records in the Access Database must be populated with the same data, in the correct fields, as if we manually opened each record in the online member directory, and copied these into the Access Database locally. No more than 10 records (of of the 797) can have layout errors or be corrupted. Format is alpha, upper and lower, the same as in the online data source.
It is possible that only 786 records are valid, with 11 null or defective records, so if your database has 786 properly formatted records, that will satisfy the delivery requirement. We believe 434 records will contain an email address.
Additional clarification (posted 7aug2018 at 4:50pm New York time): There is confusion by some bidders. The fourteen (14) fields I described are the maximum number of fields that may exist in any of the online records. But many online records will contain fewer fields. In the online record source if there is no value populating a field, then the field name does not exist in the online record. So the programmatic scraping must check for the appearance of each field name in each record, and IF it exists, then scrape the adjacent value into the correct field. So some intelligence is required in any programming.
53 freelancers are bidding on average $131 for this job
Dear Client, I understad the scope of work completely. I ensure the job will be done to perfection. Your satisfaction is my sucess. So please provide me the opportunity to carry out the project for you. Roy
I have vast experience on MS Access database, SQL, VBA etc. Please see my portfolio on below link and get an idea about my potential. [login to view URL] Thanks