Question 1

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

Accepted Answer

This statement is false. You can actually export a report from Access to Excel by selecting "Export" from the "External Data" tab and choosing "Excel" as the file type. However, the resulting Excel file will not display the report exactly as it appeared in Access, and certain formatting and design elements may not transfer over.

Question 2

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

Accepted Answer

An attachment control is specifically designed to manage attached files when displaying a form or report.

Question 3

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

Accepted Answer

False

Question 4

To open the Attachments dialog box,you ________.&#10;A) point to the paperclip icon and press F2&#10;B) click the paperclip icon&#10;C) double-click the paperclip icon&#10;D) right-click the paperclip icon

Accepted Answer

The answer of To open the Attachments dialog box,you ________.&#10;A)...

Question 5

You are limited to one attachment per record.

Accepted Answer

Many systems and applications allow for multiple attachments per record, depending on their specific functionalities and settings.

Question 6

A new attachment field displays as   .

Accepted Answer

This is the default ID assigned to a newly created attachment field in Microsoft Dynamics CRM. It will be replaced with the actual file name once a file is uploaded.

Question 7

You CANNOT export Access data to a(n)________.&#10;A) Excel spreadsheet&#10;B) Word document&#10;C) Access table&#10;D) PowerPoint presentation

Accepted Answer

Access data cannot be exported directly to a PowerPoint presentation. However, the data can be exported to Excel first and then imported into PowerPoint. The other options (A, B, and C) are all valid export options for Access data.

Question 8

When you ________ an external table,you connect to the table without actually importing the table's data.&#10;A) link&#10;B) embed&#10;C) join&#10;D) associate

Accepted Answer

When you link an external table, you establish a connection to the table without importing the data. This allows you to access the data in the external table without actually storing the data within the current database.

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.

Accepted Answer

Access uses the first row of the Excel spreadsheet to identify the column headings as field names in the Access database. It is important to ensure that the column headings are accurate and informative to aid in the organization and usability of the data.

Question 10

The ________ data type is used to create a link to a Web site.&#10;A) Internet link&#10;B) external link&#10;C) hyperlink&#10;D) Web link

Accepted Answer

The term commonly used for creating a link to a website is a hyperlink. The other options, such as "Internet link" and "Web link," are less commonly used terms. "External link" could refer to any link that leads outside of the current website, not just to a specific website.

Question 11

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

Accepted Answer

The answer of You can export an Access table or...

Question 12

When an Access query is exported to Word,it is saved as a(n)________ file.&#10;A) RTF&#10;B) DOCX&#10;C) PDF&#10;D) XPS

Accepted Answer

The answer of When an Access query is exported to...

Question 13

When importing a text file,________ is a common file extension for files that are not fixed-length.&#10;A) pdf&#10;B) csv&#10;C) docx&#10;D) rtf

Accepted Answer

The answer of When importing a text file,________ is a...

Question 14

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

Accepted Answer

The answer of When importing a fixed-length text file,the values...

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.&#10;A) XLXS&#10;B) DOCX&#10;C) DOC&#10;D) PDF

Accepted Answer

The answer of If you want to share an Access...

Question 16

To remove an attachment from a record,you ________.&#10;A) click the paperclip press Delete&#10;B) double-click the paperclip and click Remove&#10;C) right-click the paperclip and select Delete from the menu&#10;D) right-click the paperclip and select Remove from the menu

Accepted Answer

The answer of To remove an attachment from a record,you...

Question 17

When editing a hyperlink,it is enclosed in ________,which Access uses to activate the link when clicked.&#10;A) quotation marks (&#34;)&#10;B) asterisks (*)&#10;C) ampersands (&)&#10;D) pound signs (#)

Accepted Answer

The answer of When editing a hyperlink,it is enclosed in...

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