Web Scraping and VBA scripting with MS Access storing data and creating CSV data file

In this project, I want Data Scraped from websites into a MS Access VBA Script with Form and CSV Tab Delimited Output file. This project requires you to do the following: • Create a form with the following options: o Add New Sites o Modify Existing Sites o Add New Fields o Modify Existing Fields o Check for Duplicates o Create Output • Tool to scrape different websites and store the data in MS Access tables called SITENAME o SITENAME table should store all the required data to scrape individual websites  Each site can have different class or div elements that will be used when scrapping that site. o As part of this project I will give you 2 URL’s for you to set up Scrape and store data. Data scraped should be in a new table SITENAME-DATA table – one table for each site. This will allow to check for duplicated data when site is re-scraped in the future.  Ability to add additional sites in the future  Ability to add additional fields in the future o Option in the script to check for duplicate data in the Event Name field in the SITENAME-DATA table and chose yes/no to have it included in the output CSV file. o Create a CSV output file in UTF-8 Tab delaminate with the data below:  Ability to have some fields prepopulated based on the site that being scrapping OR scrapped (see valid data below).  Three of the data fields will be dates and I will need to be modified and formatted UTF-8 M/D/YY HH:MM for the CSV output. The field titles and info that I want for each field of my output: Event Name Valid Data: text from site Description Valid Data: text from site // or text that I enter should allow me to concatenate Event Name and Location with other words. Start Date Valid Data: text from site Format: UTF-8 M/D/YY HH:MM End Date Valid Data: text from site Format: UTF-8 M/D/YY HH:MM Logo Valid Data: will be a URL scraped from site with the image // or a URL that I enter Location Valid Data: I want to enter and store this based on the site being scraped Website Valid Data: URL from site scraped // or a URL that I enter Website Title Valid Data: this will be the same data as the Event Name