Search

Take Quizzes
- - Animal
  - Nutrition
  - Love
  - Relationship
  - Computer
  - Sports
  - Society
  - Business
  - Geography
  - Language
- - Personality
  - Harry Potter
  - Movie
  - Television
  - Music
  - Online Exam
  - Health
  - Country
  - Art
  - Entertainment
- - Celebrity
  - Math
  - Game
  - Book
  - Fun
  - Science
  - Food
  - History
  - Education
  - All Topics
Create a Quiz

Search

Create A Quiz
- Animal
- Nutrition
- Love
- Relationship
- Computer
- Sports
- Society
- Business
- Geography
- Language
- Personality
- Harry Potter
- Movie
- Television
- Music
- Online Exam
- Health
- Country
- Art
- Entertainment
- Celebrity
- Math
- Game
- Book
- Fun
- Science
- Food
- History
- Education
- All Topics

Quizzes › Science › Technology › Microsoft › Microsoft Office › Microsoft Access

MS Access For Actuaries Quiz

4 Questions | By Actuwaiter | Updated: Mar 21, 2022 | Attempts: 131

Share

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Question 1 / 4

0 %

0/100

Score 0/100

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",

"

",

,

,"

Submit

About This Quiz

MS Access For Actuaries Quiz - Quiz

.

What's your name?

Tell us your name to personalize your report, certificate & get on the 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%

Submit

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.

Submit

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

Submit

View My Results

Quiz Review Timeline (Updated): Mar 21, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2022

Quiz Edited by
ProProfs Editorial Team
Mar 02, 2013

Quiz Created by
Actuwaiter

Related Quizzes

Microsoft Access Quiz: MCQ Test! Microsoft Access Quiz: MCQ Test!

MS Access 101 Quiz MS Access 101 Quiz

Microsoft Access Database Application Quiz Questions Microsoft Access Database Application Quiz Questions

Microsoft Access 2007 Basics Questions! Trivia Facts Quiz Microsoft Access 2007 Basics Questions! Trivia Facts Quiz

Intro To MS Access Intro To MS Access

MS Access - Tables And ForMS MS Access - Tables And ForMS

Saved

Thank you for your feedback!

Would you like to edit this question to improve it?

Name:

Email:

Oops! Give us more information:

Incorrect Question

Incorrect Answer

Typos

I have a feedback

Please provide name and email to proceed. Please provide correct email to proceed. Please provide feedback. Please select the option.

Cancel

All (4)
Unanswered ()
Answered ()

Here is an excerpt of a text file that you would like to bring into MS...

For Task 4, for 2011 sales, what percentage in terms of counts comes...

For Task 6, you just want the column headers from the 2012 Claims...

For Task 1, you need to merge in the Warranty Sales data with the...

Alert!

Advertisement