Question 1

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

Accepted Answer

The answer of The data value of each data item...

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A file type that defines the structure of an XML file and embeds the information in the XML file.

Accepted Answer

A) XSD file 
B) HTML document 
C) x-axis 
D) CSV file 
E) XSL
F)destination file
G)mySQL
H)XML (Extensible Markup Language)
I)source file
J)y-axis 
A) XSD file 
B) HTML document 
C) x-axis 
D) CSV file 
E) XSL
F)destination file
G)mySQL
H)XML (Extensible Markup Language)
I)source file
J)y-axis

Question 8

An Access database may be saved as a template.____________________

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

The answer of The Access tool that analyzes a single...

Question 14

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.

Accepted Answer

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

Question 15

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?

Accepted Answer

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

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

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

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

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

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

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

A file type that defines the structure of an XML file and embeds the information in the XML file.

An Access database may be saved as a template.____________________

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

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

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

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

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.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 8: Sharing,integrating,and Analyzing Data

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

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

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

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

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

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

A file type that defines the structure of an XML file and embeds the information in the XML file.

An Access database may be saved as a template.____________________

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

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

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

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

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.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters