Exam 8: Sharing, Integrating, and Analyzing Data

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

Case Based Critical Thinking Questions 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?

Values in a CSV file are separated by which symbol?

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.

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

Case Based Critical Thinking Questions 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?

It is not possible to make changes to data in an Access table using an exported static web page in a browser.____________________

The form control that appears in the Access window with tabs at the top is the ____ Control.

Predefined templates for Access databases that include tables, relationships, queries, forms, reports, and other database objects are displayed in ____________________ view.

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

A file format that preserves the original formatting and pagination of its contents regardless of where it is viewed is the PDF (portable document format)file format.

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

The ____ tool is used from the Controls group on the Design tab to create a chart based on field data from an Access table or query.

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.

Case Based Critical Thinking Questions 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?

Table or query data may be exported directly to the mail merge feature in Microsoft Excel .____________________

Data may only be imported into an Access table using worksheets from Excel.

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