Deck 19: Using Excel and Access Together

Question 1

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

Answer 1

False

Question 2

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

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

Answer 2

A

Question 3

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

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

Answer 3

B

Question 4

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

Question 5

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

A)Microsoft Excel is superior for tracking orders,inventory,and equipment.
B)Microsoft Excel is superior for tracking people,such as employees and customers.
C)Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics.
D)Microsoft Excel is better at creating data entry forms,queries,and professional reports.

Question 6

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

Question 7

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

Question 8

While saving data in text files,commas cannot be used to separate field data if the data itself contains commas.

Question 9

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 10

Which of the following is true about the import/export of data from Microsoft Access to Microsoft 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 Microsoft Excel and Microsoft Access.
C)The import/export process in both Microsoft Access to Microsoft Excel maintains an active connection to the source of the data.
D)Data must be re-imported to Microsoft Excel in order to remain up-to-date if the source data in Microsoft Access is modified.

Question 11

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

Question 12

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

Question 13

Microsoft Access is a database management system.

Question 14

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

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 15

Which of the following statements is true of delimited files?

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

Question 16

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

Question 17

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

Question 18

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

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

Question 19

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

Question 20

Explain the significance of using Microsoft Access and Microsoft Excel together.

Question 21

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

Question 22

A school stores attendance records of its students in a Microsoft 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 average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID.
B)To find the number of days each student is absent,Group By should be selected for StudentID,and Count for DateAbsent.
C)To see which students were absent on a particular day,Group By should be selected for StudentName.
D)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.

Question 23

How can Microsoft Excel be used to graph Microsoft Access data?

Question 24

Which of the following shows the correct sequence of 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 25

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 26

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

Question 27

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

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

Question 28

If a user clicks on a graph in Microsoft Excel,it will show a special tab called Chart Tools that can be used to customize the graph.

Question 29

How are group totals created in Microsoft Access?

Question 30

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

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

Question 31

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

A)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.
B)To count the number of employees in each department,the Group By option should be selected under EmployeeID,and the Count option under Department.
C)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.
D)To count the number of employees having the same salary,the Group By option should be selected under EmployeeID,and Count under Salary.

Question 32

Which of the following statements is true of queries?

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

Question 33

What are delimited text files?

Question 34

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

Question 35

Microsoft Excel includes comprehensive tools for graphing data.

Question 36

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

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

Question 37

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

Question 38

Explain the procedure for creating graphs in Microsoft Excel.

Question 39

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

Question 40

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

Question 41

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

Question 42

Microsoft Access queries can be imported into Microsoft Excel.

Question 43

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

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

Question 44

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

Question 45

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

Question 46

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

Question 47

A ________,which is a subset of the cells in a worksheet that has a unique name,enables data to be transferred from Microsoft Excel to Microsoft Access.

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

Question 48

In Microsoft Excel,a single space is used to separate the words in range names.

Question 49

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

Question 50

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

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