Exam 37: Access: Get Connected: Exchanging Data Between Access and Other Applications

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

When you export a table to Excel,the field names become the column headings and the records become the rows in the Excel spreadsheet.

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

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

What is the purpose of a ScreenTip?

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.

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

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.

If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.

PDF is a file format created by Microsoft.

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

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

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?

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

Which of the following allows you to manage attached files in forms and reports?

Why should you examine the Access table in your source fie before linking it?

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

What can you do if a comparable table already exists when you import a spreadsheet?

What happens when you double-click an attachment field in a table?