Exam 4: Access 4: Sharing Integrating and Analyzing Data

The encoding method for exporting Access data to an XML file which uses 16 bits to represent each character is the ____________________ encoding method.

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

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

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.

A(n)____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

Data may only be imported into an Access table using worksheets from Excel.

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

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

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

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

It is not possible to make changes to data in an Access table using an exported static web page in a browser.____________________

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.

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

Values in a CSV file are separated by which symbol?

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

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database..

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

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