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.

Accepted Answer

To insert blank lines above the table after exporting it from Access into Word, you can click immediately before the first value in the first cell of the table and press Enter to add an additional line.

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

Accepted Answer

Access typically compresses Word and Excel files when they are attached to the database. It may be possible to attach other file types, but they may not be compressed.

Question 3

What differentiates a hyperlink from text?
A) Blue underline
B) Green underline
C) Red underline
D) Black underline

Accepted Answer

A hyperlink is differentiated from regular text by a blue underline. When the cursor is moved over the hyperlink, it usually changes to a hand icon, indicating that it is clickable and will take the user to another location on the internet.

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

Accepted Answer

RTF (Rich Text Format) is a useful format for basic formatted text documents such as instruction manuals, resumes, letters, and other documents. It is widely supported and can be opened and edited by most word processing software. HTML (Hypertext Markup Language) is better suited for web pages, DOCX (Microsoft Word format) is proprietary and may not be compatible with other software, and JPEG is a format for images.

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

Accepted Answer

JPEG and other photo formats, when attached in an Access database, increase the database size byte for byte because they are stored in their entirety within the database file.

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

Accepted Answer

Filtering the table first will allow you to select and export only the desired rows or columns 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

Accepted Answer

PDF or XPS documents are both "read-only" formats, so they cannot be edited after being exported. HTML, DOCX, JPEG, and other file types can be edited after being exported.

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

Accepted Answer

In Datasheet view, clicking on a hyperlink field value will launch the program required to display the file or Web page.

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

Accepted Answer

The answer of What happens when you export a form...

Question 10

How is an attachment field identified in a table?
A) Paperclip
B) Pound sign
C) File icon
D) Open book

Accepted Answer

A paperclip icon is commonly used to identify an attachment field in a table.

Question 11

What type of file does Access create when exporting to Word?
A) RTF
B) HTML
C) DOCX
D) JPEG

Accepted Answer

Access creates RTF (Rich Text Format) files when exporting to Word. This format preserves the formatting and layout of the data being exported.

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

Accepted Answer

URL stands for Uniform Resource Locator and it is the address that identifies a particular webpage or file on the Internet. It consists of different parts such as the protocol (HTTP or HTTPS), the domain name, and the path to the specific page or file. Option B (HTTP) is a protocol used for transferring data over the Internet and is not specific to a particular location. Option C (HTML) is the markup language used for creating webpages, while option D (PDF) is a file format used for creating and sharing documents.

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

Accepted Answer

A hyperlink is a clickable link that allows the user to quickly navigate to another location, whether it be a file on their computer or a web page on the Internet. This is one of the most common and efficient ways to navigate to information on the computer or internet.

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

Accepted Answer

Tabular layout is best for exporting data from Access to Word as it presents information in a clear and organized format with columns and rows. Stepped, block, and outline layouts may not be as effective in presenting data in a clear and concise manner.

Question 15

In Access, what is a reference to an external file called?
A) Attachment
B) Paperclip
C) Field
D) OLE object

Accepted Answer

The answer of In Access, what is a reference to...

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.

Accepted Answer

Each time an attachment file is opened in Access, it creates a temporary file on the computer's hard drive. This allows Access to access the file and make necessary changes without altering the original attachment.

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

Accepted Answer

The answer of When you double-click on a document with...

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

Accepted Answer

Microsoft Excel is the default software application associated with a CSV (Comma Separated Values) file. CSV files are used to store tabular data and can be easily opened and manipulated in Microsoft Excel.

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.

Accepted Answer

Excel is designed to handle and analyze large sets of data, whereas Word is primarily a software for text editing and formatting. Exporting data to Excel allows for easier analysis and manipulation, such as creating charts or using Excel's built-in functions.

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

Accepted Answer

The Attachment field allows you to add multiple files of different types to a table.

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

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

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

What differentiates a hyperlink from text?

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

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

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

________ documents cannot be edited after being exported.

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

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

How is an attachment field identified in a table?

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

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

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

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

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

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

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

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

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

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