Deck 19: Using Excel and Access Together

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

Which of the following statements is true of delimited files?

A)A comma-delimited file has data that contains commas.
B)Field values in a tab-delimited file are separated by tabs.
C)Delimited files cannot be imported by Excel.
D)Access can import only tab-delimited files.

Answer 3

B

Question 4

________ is well-suited for tracking orders,inventory,equipment,people,and so forth.

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

Question 5

Explain the significance of using Access and Excel together.

Question 6

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

A)Excel can be used to create better data entry forms,queries,and professional reports.
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 is superior for tracking orders,inventory,and equipment.

Question 7

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

Question 8

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

Question 9

Which of the following shows the correct sequence of steps for importing Access data that has been stored in a text file into Excel?

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

Question 10

To exchange data between Excel and Access,the data must be exported into a text file and then imported.

Question 11

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

A)auto transfer
B)buffer overrun
C)reallocation
D)import/export

Question 12

Microsoft Access is a database management system.

Question 13

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

Question 14

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

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

Question 15

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

Question 16

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

Question 17

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

A)HOME
B)EXTERNAL DATA
C)CREATE
D)DATABASE TOOLS

Question 18

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

Question 19

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 20

A user can readily create data entry forms,queries,and sophisticated and professional reports with the help of ________.

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

Question 21

If a column heading and the corresponding numerical data are highlighted and used to create a pie chart,the heading will appear as the chart title.

Question 22

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

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

Question 23

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

Question 24

A school stores attendance records of its students on an Access database.The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns.Each time a student is absent,an entry is made into the database.Which of the following statements is true?

A)To find the number of days each student is absent,Group By should be selected for StudentID and Count for DateAbsent.
B)To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID.
C)To see the number of students absent in a particular grade on a given day,Group By should be selected for both DateAbsent and StudentID.
D)To see which students were absent on a particular day,Group By should be selected for StudentName.

Question 25

An organisation stores the details of its employees using Access.The Employee table has EmployeeName,EmployeeID,Department,and Salary columns.Which of the following statements is true?

A)To count the number of employees having the same salary,the Group By option should be selected under EmployeeID and Count under Salary.
B)To view the average salary drawn by the employees of each department,the Group By option should be selected in the Total row under Salary.
C)To count the number of employees in each department,the Group By option should be selected under EmployeeID and the Count option under Department.
D)To find the sum of salaries drawn by the employees of each department,the Group By option should be selected under Department and Sum under Salary.

Question 26

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 27

The Average function and Group By cannot be used in the same query.

Question 28

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

Question 29

Explain the procedure for creating graphs in Microsoft Excel.

Question 30

Which of the following statements is true of queries?

A)When the results of a query are imported by Excel,they cannot be operated on.
B)To inform Access that the fields of two tables are the same,select the Group By option for both fields.
C)In Access,a query can be based on the results of other queries that have been saved.
D)The Group By option becomes available when Append is clicked under the Design tab.

Question 31

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

A)Query Setup
B)Query Type
C)Import/Export
D)Show/Hide

Question 32

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

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

Question 33

How are group totals created in Access?

Question 34

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

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

Question 35

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

Question 36

What are delimited text files?

Question 37

Microsoft Excel includes comprehensive tools for graphing data.

Question 38

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

Question 39

Which of the following Excel diagrams is the best to compare performance data over many years of different employees?

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

Question 40

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

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

Question 41

A data table is a subset of the cells in a worksheet that has a unique name and is used to transfer data from Excel to Access.

Question 42

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 43

In Excel,a single space character is used to separate the words in a name range.

Question 44

Access queries can be imported into Microsoft Excel.

Question 45

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 46

Which of the following procedures must be used to create a named range for data in Excel?

A)highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name
B)highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name
C)highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name
D)highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name

Question 47

How can Excel be used to graph Access data?

Question 48

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

A)specified label
B)consolidation table
C)named range
D)calculated column

Question 49

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

Question 50

Sum and average functions cannot be used in Excel on imported data that have been created using group totals in Access.