Question 1

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

Question 2

Manipulating data in Excel is preferable to changing data in Access.

Accepted Answer

A) True 
 B)False

Question 3

Importing an Excel spreadsheet into Access does not affect the size of the database file.

Accepted Answer

A) True 
 B)False

Question 4

URL stands for Uniform Resource ________.

Accepted Answer

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

Question 5

When you export data from Access to Excel, the records in Access become what in Excel?

Accepted Answer

A)  Rows 
B)  Columns 
C)  Titles 
D)  Sheets 
A)  Rows 
B)  Columns 
C)  Titles 
D)  Sheets

Question 6

If a hyperlink is an email address, Access launches a new email window and automatically enters the email address in the ________ field.

Accepted Answer

The answer of If a hyperlink is an email address,...

Question 7

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 8

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 9

When should you not save the export steps?

Accepted Answer

A)  When you will not be repeating the export 
B)  When you will be repeating the export 
C)  When the steps are complicated 
D)  When you are uncertain if you will be repeating the export 
A)  When you will not be repeating the export 
B)  When you will be repeating the export 
C)  When the steps are complicated 
D)  When you are uncertain if you will be repeating the export

Question 10

RTF stands for ________ Text Format.

Accepted Answer

The answer of RTF stands for ________ Text Format....

Question 11

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

Accepted Answer

A)  Table Relationships 
B)  Copying 
C)  Embedding 
D)  Linking 
A)  Table Relationships 
B)  Copying 
C)  Embedding 
D)  Linking

Question 12

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 13

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 14

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 15

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 16

If a source document is too wide to fit on one page, then a PDF reader will automatically shrink up the text to make sure it fits on one page.

Accepted Answer

A) True 
 B)False

Question 17

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

Question 18

What is a ScreenTip?

Accepted Answer

A)  A descriptive text that will display when you need help creating a hyperlink 
B)  A descriptive text that will display when you click on a hyperlink 
C)  A descriptive text that will display when you point to an object or an item on the ribbon 
D)  A descriptive text that will display when you edit a hyperlink 
A)  A descriptive text that will display when you need help creating a hyperlink 
B)  A descriptive text that will display when you click on a hyperlink 
C)  A descriptive text that will display when you point to an object or an item on the ribbon 
D)  A descriptive text that will display when you edit a hyperlink

Question 19

When you export an object from Access to Word, Access creates a file in Word's native .docx format.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following can you do to a linked table from within the destination database?

Accepted Answer

A)  Modify the data type of a field 
B)  Add fields 
C)  Use the data in forms, queries, and reports 
D)  Delete fields 
A)  Modify the data type of a field 
B)  Add fields 
C)  Use the data in forms, queries, and reports 
D)  Delete fields

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.

Manipulating data in Excel is preferable to changing data in Access.

Importing an Excel spreadsheet into Access does not affect the size of the database file.

URL stands for Uniform Resource ________.

When you export data from Access to Excel, the records in Access become what in Excel?

If a hyperlink is an email address, Access launches a new email window and automatically enters the email address in the ________ field.

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.

Why did Microsoft create the XPS file format?

When should you not save the export steps?

RTF stands for ________ Text Format.

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

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

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

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

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

If a source document is too wide to fit on one page, then a PDF reader will automatically shrink up the text to make sure it fits on one page.

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 a ScreenTip?

When you export an object from Access to Word, Access creates a file in Word's native .docx format.

Which of the following can you do to a linked table from within the destination database?

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

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.

Manipulating data in Excel is preferable to changing data in Access.

Importing an Excel spreadsheet into Access does not affect the size of the database file.

URL stands for Uniform Resource ________.

When you export data from Access to Excel, the records in Access become what in Excel?

If a hyperlink is an email address, Access launches a new email window and automatically enters the email address in the ________ field.

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.

Why did Microsoft create the XPS file format?

When should you not save the export steps?

RTF stands for ________ Text Format.

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

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

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

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

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

If a source document is too wide to fit on one page, then a PDF reader will automatically shrink up the text to make sure it fits on one page.

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 a ScreenTip?

When you export an object from Access to Word, Access creates a file in Word's native .docx format.

Which of the following can you do to a linked table from within the destination database?

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