Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 destination program and y-axis and HTML document is...

Question 3

Match between columns
                        Premises: A file type that defines the structure of an XML file and embeds the information in the XML file.

Accepted Answer

The Answer of HTML document and XSD file and y-axis is...

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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.

Accepted Answer

The answer of The ____________________ Wizard allows Field Names to...

Question 7

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

Accepted Answer

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 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

The answer of Begin the process of importing an XML...

Question 10

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 11

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

Accepted Answer

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 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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 15

Discuss why XML files are often used to exchange data between companies and between programs within a company.

Accepted Answer

The answer of Discuss why XML files are often used...

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Exam 9: Sharing Integrating and Analyzing Data

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

Match the followings.

Match the followings.

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

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

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.

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

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

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

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

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

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

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

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

Discuss why XML files are often used to exchange data between companies and between programs within a company.

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

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

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

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