Deck 8: Sharing, Integrating, and Analyzing Data

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

A)Access table name
B)Access table field names
C)Access database name
D)Access database field properties

Question 6

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

Question 7

Access does not have the capability to create charts and drawings.

Question 8

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

Question 9

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

Question 10

To generate the most readable format for a table exported to HTML, always select the ____ option from the available export options.

A)Export data without formatting and layout
B)Export data with layout only
C)Export data with formatting and layout
D)Export data with formatting only

Question 11

Results returned by the Table Analyzer tool are always appropriate and do not need to be reviewed by the database designer.

Question 12

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

Question 13

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

Question 14

A static web page changes any time the data exported to the web page are changed in the Access database.

Question 15

A file format that preserves the original formatting and pagination of its contents regardless of where it is viewed is the PDF (portable document format)file format.

Question 16

An Access database may be saved as a template .____________________

Question 17

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

Question 18

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

Question 19

Values in a CSV file are separated by which symbol?

A), (comma)
B); (semi-colon)
C): (colon)
D)- (dash)

Question 20

Portions of an Excel workbook might be saved as an HTML file with values separated by commas so that the values in Excel may be imported into an Access table.____________________

Question 21

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

A)Outlook Task
B)Access Wizard
C)Import Task Reminder
D)Repeat Reminder

Question 22

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

A)edit data in the Access table only
B)edit data in the Excel source file only
C)edit data in both Access and Excel separately
D)data may not be edited once linked

Question 23

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

A)imported
B)linked
C)embedded
D)exported

Question 24

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.

A)Chart
B)Combo Box
C)Rectangle
D)Image

Question 25

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

A)RTF file
B)XML file
C)PDF file
D)HTML file

Question 26

It is important to open the ____ file before opening a linked Access table.

A)XSL
B)destination file
C)source file
D)XSD

Question 27

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

A)Application Parts
B)Navigation
C)More Forms
D)SharePoint Lists

Question 28

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

A)Application Parts gallery
B)external data gallery
C)Templates gallery
D)SharePoint Lists

Question 29

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

A)ACCDB
B)PFD
C)XPS
D)PDF

Question 30

The process of identifying and eliminating anomalies from a collection of tables is called ____.

A)analyzing
B)normalizing
C)exporting
D)importing

Question 31

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

A)Microsoft PowerPoint
B)Microsoft Graph
C)Microsoft Excel
D)Microsoft Draw

Question 32

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

A)Subform
B)Combo Box
C)Web Browser
D)Tab

Question 33

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.

A)Combo Box control
B)page break control
C)Tab control
D)Button control

Question 34

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

A)Excel
B)Access
C)Notepad
D)Outlook

Question 35

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

A)XSD
B)XSL
C)HTML
D)CSV

Question 36

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

A)field data
B)field names
C)table names
D)field properties

Question 37

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

A)Link to the data source
B)Copy the data source
C)Append a copy of the records to the table
D)Overwrite the records of the table

Question 38

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

A)PDF
B)XML
C)HTML
D)CSV

Question 39

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

A)import the source data into a new table
B)link to the data source by creating a linked table
C)append a copy of the records to a table
D)copy the data source from Excel

Question 40

While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____.

A)control
B)chart border
C)datasheet for the chart
D)Drawing tool

Question 41

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.
After Cayla imports all of the data into the Access database, Zach will use the ____ tool to be sure there are no redundant data in the table and review the results carefully.

A)Table Analyzer
B)Normalization
C)Analyze Performance
D)Table Design

Question 42

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?

A)capture a screen shot of the report from Access and email it as a picture
B)export the report as an HTML document
C)export the report to a PDF file to minimize file size and decrease download time
D)print the report from Access and scan it to a large image to email

Question 43

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)table properties
B)field names
C)field properties
D)data source

Question 44

To export an Access database object to an HTML document, click the ____ button on the External Data tab on the Ribbon.

A)Saved Exports
B)More
C)Text File
D)XML File

Question 45

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.

A)HTML
B)PDF
C)XML
D)XLS

Question 46

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?

A)save the import steps in the Access database so they could quickly be run again
B)provide each local office with a copy of the Access database and require them to use it for donor information storage
C)create an HTML document from the Access database that could be updated by each local office
D)require all local offices to use an Excel spreadsheet for donor information

Question 47

Predefined templates for Access databases that include tables, relationships, queries, forms, reports, and other database objects are displayed in ____________________ view.

Question 48

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?

A)save the Excel workbook as a PDF file
B)export the Excel data for each school as a CSV file
C)export the Excel data for each school to an XSL file
D)save the Excel worksheet as an HTML document

Question 49

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?

A)export the database to an XML document
B)export the query data to an XSL document
C)export each table and query to an XML document
D)export the query results to HTML documents

Question 50

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

Question 51

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

Question 52

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.

A)export
B)distribute
C)copy
D)append

Question 53

Begin the process of importing an XML file on the External Data tab in the ____________________ group.

Question 54

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.

Question 55

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

Question 56

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?

A)Create
B)Home
C)External Data
D)Database Tools

Question 57

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?

A)Append a copy of the records to the table
B)Link to the data source by creating a linked table
C)Import the source data to an existing table
D)Import the source data into a new table in the current database

Question 58

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

Question 59

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

Question 60

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

Question 69

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

Question 71

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

Question 73

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

Question 74

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