Question 1

What Access object can you not selectively export to a PDF or XPS document?

Accepted Answer

A) Form 
B) Report 
C) Query 
D) Table 
A) Form 
B) Report 
C) Query 
D) Table A

Question 2

________ is the process of copying external data directly into the database.

Accepted Answer

Importing

Question 3

If you want to store the details of website locations,but do not want the values to be actual hyperlinks,you can use what data type instead?

Accepted Answer

A) File 
B) Text 
C) Attachment 
D) OLE Object 
A) File 
B) Text 
C) Attachment 
D) OLE Object B

Question 4

Match between columns
                        Premises: RTF
CSV
URL
PDF
XPS

Accepted Answer

The Answer of Displays a printed page on screen the is...

Question 5

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 6

Match between columns
                        Premises: Linking
Hyperlink
Importing
Text file
Fixed-length text file

Accepted Answer

The Answer of Connects to an external file without copying is...

Question 7

________ is the default program for opening CSV files.

Accepted Answer

The answer of ________ is the default program for opening...

Question 8

You can link to the tables in another Access database,as well as queries,forms,reports,macros,or modules in the other database.

Accepted Answer

A) True 
 B)False

Question 9

Why did Microsoft create the XPS file format?

Accepted Answer

A) So that files could be password protected more securely 
B) So that a document viewed in Print Preview would display exactly the same on all computers 
C) So that additional security measures could be added to a document 
D) So that more of the formatting would transfer than the RTF standard would allow 
A) So that files could be password protected more securely 
B) So that a document viewed in Print Preview would display exactly the same on all computers 
C) So that additional security measures could be added to a document 
D) So that more of the formatting would transfer than the RTF standard would allow

Question 10

One reason for creating the PDF format was that the user would not need one particular program to view the file.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Which of the following will the hyperlink data type not link to?

Accepted Answer

A) File on your computer 
B) File stored only in RAM 
C) Website 
D) Email address 
A) File on your computer 
B) File stored only in RAM 
C) Website 
D) Email address

Question 13

Which of the following is not a typical reason to export data from Access to Excel?

Accepted Answer

A) Excel files are smaller. 
B) Allows distribution of data to those who do not have Access 
C) Allows the user to take advantage of Excel's charting capabilities 
D) It is often easier to run various scenarios in Excel. 
A) Excel files are smaller. 
B) Allows distribution of data to those who do not have Access 
C) Allows the user to take advantage of Excel's charting capabilities 
D) It is often easier to run various scenarios in Excel.

Question 14

When you change a file that had been attached to a database through the attachment data type and then change that document,the changes will be reflected in the database.

Accepted Answer

A) True 
 B)False

Question 15

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 16

URL stands for Uniform Resource ________.

Accepted Answer

The answer of URL stands for Uniform Resource ________....

Question 17

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

Accepted Answer

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

Question 18

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables,forms,reports)from scratch.

Accepted Answer

A) True 
 B)False

Question 19

Besides Excel,which program is often used to view the contents of a CSV file?

Accepted Answer

A) Publisher 
B) Notepad 
C) Word 
D) Outlook 
A) Publisher 
B) Notepad 
C) Word 
D) Outlook

Question 20

What allows you to manage attached files in forms and reports?

Accepted Answer

A) Attachment control 
B) Attachment subform/subreport 
C) Hyperlink control 
D) Attached File control 
A) Attachment control 
B) Attachment subform/subreport 
C) Hyperlink control 
D) Attached File control

What Access object can you not selectively export to a PDF or XPS document?

________ is the process of copying external data directly into the database.

If you want to store the details of website locations,but do not want the values to be actual hyperlinks,you can use what data type instead?

What is the first step in editing a hyperlink field?

________ is the default program for opening CSV files.

You can link to the tables in another Access database,as well as queries,forms,reports,macros,or modules in the other database.

Why did Microsoft create the XPS file format?

One reason for creating the PDF format was that the user would not need one particular program to view the file.

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.

Which of the following will the hyperlink data type not link to?

Which of the following is not a typical reason to export data from Access to Excel?

When you change a file that had been attached to a database through the attachment data type and then change that document,the changes will be reflected in the database.

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

URL stands for Uniform Resource ________.

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

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables,forms,reports)from scratch.

Besides Excel,which program is often used to view the contents of a CSV file?

What allows you to manage attached files in forms and reports?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 9: Get Connected

What Access object can you not selectively export to a PDF or XPS document?

________ is the process of copying external data directly into the database.

If you want to store the details of website locations,but do not want the values to be actual hyperlinks,you can use what data type instead?

What is the first step in editing a hyperlink field?

________ is the default program for opening CSV files.

You can link to the tables in another Access database,as well as queries,forms,reports,macros,or modules in the other database.

Why did Microsoft create the XPS file format?

One reason for creating the PDF format was that the user would not need one particular program to view the file.

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.

Which of the following will the hyperlink data type not link to?

Which of the following is not a typical reason to export data from Access to Excel?

When you change a file that had been attached to a database through the attachment data type and then change that document,the changes will be reflected in the database.

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

URL stands for Uniform Resource ________.

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

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables,forms,reports)from scratch.

Besides Excel,which program is often used to view the contents of a CSV file?

What allows you to manage attached files in forms and reports?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Enhanced Database Techniques

Filters