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

Question 1

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

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

Answer 1

A

Question 2

In Access,what is a reference to an external file called?

A) Attachment
B) Paperclip
C) Field
D) OLE object

Answer 2

A

Question 3

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

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.

Answer 3

A

Question 4

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

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 5

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

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 6

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

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

Question 7

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

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

Question 8

What do you do if you only want to export part of a table 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 9

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

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

Question 10

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

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

Question 11

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

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

Question 12

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

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

Question 13

What happens when you export a form with a subform to Excel?

A) The form exports but the subform does not
B) The subform exports but the form does not
C) The results can be unpredictable
D) The original form is deleted when the export is completed

Question 14

How is an attachment field identified in a table?

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

Question 15

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

A) URL
B) HTTP
C) HTML
D) PDF

Question 16

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

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

Question 17

What differentiates a hyperlink from text?

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

Question 18

________ documents cannot be edited after being exported.

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

Question 19

What type of files are compressed by Access when you attach them?

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

Question 20

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

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

Question 21

Which of the following allows you to manage attached files in forms and reports?

A) Attachment control
B) Attachment field
C) Attachment file
D) Attached form

Question 22

What is the purpose of a ScreenTip?

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 23

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

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

Question 24

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

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

Question 25

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

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

Question 26

The ________ file format is considered an alternative to PDF.

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

Question 27

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

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 28

Before linking to a spreadsheet,you must first:

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 29

________ allocate a certain number of characters for each field.

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

Question 30

Access is not able to ________ an attachment.

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

Question 31

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

A) Linking
B) Copying
C) Pasting
D) Moving

Question 32

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

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 33

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

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 34

What happens when you double-click an attachment field in a table?

A) A dialog box opens with options
B) The attachment opens
C) The attachment is removed
D) The attachment is saved to a file

Question 35

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

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

Question 36

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

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

Question 37

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

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 38

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

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 39

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

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 40

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

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

Question 41

Word and Excel files are compressed by Access when you attach them.

Question 42

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

Question 43

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.

Question 44

Access creates a temporary file on your computer each time you open an attachment file.

Question 45

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

Question 46

Saving the export steps is the last step in the export process.

Question 47

A hyperlink field enables you to attach multiple files of different types.

Question 48

When you export a table to Excel,the field names become the column headings and the records become the rows in the Excel spreadsheet.

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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.

Question 55

An attachment appears as a paperclip in a table.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 62

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.

Question 63

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

Question 64

PDF documents are the preferred format when exporting from Access.

Question 65

When you export a table structure from one Access database to another,the new database has to be created.

Question 66

The file extension for a Rich Text Format file is slx.

Question 67

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

Question 68

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

Question 69

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

Question 70

XPS is a file format that displays a printed page onscreen identically on any computer platform.

Question 71

Tables,queries,forms and reports can all be exported to a PDF or XPS document.

Question 72

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

Question 73

PDF is a file format created by Microsoft.

Question 75

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

Question 76

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

Question 77

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

Question 78

Columnar forms and reports do not export to Word properly.

Question 79

Linking and importing produce the same result in Access.

Question 80

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.