Access – Tutorial 8 – Flashcards

In the accompanying image, the selected field has been assigned which Data Type? Long Text Delimited Email Short Text

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

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. Table Analyzer Incorrect Response Normalization Analyze Performance Table Design

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? save the import steps in the Access database so they could quickly be run again provide each local office with a copy of the Access database and require them to use it for donor information storage create an HTML document from the Access database that could be updated by each local office require all local offices to use an Excel spreadsheet for donor information

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? capture a screen shot of the report from Access and email it as a picture export the report as an HTML document export the report to a PDF file to minimize file size and decrease download time print the report from Access and scan it to a large image to email

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time? PDF XML HTML CSV

In the accompanying figure, arrow number 3 points to the ____. tab for the first page of the tab control Tab Control tool tab for the second tab of the tab control a subform with a tab control

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. HTML PDF XML XLS

XML tags allow screen readers to easily navigate and voice information in a database exported as a PDF file. False True

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? save the Excel workbook as a PDF file export the Excel data for each school as a CSV file export the Excel data for each school to an XSL file save the Excel worksheet as an HTML document

Portions of an Excel workbook might be saved as an HTML file with values separated by commas so that the values in Excel may be imported into an Access table. False True

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. export distribute copy append

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

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? Append a copy of the records to the table Link to the data source by creating a linked table Import the source data to an existing table Import the source data into a new table in the current database

To create a reminder for an import task that is repeated on a regular basis, a(n) ____ may be created. Outlook Task Access Wizard Import Task Reminder Repeat Reminder

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? Structure Only Append Data to Existing Table(s) Structure and Data Append Data Only

Use the Link to the data source by creating a linked table option from the Get External Data - Excel Spreadsheet dialog box to create a table in a database that adds the source data from an Excel spreadsheet and updates the data in the table each time the source file is updated. False True

In the accompanying figure, which numbered arrow indicates the chart legend? 1 2 3 4

Data in an Access table linked to an Excel source file may be edited using which process? edit data in the Access table only edit data in the Excel source file only edit data in both Access and Excel separately data may not be edited once linked

A new database file is created using a standard template. True False

All records in an Access table exported as XML begin and end with which XML tag?

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. table properties field names field properties data source

Values in a CSV file are separated by which symbol? , (comma) ; (semi-colon) : (colon) - (dash)

Access does not have the capability to create charts and drawings. True False

In the accompanying figure, the ____ is indicated by arrow number 1. chart axis chart type chart data source chart title