Question 1

When you use the Chart Wizard in Access the chart is created by Microsoft ____.

Accepted Answer

A) Access 
B) Excel 
C) Graph 
D) Chart 
A) Access 
B) Excel 
C) Graph 
D) Chart

Question 2

When the Table Analyzer encounters concatenated data it removes those fields from the table and then places them in new tables.

Accepted Answer

A) True 
 B)False

Question 3

The intranet is a worldwide network consisting of millions of interconnected computers.

Accepted Answer

A) True 
 B)False

Question 4

When you integrate information between programs the program in which you place the information created by the source program is called the ____________________ program.

Accepted Answer

The answer of When you integrate information between programs the...

Question 5

The Navigation ____ property lets you change the navigation label from one value to another.

Accepted Answer

A) Key 
B) Label 
C) Caption 
D) Icon 
A) Key 
B) Label 
C) Caption 
D) Icon

Question 6

The item marked ____________________ in the accompanying figure is the detail field.

Accepted Answer

The answer of   The item marked ____________________ in...

Question 7

A(n)____________________ is an interactive table that lets you analyze data dynamically.

Accepted Answer

The answer of A(n)____________________ is an interactive table that lets...

Question 8

To view a Web page you start a special program called a Web ____.

Accepted Answer

A) manager 
B) browser 
C) resource 
D) server 
A) manager 
B) browser 
C) resource 
D) server

Question 9

You can use a(n)____________________ to view and organize data from a database look for summary or detail information and dynamically change contents and organization.

Accepted Answer

The answer of You can use a(n)____________________ to view and...

Question 10

Match between columns
                        Premises: A file that contains HTML instructions for creating a Web page with both text and graphics together with special instructions that tell Access where to place the Access data on the Web page

Accepted Answer

The Answer of template and PivotTable and series field and is...

Question 11

You can start the Table Analyzer by clicking the ____ tab and then clicking the Analyze Table button in the Analyze group.

Accepted Answer

A) Table Analysis 
B) Table Tools 
C) Database Tools 
D) Sharing and Integrating Data 
A) Table Analysis 
B) Table Tools 
C) Database Tools 
D) Sharing and Integrating Data

Question 12

To export an Access query to an HTML document right-click the object in the Navigation Pane point to Export on the shortcut menu and then click Web Page .

Accepted Answer

A) True 
 B)False

Question 13

____ is an XML encoding choice that uses 8 bits to represent each character.

Accepted Answer

A) XSD-8 
B) XSL-8 
C) UTF-8 
D) all of the above 
A) XSD-8 
B) XSL-8 
C) UTF-8 
D) all of the above

Question 14

When you integrate information between programs the program containing the original information is called the ____________________ program.

Accepted Answer

The answer of When you integrate information between programs the...

Question 15

The item marked 5 in the accompanying figure is the ____ field item.

Accepted Answer

A) row 
B) filter 
C) column 
D) detail 
A) row 
B) filter 
C) column 
D) detail

Question 16

All of the following are options for importing CSV files EXCEPT ____.

Accepted Answer

A) Import the source data into a new table in the current database 
B) Append a copy of the records to the table 
C) Copy the CSV file to the existing table 
D) Link to the data source by creating a linked table 
A) Import the source data into a new table in the current database 
B) Append a copy of the records to the table 
C) Copy the CSV file to the existing table 
D) Link to the data source by creating a linked table

Question 17

The Export options are available on the ____ tab.

Accepted Answer

A) Tools 
B) External Data 
C) Exporting 
D) Import and Export 
A) Tools 
B) External Data 
C) Exporting 
D) Import and Export

Question 18

____ is a programming language similar in format to HTML that is more customizable and suited to the exchange of data between different programs.

Accepted Answer

A) XML 
B) WML 
C) DHTML 
D) Java 
A) XML 
B) WML 
C) DHTML 
D) Java

Question 19

You link an object when you do not want your edits to the object in the destination program to affect any other copies of the object used by other programs.

Accepted Answer

A) True 
 B)False

Question 20

URL stands for ____.

Accepted Answer

A) Unique Resource Link 
B) Uniform Resource Link 
C) Universal Related Link 
D) Uniform Resource Locator 
A) Unique Resource Link 
B) Uniform Resource Link 
C) Universal Related Link 
D) Uniform Resource Locator

When you use the Chart Wizard in Access the chart is created by Microsoft ____.

When the Table Analyzer encounters concatenated data it removes those fields from the table and then places them in new tables.

The intranet is a worldwide network consisting of millions of interconnected computers.

When you integrate information between programs the program in which you place the information created by the source program is called the ____________________ program.

The Navigation ____ property lets you change the navigation label from one value to another.

The item marked ____________________ in the accompanying figure is the detail field.

A(n)____________________ is an interactive table that lets you analyze data dynamically.

To view a Web page you start a special program called a Web ____.

You can use a(n)____________________ to view and organize data from a database look for summary or detail information and dynamically change contents and organization.

You can start the Table Analyzer by clicking the ____ tab and then clicking the Analyze Table button in the Analyze group.

To export an Access query to an HTML document right-click the object in the Navigation Pane point to Export on the shortcut menu and then click Web Page .

____ is an XML encoding choice that uses 8 bits to represent each character.

When you integrate information between programs the program containing the original information is called the ____________________ program.

The item marked 5 in the accompanying figure is the ____ field item.

All of the following are options for importing CSV files EXCEPT ____.

The Export options are available on the ____ tab.

____ is a programming language similar in format to HTML that is more customizable and suited to the exchange of data between different programs.

You link an object when you do not want your edits to the object in the destination program to affect any other copies of the object used by other programs.

URL stands for ____.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

Exam 4: Access: Sharing Integrating and Analyzing Data

When you use the Chart Wizard in Access the chart is created by Microsoft ____.

When the Table Analyzer encounters concatenated data it removes those fields from the table and then places them in new tables.

The intranet is a worldwide network consisting of millions of interconnected computers.

When you integrate information between programs the program in which you place the information created by the source program is called the ____________________ program.

The Navigation ____ property lets you change the navigation label from one value to another.

The item marked ____________________ in the accompanying figure is the detail field.

A(n)____________________ is an interactive table that lets you analyze data dynamically.

To view a Web page you start a special program called a Web ____.

You can use a(n)____________________ to view and organize data from a database look for summary or detail information and dynamically change contents and organization.

You can start the Table Analyzer by clicking the ____ tab and then clicking the Analyze Table button in the Analyze group.

To export an Access query to an HTML document right-click the object in the Navigation Pane point to Export on the shortcut menu and then click Web Page .

____ is an XML encoding choice that uses 8 bits to represent each character.

When you integrate information between programs the program containing the original information is called the ____________________ program.

The item marked 5 in the accompanying figure is the ____ field item.

All of the following are options for importing CSV files EXCEPT ____.

The Export options are available on the ____ tab.

____ is a programming language similar in format to HTML that is more customizable and suited to the exchange of data between different programs.

You link an object when you do not want your edits to the object in the destination program to affect any other copies of the object used by other programs.

URL stands for ____.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters