Question 1

When exporting to a PDF,what should you check for when the objects are exported?

Accepted Answer

A) The number of pages 
B) The format of the report 
C) The name of the exported file 
D) The folder the file was saved to 
A) The number of pages 
B) The format of the report 
C) The name of the exported file 
D) The folder the file was saved to

Question 2

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

Accepted Answer

Exporting the structure enable

Question 3

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

Accepted Answer

A) PDF 
B) DOCX 
C) XLS 
D) XML 
A) PDF 
B) DOCX 
C) XLS 
D) XML

Question 4

The ________ file format does not allow you to edit the exported documents.

Accepted Answer

A) PDF 
B) Word 
C) Excel 
D) RTF 
A) PDF 
B) Word 
C) Excel 
D) RTF

Question 5

Match between columns
                        Premises: importing
fixed-length text file
CSV text file
hyperlink
attachment field

Accepted Answer

The Answer of data type that enables you to quickly is...

Question 6

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 7

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 8

What type of file does Access create when exporting to Word?

Accepted Answer

A) RTF 
B) HTML 
C) DOCX 
D) JPEG 
A) RTF 
B) HTML 
C) DOCX 
D) JPEG

Question 9

What is the major difference between a linked file and an imported file?

Accepted Answer

A linked file is resident in t

Question 10

You can ________ information from Access to another file format such as Word,Excel or PDF.

Accepted Answer

The answer of You can ________ information from Access to...

Question 11

What is one of the reasons you import directly into Access from Excel?

Accepted Answer

Once the data is imported,you can append

Question 12

What is the main reason for exporting data to Excel instead of Word?

Accepted Answer

A) You are not able to analyze the data as you can in Excel. 
B) The data can be manipulated the same as in Excel. 
C) Charts can be made in Word just as in Excel. 
D) Table information looks the same in both Word and Excel. 
A) You are not able to analyze the data as you can in Excel. 
B) The data can be manipulated the same as in Excel. 
C) Charts can be made in Word just as in Excel. 
D) Table information looks the same in both Word and Excel.

Question 13

If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.

Accepted Answer

The answer of If you have data in Excel that...

Question 14

What are the two most common types of text files that can be imported into Access?

Accepted Answer

CSV text f

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

________ is a useful format for basic formatted text documents such as instruction manuals,resumes,letters,and other documents.

Accepted Answer

A) RTF 
B) HTML 
C) DOCX 
D) JPEG 
A) RTF 
B) HTML 
C) DOCX 
D) JPEG

Question 17

________ 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 18

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

Accepted Answer

A) True 
 B)False

Question 19

What happens each time you open an attachment file in Access?

Accepted Answer

A) Access creates a temporary file on your computer's hard drive. 
B) The attachment opens in Design view. 
C) The attachment opens in a form or report. 
D) The attachment opens as a hyperlink. 
A) Access creates a temporary file on your computer's hard drive. 
B) The attachment opens in Design view. 
C) The attachment opens in a form or report. 
D) The attachment opens as a hyperlink.

Question 20

Once an attachment is added,the only way to delete the attachment is to delete the record.

Accepted Answer

A) True 
 B)False

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

When exporting to a PDF,what should you check for when the objects are exported?

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

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

The ________ file format does not allow you to edit the exported documents.

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

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

What type of file does Access create when exporting to Word?

What is the major difference between a linked file and an imported file?

You can ________ information from Access to another file format such as Word,Excel or PDF.

What is one of the reasons you import directly into Access from Excel?

What is the main reason for exporting data to Excel instead of Word?

If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.

What are the two most common types of text files that can be imported into Access?

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

________ is a useful format for basic formatted text documents such as instruction manuals,resumes,letters,and other documents.

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

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

What happens each time you open an attachment file in Access?

Once an attachment is added,the only way to delete the attachment is to delete the record.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

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

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters