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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

A new database file is created using a standard template .

Question 7

An Access database may be saved as a template .

Question 8

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 9

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

Question 10

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 11

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

Question 12

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

Question 13

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

Question 14

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 15

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 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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

A)<tblReferral>
B)<tblRecord>
C)<rcdReferral>
D)<accRecord>

Question 23

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

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

Question 24

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 25

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 26

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 27

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

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

Question 28

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 29

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 30

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 31

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

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

Question 32

In the accompanying figure, which tab control is active?

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

Question 33

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 34

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 35

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

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

Question 36

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 37

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 38

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 39

Values in a CSV file are separated by which symbol?

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

Question 40

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 41

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 42

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 43

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 44

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 45

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 46

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 47

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

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 51

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 52

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 53

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 54

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

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

Question 55

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

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

Question 56

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

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

Question 57

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 58

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 59

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 60

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 61

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

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

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 68

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

Question 69

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

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 72

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 73

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 74

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

Question 75

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 76

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 77

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 78

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

Question 79

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

Question 80

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