You would like to have someone who has experience in Microsoft Access. I need to run a query on the first CSV file in the link below to answer the question(Which type product had the most complaints ordered by state?)
And then click on the first CSV link and save to your computer
After that open Microsoft access on your computer then follow the instructions below
· Create a blank database in Access
· Under the External Data Menu, select the Text File export option and browse to the location in which you saved the CSV file - ensure that the ‘Import the source data into a new table in the current database' option is marked
· When the Import Text Wizard opens, use the following settings:
Delimited - Characters such as comma or tab separate each field, then click on Next
In the delimiter options window:
Select the Comma option as the delimiter
Under the Text Qualifier dropdown, select the double quote option ("),
Check the box for First Row Contains Field Names (if you get a message that some names are not compatible and Access will auto name, just click OK)
Click on Next
· In the field specifications window, just click Next
· In the primary key options window, select the option Choose my own primary key and select the Complaint ID field, then click Next
· Name the table Consumer_Complaints and click Finish
After that run a query to answer the question below
Which type product had the most complaints ordered by state?
Then send me the database file with the query included