Question 1

Developers may customize the ____________________ programming language to describe the data contained and the data structure.

Accepted Answer

The answer of Developers may customize the ____________________ programming language...

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

Accepted Answer

The best option for Zach to use to create a file from the Excel data that can be imported into Access is to export the Excel data for each school as a CSV file. CSV files are a commonly used format for importing data into Access as they allow for easy conversion of spreadsheet data to database tables. Additionally, CSV files can be opened and edited in Excel if needed before import. PDF, XLS, and HTML are not ideal formats for importing data into Access.

Question 3

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

Accepted Answer

Exporting the query results to HTML documents is the best method to use to share the information so that it is easy to read using a web browser. HTML is a language used to create web pages that can be easily read using a web browser. By exporting the query results to HTML documents, the administrators and teachers can view the information in a readable and easily accessible format on the secure Intranet. The other options, exporting the database or table/query data to an XML document and exporting the query data to an XSL document, would require additional steps for the information to be presented in a readable format on a web browser.

Question 4

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.
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.
A) export
B) distribute
C) copy
D) append

Accepted Answer

Brij needs to append the data to his existing table structure in order to keep all donor information in one place in the Access database. Exporting the data would create a separate file, distributing the data would not merge it into his existing table, and copying the data would duplicate existing records rather than adding new ones.

Question 5

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.
A) table properties
B) field names
C) field properties
D) data source

Accepted Answer

The column names exported from Excel worksheets will appear in the first row of the Import Text Wizard and may be used as the field names in the Access table. Table properties, field properties, and data source refer to other aspects of the database design and management.

Question 6

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

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 8

A(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

Accepted Answer

The answer of A(n) ____________________ contains tags and other instructions...

Question 9

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 10

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.
A) Table Analyzer
B) Normalization
C) Analyze Performance
D) Table Design

Accepted Answer

The Table Analyzer tool will review the data in the table and identify any redundant data, as well as offer suggestions for improving the structure of the table. This will allow Zach to review the results carefully and ensure the accuracy and efficiency of the database. Normalization is also an important process for improving database efficiency, but it is not directly related to identifying redundant data. Analyze Performance and Table Design are not relevant tools for this specific task.

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

Accepted Answer

Cayla should choose to import the source data into a new table in the current database. This will create a new table for each imported file, which is what she wants to do. Option A would append the records to an existing table, which is not what she wants. Option B would create a linked table, which means the data would still be in the original source and not in her new table. Option C would import the data to an existing table, which is also not what she wants.

Question 12

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.
A) Saved Exports
B) More
C) Text File
D) XML File

Accepted Answer

The "More" button on the External Data tab allows access to additional export options, including exporting to an HTML document. The other options listed (Saved Exports, Text File, and XML File) do not provide the option to export to HTML.

Question 13

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.
Brij has contacted each local chapter of the non-profit organization and asked for local donor information. Some local chapters use Excel to record the information, some use Access, and some use other database or spreadsheet applications.  To streamline the import process, Brij has asked each local chapter to send him the information in a(n) ____ document that is well suited for data exchange among many different programs.
A) HTML
B) PDF
C) XML
D) XLS

Accepted Answer

XML (Extensible Markup Language) documents are a common format for data exchange among different programs. It is a flexible format that can be used by many different programs and allows for easy import and export of data. HTML (Hypertext Markup Language) is used for creating web pages, PDF (Portable Document Format) is used for document sharing, and XLS (Excel Spreadsheet) is a specific format used only by Microsoft Excel. While Brij could potentially import data from Excel and other formats, XML is the best choice for streamlining the import process and ensuring compatibility among all local chapters' software applications.

Question 14

To add a copy of a picture to a form when no changes will be made to the picture at any time after it is added to the form, it is best to ____________________ the picture.

Accepted Answer

The answer of To add a copy of a picture...

Question 15

The Access tool that analyzes a single table in a database and splits the table into two or more tables, if necessary, when it finds redundant data is the ____________________.

Accepted Answer

The answer of The Access tool that analyzes a single...

Question 16

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.
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?
A) CREATE
B) HOME
C) EXTERNAL DATA
D) DATABASE TOOLS

Accepted Answer

Cayla will use the "EXTERNAL DATA" tab from the Access Ribbon to begin the import process. It allows importing data from various sources, including Excel workbooks.

Question 17

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

Accepted Answer

By saving the import steps in the Access database, Brij can quickly run them again each quarter to update the database with the latest donor information. Providing copies of the database to local offices or creating an HTML document would require additional steps and may result in inconsistencies or errors in the data. Requiring the use of an Excel spreadsheet would also require additional steps to import the data into the Access database and may not allow for all the functionality that Brij requires for creating reports and marketing documents.

Question 18

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 19

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.
Brij has been asked to share a report with the non-profit's Board of Directors which lists all donors by state.  Brij created a query to appropriately sort the data and generated the report using Access.  The report will be shared using e-mail.  Which option is Brij most likely to choose to share this information?
A) capture a screen shot of the report from Access and email it as a picture
B) export the report as an HTML document
C) export the report to a PDF file to minimize file size and decrease download time
D) print the report from Access and scan it to a large image to email

Accepted Answer

Exporting the report to a PDF file is the best option because PDFs are widely used, secure, and maintain the formatting of the original report. This will ensure that the report is accessible by all members of the board and is not compromised in the transmission process. Exporting as an HTML document or capturing a screen shot may not preserve the original formatting and may result in a loss of information. Printing the report and scanning it to a large image will result in a large file size and may not be easily accessible by all members of the board.

Question 20

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

Quiz 9: Sharing Integrating and Analyzing Data