Question 1

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

Accepted Answer

A) True 
 B)False

Question 2

When adding a file to an attachment field,the file is actually copied into the database itself.

Accepted Answer

A) True 
 B)False

Question 3

Columnar forms and reports do not export to Word properly.

Accepted Answer

A) True 
 B)False

Question 4

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

Accepted Answer

A) True 
 B)False

Question 5

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

Accepted Answer

A) hyperlink 
B) software application 
C) ScreenTip 
D) command 
A) hyperlink 
B) software application 
C) ScreenTip 
D) command

Question 6

When exporting a table to Excel,all records in the table are exported,even if they are not needed.

Accepted Answer

A) True 
 B)False

Question 7

What differentiates a hyperlink from text?

Accepted Answer

A) Blue underline 
B) Green underline 
C) Red underline 
D) Black underline 
A) Blue underline 
B) Green underline 
C) Red underline 
D) Black underline

Question 8

A(n)________ is the location of a Web site or Web page on the Internet.

Accepted Answer

URL,unifor

Question 9

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 10

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

Accepted Answer

A) True 
 B)False

Question 11

PDF is a file format created by Microsoft.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which of the following file types increases the database size byte for byte when attached in Access?

Accepted Answer

A) JPEG and other photo formats 
B) Word and Excel files 
C) Excel and JPEG files 
D) Word and JPEG files 
A) JPEG and other photo formats 
B) Word and Excel files 
C) Excel and JPEG files 
D) Word and JPEG files

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Access is not able to ________ an attachment.

Accepted Answer

A) analyze the data within 
B) copy 
C) print 
D) save 
A) analyze the data within 
B) copy 
C) print 
D) save

Question 17

________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.

Accepted Answer

PDF,Portab

Question 18

What does Access do when you link a table to another Access database?

Accepted Answer

A) Creates a new table called a linked table 
B) Makes a table in the new database with all the data 
C) Imports the table as a text file 
D) Imports the table as an Excel spreadsheet 
A) Creates a new table called a linked table 
B) Makes a table in the new database with all the data 
C) Imports the table as a text file 
D) Imports the table as an Excel spreadsheet

Question 19

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

Accepted Answer

A) The size of the database remains the same. 
B) The linked table adds space to the database size. 
C) The linked table adds space byte for byte. 
D) The size of the database decreases in size. 
A) The size of the database remains the same. 
B) The linked table adds space to the database size. 
C) The linked table adds space byte for byte. 
D) The size of the database decreases in size.

Question 20

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

Accepted Answer

A) True 
 B)False

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

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

When adding a file to an attachment field,the file is actually copied into the database itself.

Columnar forms and reports do not export to Word properly.

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

When exporting a table to Excel,all records in the table are exported,even if they are not needed.

What differentiates a hyperlink from text?

A(n)________ is the location of a Web site or Web page on the Internet.

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

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

PDF is a file format created by Microsoft.

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

Which of the following file types increases the database size byte for byte when attached in Access?

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

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

Access is not able to ________ an attachment.

________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.

What does Access do when you link a table to another Access database?

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

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