Exam 4: Access 4: Sharing Integrating and Analyzing Data

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.

The data value of each data item in a chart is represented by ____________________.

All records in an Access table exported as XML begin and end with which XML tag?

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. Cayla wants to create a new table for each of the imported files.  Which option should she choose from the dialog box that appears during the import process?

Access objects, including tables, queries, forms, and reports, may be exported from Access to an XML file.

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

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

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.

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.

All major operating systems for desktop computers, as well as handheld devices, include software that will open and display the ____ file format.

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

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-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 has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database. He would like to import each Excel worksheet as a separate table into the database.  What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?

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?

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

Table or query data may be exported directly to the mail merge feature in Microsoft Excel .____________________

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

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

Which type of file contains the format specifications for Access table data when exporting table data as an XML file?