Deck 21: Using Excel and Access Together

Question 1

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 a suitable name

Answer 1

A

Question 2

To use Excel to process data stored in Access,you have to rekey all of the Access data into Excel.

Answer 2

False

Question 3

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 3

C

Question 4

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

Question 5

In Microsoft Access,the Totals button is present in the ________.

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

Question 6

Which of the following shows the correct steps for creating a pie chart in Microsoft Excel?

A) Add-Ins → Illustrations → Pie
B) Insert → Illustrations → Pie
C) Diagrams → Illustrations → Pie
D) Insert → Charts → Pie

Question 7

Import/export is the process of transferring data from one computer system to another.

Question 8

Microsoft Excel is a database management system.

Question 9

Which of the following Excel diagrams is the best to compare various growth alternatives of different employees?

A) pie charts
B) column charts
C) scatter diagrams
D) Venn diagrams

Question 10

Access is superior to Excel for tracking orders,inventory,equipment,and people.

Question 11

Which of the following tabs in Microsoft Excel contains the option to create a column chart?

A) Data
B) Home
C) Insert
D) Tools

Question 12

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.

Question 13

Which of the following shows the correct steps for importing data into Excel from Access?

A) Insert tab → External Data → From Access
B) Edit tab → Get External Data → From Access
C) File tab → External Data → From Text
D) Data tab → Get External Data → From Text

Question 14

Which of the following is true for import/export of data from Access to Excel?

A) Data can only be transferred by exporting the data into a text file and then importing that text data.
B) If data in Access is changed, the data imported to Excel changes automatically.
C) The import/export process maintains an active connection to the source of the data.
D) If data in Access is changed, the data must be re-imported into Excel to be up-to-date.

Question 15

Delimited text files can be imported to Microsoft Access by selecting the ________ tab.

A) Home
B) Create
C) Database Tools
D) External Data

Question 16

________ is a superior software for tracking orders,inventory,equipment,people,and so forth.

A) Microsoft Access
B) Adobe Illustrator
C) Microsoft PowerPoint
D) Microsoft Publisher

Question 17

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

Question 18

Which of the following is an advantage of Microsoft Excel over Microsoft Access?

A) Excel is superior for tracking orders, inventory, and equipments.
B) Excel is superior for tracking people such as employees and customers.
C) Excel can be used to create better graphs and visual demonstrations.
D) Excel can be used to create better data entry forms and professional reports.

Question 19

The process of transferring data from one computer system to another is referred to as ________.

A) auto transfer
B) export/import
C) data shift
D) reallocation

Question 20

When the data in a text file contains commas,commas cannot be used to separate field data.In that case,some other character such as a tab is used to delimit the fields.In this case,the commas and tab characters are known as ________.

A) alienators
B) identifiers
C) attributes
D) delimiters

Question 21

In Excel and Access,import/export does not maintain an active connection to the source of the data.

Question 22

Explain the significance of using Access and Excel together.

Question 23

The only way to exchange data between Excel and Access is to export the data into a text file and then import that text data.

Question 24

What are delimited text files?

Question 25

Microsoft Access can be used to create graphs and illustrations of data patterns.

Question 26

Importing data from Access to Excel is easily achieved by clicking on the Data tab and directing Excel to get the external data from Access.

Question 27

A pie chart can be created by selecting the Charts option from the Data tab ribbon in Microsoft Excel.

Question 28

Access queries can be imported to Microsoft Excel.

Question 29

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

Question 30

Explain the procedure for creating graphs in Microsoft Excel.

Question 31

When using Excel,spaces can be used to connect the words in range names.

Question 32

In delimited text files,the field values are always separated by commas.

Question 33

Microsoft Excel includes comprehensive tools for graphing data.

Question 34

Access queries cannot be used to calculate averages of table values.

Question 35

In Excel,the underscore character is used to connect the words in a name range.

Question 36

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

Question 37

Excel cannot be used to perform calculations on data imported from Access.

Question 38

Delimited text files cannot be imported into either Excel or Access.

Question 39

A pie chart cannot be used to represent various growth alternatives of different entities.

Question 40

How can you use Excel to graph Access data?