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

Question 1

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.

Answer 1

A

Question 2

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

Answer 2

A

Question 3

What differentiates a hyperlink from text?

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

Answer 3

A

Question 4

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

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 6

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 7

________ documents cannot be edited after being exported.

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

Question 8

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

Question 9

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 10

How is an attachment field identified in a table?

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

Question 11

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

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

Question 12

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

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

Question 13

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 14

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 15

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

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

Question 16

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 17

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 18

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 19

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.

Question 20

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 21

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

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

Question 22

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

The ________ file format is considered an alternative to PDF.

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

Question 24

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

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

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

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

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

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 30

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 31

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 32

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 33

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 34

Access is not able to ________ an attachment.

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

Question 35

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 36

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 37

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 38

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 39

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 40

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 41

An attachment appears as a paperclip in a table.

Question 42

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

Question 43

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 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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 51

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 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

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 61

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

Question 62

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

Question 63

Columnar forms and reports do not export to Word properly.

Question 64

Match the following terms with their meanings:
I. linking
II. portable document format (PDF)
III. Rich Text Format (RTF)
IV. Text file
V. XML Paper Specification (XPS)
A. a file format created by Adobe Systems for document exchange independent of software application and operating system environment
B. a file format developed by Microsoft and designed to display a printed page onscreen identically on any computer platform
C. a format that enables documents created in one software application to be opened with a different software application
D. format that enables documents created in one software application to be opened with a different software application
E. process that enables you to connect to a table without having to import the table data into your database

Question 65

Linking and importing produce the same result in Access.

Question 66

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

Question 67

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 68

PDF documents are the preferred format when exporting from Access.

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

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.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

PDF is a file format created by Microsoft.

Question 78

Match the following terms with their meanings:
I. attachment field
II. CSV text file
III. fixed-length text file
IV. hyperlink
V. importing
A. data type that enables you to quickly link to any file on your computer or any Web page on the Internet
B. is used it to attach multiple files of any format and then launch those files from within Access
C. enables you to copy external data into your database without linking it to your source file
D. uses a comma to separate one column from another, enabling the receiving software to distinguish one set of field values from the next
E. allocates a certain number of characters for each field

Question 79

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

Question 80

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