Question 1

What differentiates a hyperlink from text?

Accepted Answer

A)  Blue underline 
B)  Green underline 
C)  Red underline 
D)  Black underline 
A)  Blue underline 
B)  Green underline 
C)  Red underline 
D)  Black underline

Question 2

If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.

Accepted Answer

A) True 
 B)False

Question 3

XPS is a file format that displays a printed page onscreen identically on any computer platform.

Accepted Answer

A) True 
 B)False

Question 4

What is the disadvantage of linking an Excel spreadsheet from Access?

Accepted Answer

The file c

Question 5

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

Accepted Answer

A) True 
 B)False

Question 6

Saving the export steps is the last step in the export process.

Accepted Answer

A) True 
 B)False

Question 7

Linking and importing produce the same result in Access.

Accepted Answer

A) True 
 B)False

Question 8

PDF is a file format created by Microsoft.

Accepted Answer

A) True 
 B)False

Question 9

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

Accepted Answer

The answer of The Access data type that enables you...

Question 10

JPEG and other photo formats increase the database size byte for byte.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ appears next to a linked table name in the Navigation Pane.

Accepted Answer

A)  arrow 
B)  star 
C)  pound sign 
D)  ampersand 
A)  arrow 
B)  star 
C)  pound sign 
D)  ampersand

Question 12

________ allows you connect to a table without having to import the table data into your database.

Accepted Answer

A)  Linking 
B)  Copying 
C)  Pasting 
D)  Moving 
A)  Linking 
B)  Copying 
C)  Pasting 
D)  Moving

Question 13

Why would you want to export an Access report to a PDF?

Accepted Answer

The documents do not require p

Question 14

How do you insert blank lines above a table after exporting it from Access into Word?

Accepted Answer

A)  Click immediately before the first value in the first cell of the table and press Enter to add an additional line. 
B)  You will have to cut the table and add a blank line, then paste the table back at the new cursor position. 
C)  You cannot add additional lines above the table. 
D)  Additional lines will appear below the table by default. 
A)  Click immediately before the first value in the first cell of the table and press Enter to add an additional line. 
B)  You will have to cut the table and add a blank line, then paste the table back at the new cursor position. 
C)  You cannot add additional lines above the table. 
D)  Additional lines will appear below the table by default.

Question 15

A(n)________ is the location of a Web site or Web page on the Internet.

Accepted Answer

URL,unifor

Question 16

When exporting a table to Excel,all records in the table are exported,even if they are not needed.

Accepted Answer

A) True 
 B)False

Question 17

Why would you export the structure of a table to a different database and not the data?

Accepted Answer

Exporting the structure enable

Question 18

The objects you select to export from Access to Word should have which of the following types of layout?

Accepted Answer

A)  Tabular 
B)  Stepped 
C)  Block 
D)  Outline 
A)  Tabular 
B)  Stepped 
C)  Block 
D)  Outline

Question 19

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

Accepted Answer

A)  The size of the database remains the same. 
B)  The linked table adds space to the database size. 
C)  The linked table adds space byte for byte. 
D)  The size of the database decreases in size. 
A)  The size of the database remains the same. 
B)  The linked table adds space to the database size. 
C)  The linked table adds space byte for byte. 
D)  The size of the database decreases in size.

Question 20

________ allocate a certain number of characters for each field.

Accepted Answer

A)  Fixed-length text files 
B)  CSV text files 
C)  Linked files 
D)  Excel tables 
A)  Fixed-length text files 
B)  CSV text files 
C)  Linked files 
D)  Excel tables

Exam 20: Get Connected: Exchanging Data Between Access and Other Applications

What differentiates a hyperlink from text?

If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.

XPS is a file format that displays a printed page onscreen identically on any computer platform.

What is the disadvantage of linking an Excel spreadsheet from Access?

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

Saving the export steps is the last step in the export process.

Linking and importing produce the same result in Access.

PDF is a file format created by Microsoft.

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

JPEG and other photo formats increase the database size byte for byte.

A(n)________ appears next to a linked table name in the Navigation Pane.

________ allows you connect to a table without having to import the table data into your database.

Why would you want to export an Access report to a PDF?

How do you insert blank lines above a table after exporting it from Access into Word?

A(n)________ is the location of a Web site or Web page on the Internet.

When exporting a table to Excel,all records in the table are exported,even if they are not needed.

Why would you export the structure of a table to a different database and not the data?

The objects you select to export from Access to Word should have which of the following types of layout?

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

________ allocate a certain number of characters for each field.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters