Kroenke Emis3 Tif Ce09

2246 Words9 Pages
Experiencing MIS, 3e (Kroenke)
Chapter Extension 9: Using Excel and Access Together

Multiple Choice

1) Which of the following is true for Access?
A) It is a database management system.
B) It is used to create charts and graphs from data.
C) It cannot be used to produce reports.
D) It is a management information system.
Answer: A
Page Ref: 418
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1

2) A user can readily create data entry forms, queries, and sophisticated and professional reports with the help of ________.
A) Microsoft Publisher
B) Microsoft Access
C) Microsoft Word
D) Microsoft Excel
Answer: B
Page Ref: 418
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 1

3) Which of the following
…show more content…
A) Results section of the Design tab
B) Show/Hide section of the Design tab
C) Query section of the Create tab
D) Query Setup section of the Design tab
Answer: B
Page Ref: 427
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 4

14) Which of the following tabs in Microsoft Excel contains the option to import data from Microsoft Access?
A) Data
B) Insert
C) External Data
D) Home
Answer: A
Page Ref: 431
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 5

15) Data can be transferred from Excel to Access by creating a(n) ________, which is a subset of the cells in a worksheet that has a unique name.
A) specified label
B) individual data
C) named range
D) unique path
Answer: C
Page Ref: 434
Difficulty: Easy
AACSB: Use of IT
Study Question: Study Question 6

16) Which of the following procedures must be used to create a named range for a data in Access?
A) highlight the required data→ click the Formulas tab → click Define Name in the Defined Names section→ enter a suitable name
B) highlight the required data→ click the Home tab → click Insert Name in the Cells section→enter a suitable name
C) highlight the required data→ click the Data tab → click Connections in the Connections section→ enter a suitable name
D) highlight the required data→ click the Design tab→click Property Sheet in the Show/Hide section→enter

    More about Kroenke Emis3 Tif Ce09

      Open Document