Exam 8: Get Connected

URL stands for Uniform Resource ________.

In a form or report, you can interact with attachments using an attachment subform.

Attaching files does not increase the size of the database.

When you export forms and reports from Access to Excel, the results can be unpredictable.

Manipulating data in ________ is preferable to changing data in Access.

You can link to the tables in another Access database, as well as queries, forms, reports, macros, or modules in the other database.

Which of the following is not a typical reason to export data from Access to Excel?

Match the following desired actions with the method used to accomplish those actions: I. Add several pictures to each record II. Add the capability to jump out to a website easily III. Add capability of managing attachments on a form IV. Be able to manipulate a table's data in Excel V. Be able to view a report the same on any computer A. Attachment data type B. Attachment control C. Export to XPS D. Export to Excel E. Hyperlink data type

Match the following terms with their descriptions: I. Attachment controls II. XPS III. Attachment field IV. URL V. CSV text file A. Developed by Microsoft B. Location of a website C. Used to attach several files to a record D. Allows you to manage attached files in forms and reports E. Uses a comma to delineate columns

When a report which has an attachment control is viewed in Print Preview, which attachment displays?

When you export data from Access to Excel, the fields in Access become what in Excel?

________ is the process of copying external data directly into the database.

Importing an Excel spreadsheet into Access does not affect the size of the database file.

When should you not save the export steps?

Besides Excel, which program is often used to view the contents of a CSV file?

PDF stands for Portable Document ________.

If you want to export several objects from one database to another at the same time, make sure the Multiple Objects check box is checked.

Because Word is a part of the Office suite, you can analyze data exported from Access just as easily in Word as you can in Excel.

A CSV file might look like which of the following?

RTF stands for Rich ________ Format.