Question 1

________ are common methods of exchanging information between two computer systems.

Accepted Answer

A) Text files 
B) Excel spreadsheets 
C) Access tables 
D) Access forms 
A) Text files 
B) Excel spreadsheets 
C) Access tables 
D) Access forms

Question 2

Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.

Accepted Answer

A) True 
 B)False

Question 3

JPEG and other photo formats increase the database size byte for byte.

Accepted Answer

A) True 
 B)False

Question 4

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 5

When you export a table from Access,the table must be closed for the export to complete.

Accepted Answer

A) True 
 B)False

Question 6

The objects you select to export from Access to Word should have which of the following types of layout?

Accepted Answer

A) Tabular 
B) Stepped 
C) Block 
D) Outline 
A) Tabular 
B) Stepped 
C) Block 
D) Outline

Question 7

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

Accepted Answer

The answer of The Access data type that enables you...

Question 8

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 9

If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.

Accepted Answer

A) True 
 B)False

Question 10

What is the purpose of a ScreenTip?

Accepted Answer

A) It displays when you point your mouse over the hyperlink text 
B) It modifies what the user sees in Datasheet view 
C) It launches the hyperlink 
D) It edits the hyperlink 
A) It displays when you point your mouse over the hyperlink text 
B) It modifies what the user sees in Datasheet view 
C) It launches the hyperlink 
D) It edits the hyperlink

Question 11

Before exporting a table to another database,what must be done first?

Accepted Answer

A) A database must be created. 
B) A table structure must be created. 
C) A form and report structure must be created. 
D) Nothing needs to be done beforehand. 
A) A database must be created. 
B) A table structure must be created. 
C) A form and report structure must be created. 
D) Nothing needs to be done beforehand.

Question 12

Which application allows you to view XPS documents if the XPS viewer has not been installed?

Accepted Answer

A) Your browser 
B) Microsoft Word 
C) Microsoft Excel 
D) Adobe Acrobat Reader 
A) Your browser 
B) Microsoft Word 
C) Microsoft Excel 
D) Adobe Acrobat Reader

Question 13

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 14

________ documents cannot be edited after being exported.

Accepted Answer

A) PDF or XPS 
B) HTML or DOCX 
C) DOCX or XPS 
D) JPEG or PDF 
A) PDF or XPS 
B) HTML or DOCX 
C) DOCX or XPS 
D) JPEG or PDF

Question 15

A(n)________ appears next to a linked table name in the Navigation Pane.

Accepted Answer

A) arrow 
B) star 
C) pound sign 
D) ampersand 
A) arrow 
B) star 
C) pound sign 
D) ampersand

Question 16

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

Accepted Answer

A) True 
 B)False

Question 17

Before linking to a spreadsheet,you must first:

Accepted Answer

A) make sure the data is organized. 
B) make sure there are no blank fields. 
C) make sure the names of the tables are the same. 
D) all the above are true 
A) make sure the data is organized. 
B) make sure there are no blank fields. 
C) make sure the names of the tables are the same. 
D) all the above are true

Question 18

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

What is one reason to import an Excel worksheet into Access instead of linking it?

Accepted Answer

A) You have more control over the imported data 
B) You are still working with a copy of the worksheet and cannot modify it 
C) The data looks similar but still does not reside in the database 
D) The new worksheet copy is dependent on the original 
A) You have more control over the imported data 
B) You are still working with a copy of the worksheet and cannot modify it 
C) The data looks similar but still does not reside in the database 
D) The new worksheet copy is dependent on the original

Question 20

Why would you want to export an Access report to a PDF?

Accepted Answer

The documents do not require p

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

________ are common methods of exchanging information between two computer systems.

Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.

JPEG and other photo formats increase the database size byte for byte.

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.

When you export a table from Access,the table must be closed for the export to complete.

The objects you select to export from Access to Word should have which of the following types of layout?

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

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

If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.

What is the purpose of a ScreenTip?

Before exporting a table to another database,what must be done first?

Which application allows you to view XPS documents if the XPS viewer has not been installed?

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

________ documents cannot be edited after being exported.

A(n)________ appears next to a linked table name in the Navigation Pane.

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

Before linking to a spreadsheet,you must first:

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

What is one reason to import an Excel worksheet into Access instead of linking it?

Why would you want to export an Access report to a PDF?

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