Deck 9: 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

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

An Access database may be saved as a template .____________________

Question 7

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 8

A new database file is created using a standard template .____________________

Question 9

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 10

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

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

Tools for exporting data from Access are available on the DATABASE TOOLS tab.____________________

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

A) tab for the first page of the tab control
B) Tab Control tool
C) tab for the second tab of the tab control
D) a subform with a tab control

Question 22

In the accompanying figure, the data enclosed in the green rectangle are data imported from a CSV file that have been ____ by commas.

A) ordered
B) structured
C) delimited
D) defined

Question 23

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

A) Long Text
B) Delimited
C) Email
D) Short Text

Question 24

In the accompanying figure, which tab control is active?

A) FORM DESIGN TOOLS
B) Page 35
C) frmVisitsAndInvoices
D) Page 34

Question 25

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

A) Field Name
B) Import Field(s)
C) Select Field(s)
D) Do not import field (Skip)

Question 26

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

A)
B)
C)
D)

Question 27

In the accompanying figure, the ____ is indicated by arrow number 1.

A) chart axis
B) chart type
C) chart data source
D) chart title

Question 28

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

A) 1
B) 2
C) 3
D) 4

Question 29

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 30

Values in a CSV file are separated by which symbol?

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

Question 31

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 32

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 33

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?

A) Structure Only
B) Append Data to Existing Table(s)
C) Structure and Data
D) Append Data Only

Question 34

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

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

Question 35

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 36

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

A) destination program
B) source program
C) embedded program
D) linked program

Question 37

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 38

In the accompanying figure, arrow number one indicates ____ for the data being imported into Access.

A) the field names
B) data delimiters
C) data type
D) skipped fields

Question 39

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

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

Question 40

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 41

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

A) data marker
B) y-axis
C) data item name
D) x-axis

Question 42

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 43

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 44

Data from an Access database exported to an XML file are contained in ____.

A) tags
B) HTML tags
C) custom tags
D) paired tags

Question 45

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

A) data marker
B) x-axis
C) data item name
D) y-axis

Question 46

In the accompanying figure, which numbered arrow indicates the chart legend?

A) 1
B) 2
C) 3
D) 4

Question 47

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 48

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 49

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 50

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 51

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

A) x-axis
B) y-axis
C) data marker
D) data item name

Question 52

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 53

Which of the following is the file extension associated with an Access template?

A) *.accdb
B) *.accdt
C) *.mdb
D) *.dtacc

Question 54

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 55

In the accompanying figure, arrow number 2 is pointing to which type of chart?

A) circle chart
B) doughnut chart
C) pie chart
D) 3-D pie chart

Question 56

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 57

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 58

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

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

Question 59

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 60

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 61

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 62

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 63

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 64

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 65

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

Question 66

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 67

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 68

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 69

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.

Question 70

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 71

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 72

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 73

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 74

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 75

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

Question 76

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 77

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

Question 78

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 79

To add a copy of a picture to a form when no changes will be made to the picture at any time after it is added to the form, it is best to ____________________ the picture.

Question 80

Begin the process of importing an XML file on the EXTERNAL DATA tab in the ____________________ group.