Question 1

Which of the following is not a valid data source for exporting to Excel?

Accepted Answer

A)  Query 
B)  Filtered Table 
C)  Table 
D)  Subform 
A)  Query 
B)  Filtered Table 
C)  Table 
D)  Subform

Question 2

The hyperlink data type that enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

Accepted Answer

A) True 
 B)False

Question 3

PDF stands for ________ Document Format.

Accepted Answer

The answer of PDF stands for ________ Document Format....

Question 4

You cannot change the ________ of a linked table in the destination database.

Accepted Answer

The answer of You cannot change the ________ of a...

Question 5

Just like in Word, when you see a hyperlink in datasheet view, you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

Accepted Answer

A) True 
 B)False

Question 6

________ allows you to connect to an external database without having to import the table into your current database.

Accepted Answer

The answer of ________ allows you to connect to an...

Question 7

ScreenTips are fixed in Access and cannot be changed.

Accepted Answer

A) True 
 B)False

Question 8

________ text files allocate a certain number of characters for each field.

Accepted Answer

Fixed-leng

Question 9

In a form or report, you can interact with attachments using an attachment ________.

Accepted Answer

The answer of In a form or report, you can...

Question 10

Match the following terms with their descriptions:
I. Attachment control
II. Attachment field
III. Fixed-length text file
IV. CSV text file
V. Hyperlink
A. Can take you to a website
B. Uses commas to indicate columns
C. Assigns a number of characters for each field
D. Files which can be launched from Access
E. Allows you to manage attachments in forms and reports

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 11

URL is the location of a website or webpage on the Internet.

Accepted Answer

A) True 
 B)False

Question 12

When you export data from Access to Excel, the records in Access become ________ in Excel.

Accepted Answer

The answer of When you export data from Access to...

Question 13

What is the first step in editing a hyperlink field?

Accepted Answer

A)  Click on the hyperlink and select Edit Hyperlink. 
B)  Double-click on the hyperlink and select Edit Hyperlink. 
C)  Right-click on the hyperlink and select Edit Hyperlink. 
D)  Delete the hyperlink and create it again. 
A)  Click on the hyperlink and select Edit Hyperlink. 
B)  Double-click on the hyperlink and select Edit Hyperlink. 
C)  Right-click on the hyperlink and select Edit Hyperlink. 
D)  Delete the hyperlink and create it again.

Question 14

The ________ data type enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

Accepted Answer

The answer of The ________ data type enables you to...

Question 15

What is the first step in exporting a table from one database to another database?

Accepted Answer

A)  Delete any unwanted fields in the source table. 
B)  Create the new database. 
C)  Temporarily delete any relationships that exist with the source table. 
D)  Make a copy of the table, then delete all the records in the source table. 
A)  Delete any unwanted fields in the source table. 
B)  Create the new database. 
C)  Temporarily delete any relationships that exist with the source table. 
D)  Make a copy of the table, then delete all the records in the source table.

Question 16

What query type can you create to assist in copying records from a linked table?

Accepted Answer

A)  Append 
B)  Update 
C)  Make table 
D)  Copy/Paste 
A)  Append 
B)  Update 
C)  Make table 
D)  Copy/Paste

Question 17

When a report which has an attachment control is viewed in Report View, what does the Attachment toolbar not allow you to do?

Accepted Answer

A)  Navigate from one attachment to another 
B)  Click the paperclip icon to open the Attachments dialog box 
C)  Delete any attachments 
D)  Move back and forth through the attachments 
A)  Navigate from one attachment to another 
B)  Click the paperclip icon to open the Attachments dialog box 
C)  Delete any attachments 
D)  Move back and forth through the attachments

Question 18

PDF files are more commonly used than XPS documents.

Accepted Answer

A) True 
 B)False

Question 19

Match the following terms with their descriptions:
I. Fixed-length text file
II. Hyperlink
III. Importing
IV. Linking
V. Text file
A. Data type to link to a file on your computer or a webpage
B. Connects to an external file without copying the records to the existing table
C. Common file formats used for exchanging data
D. Copies external data without maintain a link to the external file
E. Allocates a certain number of characters for each field

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 20

When you click a hyperlink value, Access launches the appropriate program, such as a Web browser, Word, or Excel, and enables you to interact with the file.

Accepted Answer

A) True 
 B)False

Which of the following is not a valid data source for exporting to Excel?

The hyperlink data type that enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

PDF stands for ________ Document Format.

You cannot change the ________ of a linked table in the destination database.

Just like in Word, when you see a hyperlink in datasheet view, you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

________ allows you to connect to an external database without having to import the table into your current database.

ScreenTips are fixed in Access and cannot be changed.

________ text files allocate a certain number of characters for each field.

In a form or report, you can interact with attachments using an attachment ________.

URL is the location of a website or webpage on the Internet.

When you export data from Access to Excel, the records in Access become ________ in Excel.

What is the first step in editing a hyperlink field?

The ________ data type enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

What is the first step in exporting a table from one database to another database?

What query type can you create to assist in copying records from a linked table?

When a report which has an attachment control is viewed in Report View, what does the Attachment toolbar not allow you to do?

PDF files are more commonly used than XPS documents.

When you click a hyperlink value, Access launches the appropriate program, such as a Web browser, Word, or Excel, and enables you to interact with the file.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 8: Get Connected

Which of the following is not a valid data source for exporting to Excel?

The hyperlink data type that enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

PDF stands for ________ Document Format.

You cannot change the ________ of a linked table in the destination database.

Just like in Word, when you see a hyperlink in datasheet view, you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

________ allows you to connect to an external database without having to import the table into your current database.

ScreenTips are fixed in Access and cannot be changed.

________ text files allocate a certain number of characters for each field.

In a form or report, you can interact with attachments using an attachment ________.

URL is the location of a website or webpage on the Internet.

When you export data from Access to Excel, the records in Access become ________ in Excel.

What is the first step in editing a hyperlink field?

The ________ data type enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

What is the first step in exporting a table from one database to another database?

What query type can you create to assist in copying records from a linked table?

When a report which has an attachment control is viewed in Report View, what does the Attachment toolbar not allow you to do?

PDF files are more commonly used than XPS documents.

When you click a hyperlink value, Access launches the appropriate program, such as a Web browser, Word, or Excel, and enables you to interact with the file.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters