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

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

A ____ may be inserted manually using the Page Break tool to make navigation of a large form easier by using the Page Up and Page Down keys on the keyboard.

In the accompanying image, the selected field has been assigned which Data Type?

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

The file type that contains format specifications for a table that may be exported from a database.

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-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. Once Zach has created the appropriate files from the Excel workbooks, Cayla will import the data into the Access database. Which tab will Cayla use from the Access Ribbon to begin the import process?

The Definition Only option must be chosen when importing both the structure and records of an external Access table using the Import Objects dialog box.

In the accompanying figure, which arrow points to the Tab Control tool?

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

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

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

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

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

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import & Link group on the EXTERNAL DATA tab and allows the user to run an import process that was previously saved.

A program in which information is placed from a program containing original information or an original object.

Which option in the Import Text Wizard allows the user to choose fields that will be imported from a CSV file?

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

XML tags allow screen readers to easily navigate and voice information in a database exported as a PDF file.

Use the Link to the data source by creating a linked table option from the Get External Data - Excel Spreadsheet dialog box to create a table in a database that adds the source data from an Excel spreadsheet and updates the data in the table each time the source file is updated.