Question 1

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 2

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.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: The vertical axis of a chart that contains numbers representing a range of data values in a data series.

Accepted Answer

The Answer of source program and CSV file and XSD is...

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

Match between columns
                        Premises: Tags and other instructions are used by a web browser to process and display this type of document.

Accepted Answer

The Answer of source program and CSV file and mySQL is...

Question 8

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

Accepted Answer

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

Question 9

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 10

Match between columns
                        Premises: A programming language that uses customizable tags to describe the data it contains and how that data should be structured.

Accepted Answer

The Answer of CSV file and mySQL and HTML document is...

Question 11

When linking data from an Excel worksheet to an Access table, data may only be edited or changed using the ____________________.

Accepted Answer

The answer of When linking data from an Excel worksheet...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

The answer of Access uses the ____________________ program to edit...

Question 14

In the accompanying figure, which tab control is active?

Accepted Answer

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

Question 15

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 16

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 17

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 18

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.

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

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

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

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

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

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

When linking data from an Excel worksheet to an Access table, data may only be edited or changed using the ____________________.

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

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

In the accompanying figure, which tab control is active?

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

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

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

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

Managing Your Files

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 Forms

Creating Custom Reports

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 9: Sharing Integrating and Analyzing Data

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

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

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

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

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

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

When linking data from an Excel worksheet to an Access table, data may only be edited or changed using the ____________________.

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

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

In the accompanying figure, which tab control is active?

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

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

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

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

Managing Your Files

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 Forms

Creating Custom Reports

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters