Question 1

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.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

________ allocate a certain number of characters for each field.

Accepted Answer

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

Question 4

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

Question 5

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

Question 6

The ________ file format is considered an alternative to PDF.

Accepted Answer

A) XPS 
B) DOCX 
C) XLS 
D) RTF

Question 7

Once a hyperlink has been added to a table,it cannot be edited.

Accepted Answer

A) True 
 B)False

Question 8

How is an attachment field identified in a table?

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

What is the disadvantage of storing attachments in your database?

Accepted Answer

The answer of What is the disadvantage of storing attachments...

Question 12

Access is not able to ________ an attachment.

Accepted Answer

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

Question 13

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 14

Which of the following fields enables you to add multiple files of different types to a table?

Accepted Answer

A) Attachment 
B) Text 
C) Caption 
D) OLE

Question 15

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Columnar forms and reports do not export to Word properly.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of What is one of the reasons you...

Question 20

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

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

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

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

________ allocate a certain number of characters for each field.

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

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

The ________ file format is considered an alternative to PDF.

Once a hyperlink has been added to a table,it cannot be edited.

How is an attachment field identified in a table?

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

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

What is the disadvantage of storing attachments in your database?

Access is not able to ________ an attachment.

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.

Which of the following fields enables you to add multiple files of different types to a table?

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

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

Columnar forms and reports do not export to Word properly.

Match the following terms with their meanings:

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

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