Deck 32: Get Connected: Hands On Exercise Videos

Question 1

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

Answer 1

A

Question 2

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

Answer 2

B

Question 3

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

Answer 3

True

Question 4

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

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

Question 5

You are limited to one attachment per record.

Question 6

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 7

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 8

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

Question 9

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 10

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

Question 11

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

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

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

Question 14

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

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 (#)

Question 17

A new attachment field displays as