| 1

9A

cce

ss

Matching and Multiple Choice | Access 1

Learn It OnLIne—chapter 9MAtChingMatch each term in the second column with its correct definition in the first column by writing the letter of the term on the blank line in front of the correct definition.

1. To bring in a copy of data from one source or application to another application.

2. The character set for data stored as Plain Text, without any formatting.

3. A connection to data in another file.

4. The acronym for the standard language for describing and delivering data on the web.

5. A naming tool that makes it easier to use the cells in calculations or modifications.

6. The acronym for a language used to display webpages.

7. To combine a main document created in Microsoft Word with a data source created in Access.

8. The primary document used in Excel to save and work with data that is arranged in columns and rows.

9. An Excel file that contains one or more worksheets.

10. The small box formed by the intersection of a column and a row in an Excel worksheet.

11. Includes two or more selected cells on a worksheet that can be treated as a single unit.

12. A graphic representation of data.

13. The process used to copy out data from one source or application to another application.

14. Codes that a web browser interprets when a webpage is loaded.

15. A document that defines the elements, entities, and content allowed when data is exported.

A ASCIIB CellC ChartD ExportE HTMLF ImportG LinkH Mail mergeI Named rangeJ RangeK TagsL WorkbookM WorksheetN XMLO XML schema

Multiple ChoiCeCircle the correct answer.

1. What type of file uses commas or tabs to separate fields?A. Converted B. Delimited C. Linear

2. Which file type can be imported into Access?A. Plain Text (.txt) B. Word document (.docx) C. Worksheet (.xlsx)

3. Which of the following tasks can be completed in a destination Access table that is linked to another file?A. Change data B. Add records C. Delete data

4. Which of the following can be done using a Saved Import?A. Copied to another database B. Moved to another database C. Execution scheduled in Outlook

5. In a mail merge operation, which Word document contains the text of the letter or memo to be merged?A. Main document B. Data source C. Merged document

6. How many Excel worksheets can be imported into Access at one time?A. One B. Two C. Three

2 | Chapter : 2 Access | Matching and Multiple Choice

7. What term describes data that is added to the end of an existing table?A. Linked B. Expended C. Appended

8. Which type of chart displays the contributions of parts to a whole amount?A. Pie chart B. Line chart C. Column chart

9. Which type of chart displays trends over time?A. Pie chart B. Line chart C. Column chart

10. The table structure—field names, data types, and field properties—is the tableA. definition. B. outline. C. description.

11. Which of the following Access objects can be exported to Excel in its original format?A. Query B. Report C. Macro

12. If existing data in a table is going to be shared among multiple databases, how should it be brought into a new database?A. Append records B. Import a table C. Link a table

13. If data from an Access table or query needs to be analyzed, to what file type should it be exported?A. Excel worksheet B. Word document C. HTML file

14. What is the name for code used in HTML to format text?A. Marker B. Tag C. Range

15. What term describes the two XML files created when an Access object is exported to XML so that the data can be viewed in a web browser?A. XML data B. XML schema C. XML presentation files