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 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) 
A)  Field Name 
B)  Import Field(s) 
C)  Select Field(s) 
D)  Do not import field (Skip)

Question 3

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

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

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.

Accepted Answer

A)  Access table name 
B)  Access table field names 
C)  Access database name 
D)  Access database field properties 
A)  Access table name 
B)  Access table field names 
C)  Access database name 
D)  Access database field properties

Question 7

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

Accepted Answer

A)  Saved Exports 
B)  More 
C)  Text File 
D)  XML File 
A)  Saved Exports 
B)  More 
C)  Text File 
D)  XML File

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

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

Question 11

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?

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Match between columns
                        Premises: The file type that contains format specifications for a table that may be exported from a database.

Accepted Answer

The Answer of XSD file and source program and y-axis is...

Question 17

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?

Accepted Answer

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

Question 18

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

Question 19

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 20

Match between columns
                        Premises: A program in which information is placed from a program containing original information or an original object.

Accepted Answer

The Answer of CSV file and destination program and XSL is...

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

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

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

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

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

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

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

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.

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

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.

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.

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?

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

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

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

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

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

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

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

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

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

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.

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

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.

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.

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?

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

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