MS Access For Actuaries Quiz
5 Questions
| Total Attempts: 118
Questions and Answers
- 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",
- A.
"
- B.
",
- C.
,
- D.
,"
- 2.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.
- A.
Left Join on Item
- B.
Right on Brand and Item
- C.
Inner Join on Item
- D.
Left Join on Brand and Item
- 3.For Task 3 Question 6, If you had a warranty claim, what was the average claim amount? Describe the correct sequence in your query design.
- 4.For Task 4, for 2011 sales, what percentage in terms of counts comes of MP3 players?
- A.
3.98%
- B.
5.98%
- C.
19.92%
- D.
13.94%
- 5.For Task 6, you just want the column headers from the 2012 Claims Data. What is the most efficient way to do this?
- A.
Make a copy of the 2012 claims table, rename it 2013, and delete each of the rows
- B.
Create a Make Table query off the 2012 claims data named 2013 Claims data. Then delete the irrelevant rows.
- C.
Make a copy of the 2012 Claims data then bring in the Structure Only.
Microsoft Access is a tool that helps one store and analyzes large amounts of information. This tool forms interface that allows users to enter information in a graphical form and have that information transparently passed to the...
Questions: 10 | Attempts: 18441 | Last updated: Nov 16, 2020
-
Sample QuestionA _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
.
Questions: 10 | Attempts: 16799 | Last updated: Dec 4, 2020
-
Sample QuestionAn organized collection of logically related data is known as?
Getting some basic computer knowledge is something that most people are required to have in any business field. There are different computer applications used daily. How good are you when it comes to MS Access? Take up the quiz...
Questions: 50 | Attempts: 14540 | Last updated: Dec 22, 2020
-
Sample QuestionWhich object is used to create a form?
Back to top