Deck 18: Using Excel and Access Together

Question 1

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

Answer 1

False

Question 2

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

Answer 2

B

Question 3

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 3

A

Question 4

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 5

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

A)Excel is superior for tracking orders,inventory,and equipment.
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 6

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

Question 7

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

A)Microsoft Access
B)Microsoft Excel
C)Microsoft PowerPoint
D)Microsoft Publisher

Question 8

Which of the following shows the correct steps for formatting the currency values in Microsoft Excel?

A)Home → Number → Currency
B)Data → Number → Currency
C)Home → Editing → Currency
D)Data → Editing → Currency

Question 9

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

Question 10

Which of the following is true of 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)Delimited text files cannot be imported into both Excel and Access.
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 11

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

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

Question 12

Microsoft Access is a database management system.

Question 13

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

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

Question 14

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

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

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

Question 17

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

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

Question 18

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

Question 19

To use Excel to process data stored in Access,it is recommended to rekey all of the Access data into Excel.

Question 20

In Microsoft Access,the Totals button is present in the ________ section of the Design tab.

A)Results
B)Show/Hide
C)Query Type
D)Query Setup

Question 21

Data can be transferred from Excel to Access by creating a specified label,which is a subset of the cells in a worksheet that has a unique name.

Question 22

The Totals button is present in the Results section of the Design tab.

Question 23

A pie chart can be used to compare results for two years or more.

Question 24

Explain the significance of using Access and Excel together.

Question 25

Commas cannot be used to separate field data if the data itself contains commas.

Question 26

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

Question 27

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 28

Access queries can be imported into Microsoft Excel.

Question 29

To create a column chart,the data is highlighted and the Column option in the Charts section of the Insert tab is selected.

Question 30

What are delimited text files?

Question 31

To import data into Excel,open Excel,click the Data tab,and in the Get External Data section of that ribbon click From Text.

Question 32

Explain the procedure for creating graphs in Microsoft Excel.

Question 33

Microsoft Excel includes comprehensive tools for graphing data.

Question 34

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 35

If users subsequently change the Access data,the imported data in Excel will be out-of-date until it is re-imported.

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

Data can be exchanged between Excel and Access by exporting the data into a text file and then importing that text data.

Question 41

How can you use Excel to graph Access data?