Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

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?

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

Question 5

In the accompanying figure, arrow number 2 is pointing to which type of chart?

Accepted Answer

A)  circle chart 
B)  doughnut chart 
C)  pie chart 
D)  3-D pie chart 
A)  circle chart 
B)  doughnut chart 
C)  pie chart 
D)  3-D pie chart

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

Values in a CSV file are separated by which symbol?

Accepted Answer

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

Question 9

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 10

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

Question 11

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?

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

Question 12

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.

Accepted Answer

A)  Combo Box control 
B)  page break control 
C)  Tab control 
D)  Button control 
A)  Combo Box control 
B)  page break control 
C)  Tab control 
D)  Button control

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: A database type from which Access accepts imported data.

Accepted Answer

The Answer of XSD file and CSV file and x-axis is...

Question 15

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.

Accepted Answer

The answer of The ___________________ dialog box opens when the...

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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?

Accepted Answer

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

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

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

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

In the accompanying figure, arrow number 2 is pointing to which type of chart?

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

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

Values in a CSV file are separated by which symbol?

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

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 static web page changes any time the data exported to the web page are changed in the Access database.

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.

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

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

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

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

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 process of identifying and eliminating anomalies from a collection of tables is called ____.

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

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

In the accompanying figure, arrow number 2 is pointing to which type of chart?

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

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

Values in a CSV file are separated by which symbol?

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

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 static web page changes any time the data exported to the web page are changed in the Access database.

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.

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

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

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

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

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