Which type product had the most complaints ordered by state

Assignment Help Database Management System

Reference no: EM131793843

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

Reference no: EM131793843

Questions Cloud

Calculation of the gross margin and profit margins : Come up with two publicly trading companies in the same industry, and find their income statements online (Yahoo! Finance usually has nice summaries).

What should black report as its allowance : Black estimates that 5% of accounts receivable will prove to be uncollectible. What should Black report as its Allowance for Doubtful Accounts at 12/31/12

What would be the number of shares outstanding : The company with the common equity accounts shown here has declared a 15 percent stock dividend when the market value of its stock is $43 per share

Determine the accounting rate of return : Determine the accounting rate of return? Determine the payback period? Determine the NPV assuming a minimum required rate of return of 8%?

Which type product had the most complaints ordered by state : In the primary key options window, select the option Choose my own primary key and select the Complaint ID field, then click Next.

What is estimate of the stock current price : A company has just paid a dividend of $ 2 per share, D0=$ 2. It is estimated that the company's dividend will grow at a rate of 17 % percent per year.

Calculate the cost of copyediting one manuscript for june : During June, Herring Associates incurred total production costs of $40,000. Calculate the cost of copyediting one manuscript for June

What is the peak electron concentration produced : The implanted region is assumed to be rapidly annealed so that complete electrical activation is achieved.

What is the prospective rate of return of the investment : A company purchase a piece of manufacturing equipment for an additional income. The expected income is $3, 500 per semester. Its useful life is 9 years.

User Account

All Pages