Chapter Extension 7 (MIS)

TRUE

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

D) External Data

Delimited text files can be imported to Microsoft Access by selecting the ________ tab. A) Home B) Create C) Database Tools D) External Data

FALSE

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

TRUE

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. True or False?

TRUE

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

TRUE

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

TRUE

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. True or False?

C) Named range

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

FALSE

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. True or False?

FALSE

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

False

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

B) To find the number of days each student is absent, Group By should be selected for StudentID, and Count for DateAbsent.

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.

TRUE

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. True or False?

B. Microsoft Access

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

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.

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.

Microsoft Excel includes comprehensive tools for graphing data. It can be used to construct column and bar charts, pie charts, line and scatter plots, and others graphs. Graphs can be created by clicking the Insert tab in the ribbon, selecting the Charts section of that ribbon, and selecting the required graph from the dropdowns. For example, to create a pie chart, we must highlight the cells that have the required data, click the Insert tab in the ribbon, and in the Charts section of that ribbon select the Pie icon. Excel can create several different versions of pie charts. Excel provides many different tools to customize a graph. To access them, click the graph you want to change. Excel will show a special tab called Chart Tools at the top of the window. Click Chart Tools to make them available.

Explain the procedure for creating graphs in Microsoft Excel.

Microsoft Excel is good at processing interrelated formulas. Due to this feature, business users often select Excel for processing financial statements, creating budgets, and performing financial analyses. Excel can be used to create sophisticated and stylish graphics with very little work from the user. Microsoft Access is a database management system (DBMS), and the primary purpose of a DBMS is to keep track of things. Access is superior for tracking orders, inventory, equipment, people, and so forth. Users can readily create data entry forms, queries, and sophisticated and professional reports with Access. So, it is often necessary to use Excel to process data stored in Access and vice versa. For example, Excel can be used to create graphs of Access data and Access can be used to summarize Excel data and produce sophisticated reports.

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

Open the relevant database, click the Create tab, click Query Design, and then select a table for the query. After adding a table, click Close. Now add the fields to the query contents table by double-clicking on them in the table diagram. Click the Totals button in the Show/Hide section of the Design tab. In response, Microsoft Access adds a row labeled Total to the query contents table. To group the rows by a particular field, select the keyword Group By in the Total row under that field in the query contents table. To find the total of a field, select the keyword Sum under the appropriate column. Run the query by clicking the large exclamation point in the Results section of the Design ribbon.

How are group totals created in Microsoft Access?

Microsoft Access data, including queries, can be imported to Microsoft Excel to display the results with the help of Excel's graphing capabilities. To import data into Excel, open Excel, click the Data tab in the ribbon and then, in the Get External Data section, select From Access option. Excel will query Access to determine the tables and queries that exist in the chosen database. Next, Excel will ask the user on how the data should be displayed. Choose Table and Existing worksheet, and enter an absolute address for the top, left-hand corner of the table. Use the displayed data to create graphs in Excel.

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

B. Show/Hide

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

FALSE

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

False

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

TRUE

Microsoft Access is a database management system. True or False?

TRUE

Microsoft Access queries can be imported into Microsoft Excel. True or False?

FALSE

Microsoft Excel cannot be used to perform calculations on data imported from Microsoft Access. True or False?

TRUE

Microsoft Excel includes comprehensive tools for graphing data. True or False?

False

Microsoft Excel is superior to Microsoft Access for tracking orders, inventory, equipment, and people. True or False?

FALSE

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

FALSE

The Average function and Group By cannot be used in the same query. True or False?

FALSE

The Totals button is present in the Results section of the Design tab. True or False?

B. Import/Export

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

TRUE

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

FALSE

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

TRUE

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. True or False?

FALSE

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

Delimited text files are files that have field values separated by common symbols known as delimiters. The files that use commas as delimiters are known as comma-delimited files. Sometimes, however, the data itself contains commas, and so commas cannot be used to separate field data. In that case, some other character is used to delimit the fields. The tab character is frequently used, in such cases; the export file is called a tab-delimited file. Delimited text files are easy to import into either Microsoft Excel or Microsoft Access.

What are delimited text files?

Import/export is the process of transferring data from one computer system to another. In almost all cases, including Microsoft Excel and Microsoft Access, import/export does not maintain an active connection to the source of the data. If users subsequently change the Access data, the imported data in Excel will be out of date until the users reimport it. As the imported data can become outdated, users should develop procedures (either manual or automated) to ensure that data are refreshed on a timely basis.

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?

B. Column Chart

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

C) Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics.

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.

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.

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.

A) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name

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

D) Insert → Charts → Column

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

D. Insert → Charts → Pie

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

A) Home → Number → Currency

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

D) Data tab → Get External Data → From Text

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

D. Field values in a tab-delimited file are separated by tabs

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.

A. In Microsoft Access, a query can be based on the results of other queries that have been saved.

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.

C. Insert

Which of the following tabs in Microsoft Excel contains the option to create a column chart? A) Data B) Home C) Insert D) Tools

TRUE

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

A. Microsoft Access

________ is well-suited for tracking orders, inventory, equipment, people, and so forth. A) Microsoft Access B) Microsoft Word C) Microsoft PowerPoint D) Microsoft Publisher