Exam 8: Get Connected

Match the following terms with their descriptions: I. PDF II. XPS III. RTF IV. CSV V. URL A. Useful for basic formatted text documents B. Created by Adobe Systems C. Double-clicking will open Excel D. Considered an alternative to PDF E. http://www.amazon.com

RTF stands for ________ Text Format.

When you export data from Access to Excel, the fields in Access become columns in Excel.

What does the number indicate if you see it in parenthesis to the right of the paperclip icon?

If you want to store the details of website locations, but do not want the values to be actual hyperlinks, you can use what data type instead?

When you export from Access into Word, the resultant file is in what format?

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

If your database is getting too large, what will not help to reduce the size of the database file?

What allows you to manage attached files in forms and reports?

XPS stands for XML ________ Specification.

Access uses the ________ icon to indicate attachments.

Which of the following is not an option when importing a CSV file into Access?

RTF does not support which feature?

What Access object can you not selectively export to a PDF or XPS document?

When you export data from Access to Excel, the fields in Access become ________ in Excel.

When exporting from Access to Excel, you can use an Access table or ________.

When you export Access data to a PDF or XPS document, you are required to purchase a commercial software application to view the information.

________ is the default program for opening CSV files.

Match the following terms with their descriptions: I. RTF II. PDF III. XPS IV. CSV V. URL A. Uses commas to determine columns B. Enables documents to be created in one program and opened in another C. Created by Adobe to allow the sharing of files D. Displays a printed page on screen the same no matter what computer is used E. Location of a webpage

Match the following desired actions with the method used to accomplish those actions: I. Add a title and formatting to a document in Word from data in Access II. Add data to a table from a text file III. Use a table from one database in another database IV. Make data in a spreadsheet available to Access V. Add various files to one field in Access A. Import a text file B. Add an attachment field C. Export to Word D. Export an Access object E. Import from Excel