MS Access For Actuaries Quiz

1. Here is an excerpt of a text file that you would like to bring into MS Access. What delimiter do you choose when importing into MS Access? ID",Name",City",State",Age", 1",Jim",Los Angeles",CA",56", 2",Jessica",Austin",TX",56",

About This Quiz

2. What's your name?

We’ll put your name on your report, certificate, and leaderboard.

2. For Task 4, for 2011 sales, what percentage in terms of counts comes of MP3 players?

3.98%

5.98%

19.92%

13.94%

3. For Task 6, you just want the column headers from the 2012 Claims Data. What is the most efficient way to do this?

Make a copy of the 2012 claims table, rename it 2013, and delete each of the rows

Create a Make Table query off the 2012 claims data named 2013 Claims data. Then delete the irrelevant rows.

Make a copy of the 2012 Claims data then bring in the Structure Only.

4. For Task 1, you need to merge in the Warranty Sales data with the Price data. Describe there merge. Warranty Sales is on the left and Price data is on the right.

Left Join on Item

Right on Brand and Item

Inner Join on Item

Left Join on Brand and Item