Deck 4: Access: Sharing Integrating and Analyzing Data

Question 1

All the PivotTable areas can have multiple fields with associated field items.

Answer 1

True

Question 2

You link a file as a new table when you intend to use Access to maintain the data and no longer need an updated version of the data with the source program.

Answer 2

False

Question 3

If you use a tab control the control appears with tabs along the bottom with one tab for each page.

Answer 3

False

Question 4

You embed the data when the source program will continue to maintain the data in the file and you need to use an updated version of the file at all times in the destination program.

Question 5

Once an object is linked it has no relation to the program in which it was created.

Question 6

The row area of a PivotTable consists of a detail field and detail values.

Question 7

If Excel has the worksheet open at the same time that Access is displaying a linked spreadsheet file's data you must close the table in Access before closing the worksheet in Excel; otherwise Access will display error values in the linked file.

Question 8

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.

Question 9

Any changes you make to an embedded object are reflected only in the form report or field in which it is embedded.

Question 10

If you do not see Subform in New Window as one of the options on the shortcut menu that results when you right-click the top edge of the subform control you did not click the top edge of the subform control correctly.

Question 11

Access has the capability to create complex charts and drawings for use on your forms and reports.

Question 12

Access cannot import data from an XML file directly into a database table; it must first be converted into a tab-delimited text file.

Question 13

You import or link an object when you want a copy of the object in your form or report and you intend to edit the object using the source program in the future.

Question 14

Access has built-in tools that convert objects to HTML documents for viewing on the Web.

Question 15

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 HTML Document.

Question 16

If an XML import will occur on a set schedule you can create a reminder task in Microsoft Outlook.

Question 17

When importing the data you can maintain the data using the destination program.

Question 18

With linking you store data from the file in the destination program.

Question 19

You should always select the "Export data with formatting and layout" option because not selecting it results in an HTML document that is poorly formatted.

Question 20

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

Question 21

Any changes made to an object using the source program are not reflected in linked objects nor do they retain a relation to the source program.

Question 22

The World Wide Web is commonly called the ____.

A)Usenet
B)Internet
C)Web
D)HTML

Question 23

To open the Get External Data - Excel Spreadsheet dialog box click the External Data tab on the Ribbon and then in the Import group on the External Data tab click the Excel button.

Question 24

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.

Question 25

When embedding data you can maintain the data using the destination program and the source program will always use the updated version of the file.

Question 26

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 .

Question 27

The ____ is a vast collection of digital documents available over the Internet.

A)Web
B)HTML
C)HTTP
D)URL

Question 28

Each digital document on the Web is called a Web ____.

A)site
B)server
C)servlet
D)page

Question 29

If you start the source program outside Access and make any changes to the original object these changes are reflected in an embedded object.

Question 30

The PivotTable uses the Office PivotTable Component one of the Office Web Components.

Question 31

Unlike HTML XML provides screen formatting information.

Question 32

HTML documents are saved with the .htm or .html file extension.

Question 33

An embedded object can be edited using the features of the destination program.

Question 34

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

A)Web
B)WWW
C)World Wide Web
D)Internet

Question 35

You can create a Web page by typing all the necessary HTML code into an HTML document and saving it with the appropriate file extension.

Question 36

You embed an object when you want your edits to an object in the destination program to affect the object used by other programs.

Question 37

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

Question 38

The Table Analyzer looks for concatenated data in a table.

Question 39

Individuals and companies store their Web pages on special computers called Web ____.

A)networks
B)tags
C)servers
D)browsers

Question 40

Navigation buttons do not appear in Form view.

Question 41

You can import from all of the following EXCEPT ____.

A)SQL Server
B)PDF
C)dBASE
D)Lotus 1-2-3

Question 42

From an XML file you can do all of the following EXCEPT ____.

A)append the data in the XML file to a recently deleted table
B)import only the table structure to a new table
C)import the table structure and data to a new table
D)append the data in the XML file to an existing table

Question 43

Tags for ____ connect one Web page to another.

A)dynamics
B)hyperlinks
C)relations
D)URLs

Question 44

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

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 45

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

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

Question 46

____ is a format that renders reports and other objects viewable on any computer using the free Adobe Reader program.

A)PDA
B)SNP
C)dBASE
D)PDF

Question 47

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

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

Question 48

Most Web pages are created using a programming language called ____.

A)Java
B)Perl
C)JavaScript
D)HTML

Question 49

After you start the Web browser you enter the Web page's ____.

A)HTML
B)protocol
C)URL
D)HTTP

Question 50

All of the following are Access import options EXCEPT ____.

A)SharePoint list
B)Snapshot file
C)Outlook folder
D)HTML document

Question 51

Each Web page contains ____ that the Web browser interprets to position and format the text in a Web page.

A)links
B)hyperlinks
C)tags
D)algorithms

Question 52

HTML stands for ____.

A)Hypertext Markup Language
B)Hit-based Manipulation Linkage
C)HyperText Management Lingo
D)none of the above

Question 53

The Web browser uses a(n)____ to find and retrieve a Web page and then displays it on your computer screen.

A)HTML
B)HTTP
C)XML
D)URL

Question 54

The Web browser uses a Web page's ____ to find and retrieve the Web page and then displays it on your computer screen.

A)HTML
B)protocol
C)path
D)URL

Question 55

URL stands for ____.

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

Question 56

A(n)____ Web page shows the state of the database object at the time the page was created.

A)absolute
B)static
C)dynamic
D)both A and B

Question 57

Each Web page is assigned an Internet address called a(n)____.

A)HTML
B)URL
C)HTTP
D)FTP

Question 58

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

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

Question 59

A ____ is a text file in which commas separate values and each line is a record containing the same number of values in the same positions.

A)CSV
B)TSV
C)CVS
D)CPP

Question 60

Microsoft Internet Explorer is an example of a Web ____.

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

Question 61

A ____ chart shows the relationship or proportions of parts to the whole.

A)pie
B)bar
C)line
D)point

Question 62

For objects in forms or reports you ____ an object when you want a copy of the object in your form or report and you do not intend to make any changes to the object.

A)embed
B)link
C)import
D)append

Question 63

The record source for a primary main form must have a ____ relationship to the record source for a related subform or chart.

A)many-to-one
B)one-to-many
C)one-to-one
D)many-to-many

Question 64

A snapshot file has a(n)____ extension.

A)PSN
B)SNA
C)SNP
D)PIC

Question 65

You can export a table's structure including information about its primary key and indexes in a(n)____ file.

A)UTF-8
B)XSD
C)UTF-16
D)WML

Question 66

When you embed an object in a form report or field you preserve its connection to the ____ program.

A)origin
B)source
C)destination
D)embedded

Question 67

All of the following are ODBC databases EXCEPT ____.

A)XPS
B)SQL Server
C)dBASE
D)Paradox

Question 68

Any changes you make to an original file using the source program are reflected in the ____ file version in the destination program.

A)imported
B)appended
C)embedded
D)linked

Question 69

You ____ an object when you want your edits to the object in the destination program to affect the object used by other programs.

A)link
B)embed
C)append
D)import

Question 70

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

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

Question 71

The Export options are available on the ____ tab.

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

Question 72

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

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

Question 73

When you ____ an object to a form report or field you include a connection in the destination program to the original file maintained by the source program.

A)embed
B)append
C)link
D)import

Question 74

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

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

Question 75

A(n)____ file provides formatting instructions so that a browser or another program can display the data in the XML file in a readable way.

A)XMX
B)XSP
C)XSD
D)XSL

Question 76

When you ____ an object you include the contents of a file in a new table or append it to an existing table or you include the contents of a file in a form report or field.

A)import
B)append
C)embed
D)link

Question 77

All of the following are Access export options EXCEPT ____.

A)a PowerPoint chart
B)a text file
C)a Lotus 1-2-3 file
D)an Excel workbook

Question 78

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

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

Question 79

The Presentation tab options in the Export XML dialog box let you export a separate ____ file containing the format specifications for a given table's data.

A)XML
B)XSP
C)XSD
D)XSL

Question 80

You can add ____ to your forms and reports.

A)charts
B)drawings
C)rectangles
D)all of the above