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

A specialized template which may contain tables, relationships, queries, forms, reports, and other database objects that can be imported into an existing database is a(n) ____________________.

In the accompanying figure, arrow number 3 points to the ____.

All major operating systems for desktop computers, as well as handheld devices, include software that will open and display the ____ 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?

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

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?

The horizontal axis of a chart that contains labels describing each of the data items.

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

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 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.

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 objects, including tables, queries, forms, and reports, may be exported from Access to an XML file.

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

Tags and other instructions are used by a web browser to process and display this type of document.

To use an application part in an existing database, choose ____ from the CREATE tab on the ribbon to view the application parts gallery..

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

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

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

A program containing original information or an object.

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.