Exam 9: Sharing Integrating and Analyzing Data

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

Document structure tags may be added to a(n) ____ exported from a database to add accessibility features.

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

Access uses ____ as the source program to create a graph when the Chart Wizard is used.

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 already created the table structure he wants to use in his database.  Therefore, when he imports the data from the local non-profit organizations, he will ____ the data to his existing table.

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

Access uses the ____________________ program to edit charts created with the Chart Wizard in Access.

Tools for exporting data from Access are available on the DATABASE TOOLS tab.____________________

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

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

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?

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

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. Each Excel worksheet that was exported contained column names.  Those names will appear in the first row of the Import Text Wizard and may be used as the ____ in the Access table.

The Access tool that analyzes a single table in a database and splits the table into two or more tables, if necessary, when it finds redundant data is the ____________________.

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

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

Which import option should be chosen in the Import XML dialog box when the data being imported are to be added to an existing table?

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?