Question 1

When you export an object from Access to Word,Access creates a file in the PDF format.

Accepted Answer

A) True 
 B)False

Question 2

A linked table is marked with an asterisk in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 3

When you save an RTF file,you might want to change the file type to a Word document in order to make formatting and editing easier.

Accepted Answer

A) True 
 B)False

Question 4

After exporting a file,if the document is too wide to display all the text,it will display on two pages.

Accepted Answer

A) True 
 B)False

Question 5

Rich Text Format (RTF)is a format that enables documents created in one software application to be opened with a different software application.

Accepted Answer

A) True 
 B)False

Question 6

________ uses a comma to separate one column from the next,enabling the receiving software to distinguish one set of field values from the next.

Accepted Answer

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

Question 7

When you double-click on a document with a RTF file extension,which of the following programs does Windows open by default?

Accepted Answer

A)  Word 
B)  Excel 
C)  Notepad 
D)  Wordpad 
A)  Word 
B)  Excel 
C)  Notepad 
D)  Wordpad

Question 8

What happens when you click a hyperlink field value while in Datasheet view?

Accepted Answer

A)  Access launches the program required to display the file or Web page 
B)  Access adds an attachment to the table 
C)  Access saves the corresponding file 
D)  Access creates a ScreenTip that appears when you hover over the hyperlink 
A)  Access launches the program required to display the file or Web page 
B)  Access adds an attachment to the table 
C)  Access saves the corresponding file 
D)  Access creates a ScreenTip that appears when you hover over the hyperlink

Question 9

What do you do if you only want to export part of a table to Excel?

Accepted Answer

A)  Filter the table first 
B)  You cannot export only part of a table 
C)  Only reports can be exported 
D)  Access cannot export to Excel 
A)  Filter the table first 
B)  You cannot export only part of a table 
C)  Only reports can be exported 
D)  Access cannot export to Excel

Question 10

Before exporting a table to another database,the new database has to be created.

Accepted Answer

A) True 
 B)False

Question 11

In a report,click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

Accepted Answer

A) True 
 B)False

Question 12

If a company stores tables in a centralized database,you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

Accepted Answer

The answer of If a company stores tables in a...

Question 13

PDF documents are the preferred format when exporting from Access.

Accepted Answer

A) True 
 B)False

Question 14

What can you do if a comparable table already exists when you import a spreadsheet?

Accepted Answer

A)  Append a copy of the Excel records to the table 
B)  Copy the table to Access 
C)  Link the table to the Access table 
D)  Export the table to Excel 
A)  Append a copy of the Excel records to the table 
B)  Copy the table to Access 
C)  Link the table to the Access table 
D)  Export the table to Excel

Question 15

When exporting from Access to Word,you are not able to analyze the data in Word.

Accepted Answer

A) True 
 B)False

Question 16

How is an attachment field identified in a table?

Accepted Answer

A)  Paperclip 
B)  Pound sign 
C)  File icon 
D)  Open book 
A)  Paperclip 
B)  Pound sign 
C)  File icon 
D)  Open book

Question 17

What is the default software application associated with a CSV file?

Accepted Answer

A)  Microsoft Excel 
B)  Microsoft Word 
C)  XML Paper Specification 
D)  Portable Document Format 
A)  Microsoft Excel 
B)  Microsoft Word 
C)  XML Paper Specification 
D)  Portable Document Format

Question 18

After you export an Access table to an RTF file,the file cannot be edited in Word.

Accepted Answer

A) True 
 B)False

Question 19

A linked file opens in Access even though the data resides in an external Excel file.

Accepted Answer

A) True 
 B)False

Question 20

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

Accepted Answer

A) True 
 B)False

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

When you export an object from Access to Word,Access creates a file in the PDF format.

A linked table is marked with an asterisk in the Navigation Pane.

When you save an RTF file,you might want to change the file type to a Word document in order to make formatting and editing easier.

After exporting a file,if the document is too wide to display all the text,it will display on two pages.

Rich Text Format (RTF)is a format that enables documents created in one software application to be opened with a different software application.

________ uses a comma to separate one column from the next,enabling the receiving software to distinguish one set of field values from the next.

When you double-click on a document with a RTF file extension,which of the following programs does Windows open by default?

What happens when you click a hyperlink field value while in Datasheet view?

What do you do if you only want to export part of a table to Excel?

Before exporting a table to another database,the new database has to be created.

In a report,click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

If a company stores tables in a centralized database,you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

PDF documents are the preferred format when exporting from Access.

What can you do if a comparable table already exists when you import a spreadsheet?

When exporting from Access to Word,you are not able to analyze the data in Word.

How is an attachment field identified in a table?

What is the default software application associated with a CSV file?

After you export an Access table to an RTF file,the file cannot be edited in Word.

A linked file opens in Access even though the data resides in an external Excel file.

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

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