Deck 8: Get Connected: Hands-On-Exercise Videos

Question 1

You can export an Access query to an Excel spreadsheet,but you CANNOT export a report.

Answer 1

False

Question 2

When displaying a form or report,you would use an attachment control to manage your attached files.

Answer 2

True

Question 3

If you make a mistake when entering a hyperlink,you can edit the link by clicking and correcting it.

Answer 3

False

Question 4

To open the Attachments dialog box,you ________.

A) point to the paperclip icon and press F2
B) click the paperclip icon
C) double-click the paperclip icon
D) right-click the paperclip icon

Question 5

You are limited to one attachment per record.

Question 6

A new attachment field displays as .

Question 7

You CANNOT export Access data to a(n)________.

A) Excel spreadsheet
B) Word document
C) Access table
D) PowerPoint presentation

Question 8

When you ________ an external table,you connect to the table without actually importing the table's data.

A) link
B) embed
C) join
D) associate

Question 9

When preparing an Excel spreadsheet to be imported into an Access database,the first row of the spreadsheet must have column headings that are recognized as field names by Access.

Question 10

The ________ data type is used to create a link to a Web site.

A) Internet link
B) external link
C) hyperlink
D) Web link

Question 11

You can export an Access table or form to another Access database.

Question 12

When an Access query is exported to Word,it is saved as a(n)________ file.

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

Question 13

When importing a text file,________ is a common file extension for files that are not fixed-length.

A) pdf
B) csv
C) docx
D) rtf

Question 14

When importing a fixed-length text file,the values in any field must have the same number of characters.

Question 15

If you want to share an Access report with someone who does not have Microsoft Office,you can export the report as a(n)________ file.

A) XLXS
B) DOCX
C) DOC
D) PDF

Question 16

To remove an attachment from a record,you ________.

A) click the paperclip press Delete
B) double-click the paperclip and click Remove
C) right-click the paperclip and select Delete from the menu
D) right-click the paperclip and select Remove from the menu

Question 17

When editing a hyperlink,it is enclosed in ________,which Access uses to activate the link when clicked.

A) quotation marks (")
B) asterisks (*)
C) ampersands (&)
D) pound signs (#)