Question 1

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.
A) Application Parts gallery
B) EXTERNAL DATA gallery
C) Templates gallery
D) SharePoint Lists

Accepted Answer

The Application Parts gallery in Access displays all the application parts created by the users of the program and makes them available to all Access database files on the computer. The EXTERNAL DATA gallery is used to manage external data sources, the Templates gallery displays pre-designed templates and the SharePoint Lists gallery is used to connect to lists on a SharePoint site.

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.
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 in Access can help identify and remove redundant data in tables, as well as suggest changes to optimize the table structure. Zach should use this tool to review the data and ensure that it is clean and accurate. The normalization tool is used to organize data into tables and reduce redundancy, but it is not relevant in this case since the data has already been imported into a table. Analyze Performance and Table Design are not relevant to this step of the process.

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.
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" to create a new table for each imported file. This option allows for the creation of a separate table for each import, which keeps the data organized and easy to access. The other options would either append the new data to an existing table or create a linked table, which would not allow for the creation of separate tables for each import.

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.
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 can be easily imported into Access tables, and each Excel worksheet can be exported as a separate CSV file for ease of use. Saving the Excel workbook as a PDF file or an HTML document will not allow for the data to be imported into Access, while exporting the Excel data for each school to an XSL file may not be as compatible with Access compared to CSV.

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.
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 allows for easy viewing in a web browser as HTML is the standard markup language used for web pages. This method also allows for the data to be easily updated as the queries can be run again and the HTML documents regenerated. Exporting to XML or XSL may require additional software or knowledge of programming languages to properly view and interpret the data.

Question 6

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 as it allows for a smaller file size, decreases download time, and maintains the formatting of the report. Option A of capturing a screen shot of the report as a picture may result in a lower quality image, and option D of printing and scanning the report is time-consuming and may result in a much larger file size. Option B of exporting the report as an HTML document may also result in formatting issues when viewed on different devices or platforms.

Question 7

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 contains options for exporting Access database objects to various formats, including HTML. The Saved Exports option is used to manage previously saved export specifications, while the Text File and XML File options are specific file formats for exporting.

Question 8

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

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 the same import specifications four times a year without having to manually recreate them each time. Providing each local office with a copy of the Access database or creating an HTML document from the database would not necessarily ensure consistent and accurate data entry, while requiring all local offices to use an Excel spreadsheet for donor information would defeat the purpose of consolidating all donor information in one database.

Question 10

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

The correct term for adding data from another source to an existing table in Access is "append." Therefore, Brij will need to append the data to his existing table. Options A, B, and C are not applicable in this situation.

Question 11

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 12

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 13

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 will be used as field names in the Access table. This can save time and effort in manually entering field names, and also ensures consistency between the Excel data and Access table. Table properties, field properties, and data source are not the appropriate choices for this scenario.

Question 14

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

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 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.
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 is a format commonly used for data exchange between different programs and is known for its flexibility and ability to handle complex data. It would be the most suitable choice for Brij to receive donor information from chapters using different database or spreadsheet applications as it allows for easy import into his Access database.

Question 18

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 19

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 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.
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. This tab includes options for importing data from Excel, as well as other external sources such as text files and ODBC databases.

Quiz 4: Access: Sharing, Integrating, and Analyzing Data

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

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