Question 1

To generate the most readable format for a table exported to HTML,always select the ____ option from the available export options.

Accepted Answer

A) Export data without formatting and layout 
B) Export data with layout only 
C) Export data with formatting and layout 
D) Export data with formatting only 
A) Export data without formatting and layout 
B) Export data with layout only 
C) Export data with formatting and layout 
D) Export data with formatting only C

Question 2

The file type that contains format specifications for a table that may be exported from a database.

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 E

Question 3

It is important to open the ____ file before opening a linked Access table.

Accepted Answer

A) XSL 
B) destination file 
C) source file 
D) XSD 
A) XSL 
B) destination file 
C) source file 
D) XSD C

Question 4

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 5

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

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

A database type from which Access accepts imported data.

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 9

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 10

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.
-Brij has already created the table structure he wants to use in his database.Therefore,when he imports the data from the local non-profit organizations,he will ____ the data to his existing table.

Accepted Answer

A) export 
B) distribute 
C) copy 
D) append 
A) export 
B) distribute 
C) copy 
D) append

Question 11

Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.

Accepted Answer

The answer of Using the minimum size option when saving...

Question 12

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.
-Once Zach has created the appropriate files from the Excel workbooks,Cayla will import the data into the Access database.Which tab will Cayla use from the Access Ribbon to begin the import process?

Accepted Answer

A) Create 
B) Home 
C) External Data 
D) Database Tools 
A) Create 
B) Home 
C) External Data 
D) Database Tools

Question 13

"Record" is the default for the ____________________ form property and may be changed using the form Property Sheet.

Accepted Answer

The answer of "Record" is the default for the ____________________...

Question 14

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 15

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

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 16

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 17

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 18

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 19

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 has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database.He would like to import each Excel worksheet as a separate table into the database.What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?

Accepted Answer

A) save the Excel workbook as a PDF file 
B) export the Excel data for each school as a CSV file 
C) export the Excel data for each school to an XSL file 
D) save the Excel worksheet as an HTML document 
A) save the Excel workbook as a PDF file 
B) export the Excel data for each school as a CSV file 
C) export the Excel data for each school to an XSL file 
D) save the Excel worksheet as an HTML document

Question 20

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import and 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...

To generate the most readable format for a table exported to HTML,always select the ____ option from the available export options.

The file type that contains format specifications for a table that may be exported from a database.

It is important to open the ____ file before opening a linked Access table.

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

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

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

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

A database type from which Access accepts imported data.

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

Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.

"Record" is the default for the ____________________ form property and may be changed using the form Property Sheet.

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

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

Values in a CSV file are separated by which symbol?

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

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.

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import and Link group on the External Data tab and allows the user to run an import process that was previously saved.

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

To generate the most readable format for a table exported to HTML,always select the ____ option from the available export options.

The file type that contains format specifications for a table that may be exported from a database.

It is important to open the ____ file before opening a linked Access table.

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

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

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

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

A database type from which Access accepts imported data.

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

Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.

"Record" is the default for the ____________________ form property and may be changed using the form Property Sheet.

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

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

Values in a CSV file are separated by which symbol?

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

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.

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import and Link group on the External Data tab and allows the user to run an import process that was previously saved.

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