Question 1

What are delimited text files?

Accepted Answer

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.

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

Microsoft Excel includes comprehensive t

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

How are group totals created in Microsoft Access?

Accepted Answer

Open the relevant database,click the Cre

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following statements is true of queries?

Accepted Answer

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

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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?

Accepted Answer

Import/export is the process of transfer

Question 18

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 19

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?

Accepted Answer

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

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Exam 19: Using Excel and Access Together

What are delimited text files?

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

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

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

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

Explain the procedure for creating graphs in Microsoft Excel.

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

How are group totals created in Microsoft Access?

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

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

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

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

Which of the following statements is true of queries?

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

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

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

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?

Microsoft Access is a database management system.

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?

Microsoft Excel includes comprehensive tools for graphing data.

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters