Exam 9: Sharing Integrating and Analyzing Data

Discuss the three ways to integrate objects created by other programs into Access. How does Access handle the objects using each method?

Predefined templates for Access databases that include tables, relationships, queries, forms, reports, and other database objects are displayed in ____________________ view.

XML tags allow screen readers to easily navigate and voice information in a database exported as a PDF file.____________________

Discuss the three ways to integrate objects created by other programs into Access. How does Access handle the objects using each method?

A chart created with the Access Chart Wizard is ____ in Access.

Only the default name may be used for saved import steps in the Get External Data dialog box.

Case Based Critical Thinking Questions Case 8-2 Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually.  His company solicits donor information from local chapters of the non-profit organization.  Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database.  Based on your knowledge of importing and sharing Access data, answer the questions below. Brij has contacted each local chapter of the non-profit organization and asked for local donor information. Some local chapters use Excel to record the information, some use Access, and some use other database or spreadsheet applications.  To streamline the import process, Brij has asked each local chapter to send him the information in a(n) ____ document that is well suited for data exchange among many different programs.

External data imported from a CSV file into an Access database may only be appended to an existing table.

Values in a CSV file are separated by which symbol?

Data may only be imported into an Access table using worksheets from Excel.

In the accompanying figure, arrow number 1 indicates which element of the chart?

A(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

In the accompanying figure, arrow number 2 is pointing to which type of chart?

The ____ tool is used from the Controls group on the DESIGN tab to create a chart based on field data from an Access table or query.

Discuss the options offered by Access for importing and exporting data to other programs and file formats.

Discuss why XML files are often used to exchange data between companies and between programs within a company.

Begin the process of importing an XML file on the EXTERNAL DATA tab in the ____________________ group.

The encoding method for exporting Access data to an XML file which uses 16 bits to represent each character is the ____________________ encoding method.