Exam 4: Access: Sharing, Integrating, and Analyzing Data

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

In the accompanying figure, arrow number one indicates ____ for the data being imported into Access.

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

A file format that preserves the original formatting and pagination of its contents regardless of where it is viewed is the PDF (portable document format) file format.

The process of identifying and eliminating anomalies from a collection of tables is called ____.

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

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

An Access database may be saved as a template .

Access does not have the capability to create charts and drawings.

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

A file type that defines the structure of an XML file and embeds the information in the XML file.

To create a reminder for an import task that is repeated on a regular basis, a(n) ____ may be created.

"Record" is the default for the ____________________ form property and may be changed using the form Property Sheet.

While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____.

Case Based Critical Thinking Questions Case 8-1 The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information. Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year. Answer the following questions using your knowledge of Access tools for sharing and integrating data. Zach and Cayla have successfully imported all of the data from the school system's assessments into the Access database. Multiple queries have been created from the data, and the school system administrators would like to share the data with the school administrators and teachers using their secure Intranet. What is the best method to use to share the information so that it is easy to read using a Web browser?

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 been asked to share a report with the non-profit's Board of Directors which lists all donors by state. Brij created a query to appropriately sort the data and generated the report using Access. The report will be shared using e-mail. Which option is Brij most likely to choose to share this information?

When linking data from an Excel worksheet to an Access table, data may only be edited or changed using the ____________________.

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

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

The default encoding method for exporting Access data to an XML file is UTF-8, which uses 8 bits to represent each character.