Exam 4: Access 4: Sharing Integrating and Analyzing Data

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

Developers may customize the ____________________ programming language to describe the data contained and the data structure.

The form control that appears in the Access window with tabs at the top is the ____ Control.

When a table is exported using the Export to HTML tool, the web page that is created is a static web page.

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

A static web page changes any time the data exported to the web page are changed in the Access database.

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

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. After Cayla imports all of the data into the Access database, Zach will use the ____ tool to be sure there are no redundant data in the table and review the results carefully.

Which of the following applications may be used to view an XML file containing the data and the code that describes the data?

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.

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. The local non-profit offices update their donor information every quarter. Brij will find it necessary to update the database by using the same import specifications four times a year. Which process would expedite this task for Brij?

An Access database may be saved as a template .____________________

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

To generate the most readable format for a table exported to HTML, always select the ____ option from the available export options.

Data in an Access table linked to an Excel source file may be edited using which process?

Begin the process of importing an XML file on the External Data tab in the ____________________ group.

Portions of an Excel workbook might be saved as an HTML file with values separated by commas so that the values in Excel may be imported into an Access table.____________________

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

Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.