Access 2016

CPE EditionDistributed by The CPE Store

www.cpestore.com1-800-910-2755

Laurie Ulrich Fuller

Ken Cook

Access 2016

Course Instructions and

Final Examination

The CPE Store819 Village Square Drive

Tomball, TX 773751-800-910-2755

Access 2016

Table of Contents

Page Course Objectives .............................................................................................................. 3 Course Instructions ............................................................................................................ 4 Final Examination ............................................................................................................... 7

- 2 -

COPYRIGHT 2016 – The CPE Store – ALL RIGHTS RESERVED. No portion of this material may be reprinted, reproduced, transmitted, stored in a retrieval system, or otherwise utilized, in any form or by any means, electronic or mechanical, including photocopying or recording, now existing or hereinafter invented, nor may any part of this course be used for teaching without written permission from the publisher and the author.

- 3 -

Course Objectives

After completing this course, you will be able to: Identify a step in the process of planning a database Determine which specialized interface for data entry and editing is ideal when someone else will be

handling the data entry task Ascertain what has been replaced by the Ribbon bar Recognize options of the Open command Spot the first step in accessing ScreenTips settings Ascertain what can be accessed by right-clicking the mouse Determine what assists in switching between tabs Identify the field type which allows users to link an item to an Access table Discern which data type stores URLs Determine what avoids redundant data by splitting data into several tables Select the term for the process of building tables so that fields and data are not repeated Identify a function of the primary key Ascertain what all primary key indexes must have Recognize a linking field used by Access to tie related tables together Pinpoint the default relationship type Discern what is used to open a table for editing Identify a step in adding a record Determine which keyboard shortcut can be used to insert the current date in a field Pinpoint what controls how data appears without changing the way it is stored Recognize the formatting code for text fields which can be used to create special formats such as a Social

Security number Discern what is required when including special characters in an input mask Identify the type of form layout which displays one record at a time Ascertain which control type is attached to a field that can store only true/false, on/off, or yes/no answers Recognize items which behave as a group when sized Identify the ideal function for creating a database when some of the data is already in spreadsheets Ascertain the best choice when replacing a source with a new database Recognize what the keystroke shortcut Ctrl+Break is used for Identify the option which is used to apply a change to the current record Spot a characteristic of the Replace and Replace All options Determine what tells Access to locate information that completely matches an entry in a table Identify the template used to create online database applications that are distributed via SharePoint Ascertain what a URL is Recognize the hyperlink protocol code in Access which links to a web page Discern what is searched when using the Find command Determine what is found by checking the Match Case check box Identify what tightens a search by using additional search criteria Recognize a characteristic of a filter Ascertain what can be accomplished using a select query Determine what relates Access tables to each other Identify a characteristic of the OR operator Discern which instruction is used to eliminate duplicate entries in query results Pinpoint the function which determines how many entries are in a group without performing a

mathematical calculation Determine the appropriate action when a field name contains more than one word Identify what is produced by Access when running a query containing a calculation Pinpoint what action is performed first in a calculation Recognize the function of the update query Pinpoint the button which displays the latest data in the tables included in a report Determine what controls the number of columns a report uses and how far apart the different elements

are from each other Identify the term used for text markers that display a test message on a report Ascertain what appears on a report’s first page below the report header Recognize an item which is only visible while a report is in either Layout or Design view Pinpoint a characteristic of the tabular layout Identify a good place to insert contact information for the author of a report Discern what default information is used by the Label Wizard Determine what should be entered after the field name appears in the Prototype Label box

- 4 -

Recognize the process used for naming a table Ascertain what is used to record information in case a database needs to be recreated Spot something which is created from a command on the Ribbon Determine what quality should be tested after creating a Navigation form Identify the final step in implementing a Navigation form Recognize a default setting for number fields Discern what the Unique Values property is used for Identify what is essential in preventing bad data from getting close to tables in a database

Course Instructions

To fully benefit from this course, please follow all of the steps below. 1. Read each chapter in the text to get a good understanding of the material. 2. Answer the study guide problems which appear at the end of each chapter. After answering the problems,

compare your answers with the correct answers to ensure that you understand the material. 3. When you feel that you have a good understanding of the material contained in the chapter, answer the

questions on the final examination. 4. When you have completed the final examination, record your answers on the answer sheet provided and

submit it for grading. A score of 70% or better is required to pass. Please also complete the course evaluation that accompanied the course and submit it to us along with your answer sheet. Upon passing you will receive a Certificate of Completion stating that you have successfully completed the course and earned the continuing education credit.

Prerequisites and Advance Preparation

No prerequisites or advance preparation are required for this course. CPE Credit

This course is recommended for 17 CPE credits. Final Exam Grading

► Online: Our fastest option, with instant results. Simply go to www.cpestore.com and click the link for online grading. Just follow the instructions from there. When you finish entering your answers, you’ll receive instant test results and a Certificate of Completion to print.

► By Mail: Mail your test and course evaluation to us. We grade the tests the day we receive them and mail

the results and Certificate of Completion to you the following business day. ► By Fax: Just fax your answer sheet to 1-281-255-4337. If you need us to fax the Certificate of Completion

back to you, please provide us with your fax number and write “please fax back” on your answer sheet. If you don’t need the Certificate faxed back, please write “no fax needed” on your answer sheet.

Refunds

The CPE Store guarantees your satisfaction. If, for any reason, you are not completely satisfied with your purchase, return it to us unused within 30 days for a prompt refund, no questions asked. (Sorry, but shipping fees are not refundable.)

- 5 -

Customer Service

The CPE Store holds itself to the highest standards. If we have not met your expectations, something is missing, or you just have a question please contact us at 1-800-910-2755 or customerservice@cpestore.com. About Our Courses

The CPE Store’s courses are developed to satisfy the continuing education requirements of the American Institute of Certified Public Accountants, each state’s Board of Accountancy and the National Association of State Boards of Accountancy (NASBA). If your state requires registration of sponsors, our sponsor number will appear on your Certificate of Completion. Our courses are designed to meet the continuing education requirements of accounting professionals. A great deal of care has been taken to ensure that the course material is both interesting and relevant to the practice of accounting. The information presented is, to the best of our knowledge, current and accurate. However, The CPE Store is not in the business of rendering legal, accounting or other professional advice and as such, the material presented in our courses is intended as an overview. If legal advice or other expert assistance is required, the services of a competent professional should be sought.

- 6 -

- 7 -

Access 2016 17-Credit Course

Final Examination

A score of 70% or higher is required to pass the exam. If you score less than 70% on your first attempt, we will allow you to take the test a second time. Chapter 1 – Access 2016 Basic Training 1. Which description best defines Access? A. Relational database B. Query C. Custom application D. Template 2. What is one step in the process of planning a database? A. Creating multiple table formats B. Building a custom application C. Defining fields D. Creating user forms 3. What does the Datasheet view provide users? A. List of available report templates B. Option to create a database with multiple tables C. Search options D. Spreadsheet-like environment for entering data 4. What specialized interface for data entry and editing is ideal when someone else will be handling the data

entry task? A. Form B. Query C. Report D. Template 5. Which of the following has been replaced by a ribbon bar divided into tabs? A. Flat-file database B. Subtotal report C. Report Wizard D. Menus and toolbars 6. What can be accomplished by clicking the Start button? A. Starting the Report Wizard B. Opening Access C. Opening templates D. Creating a form Chapter 2 – Navigating the Access Workspace 7. Toolbars are no longer made up of which of the following? A. Ribbon B. 3-D buttons C. Options dialog box D. File tab 8. Which of the following is not listed as an option when using the Open command? A. Recent B. OneDrive C. +Add a Place D. Desktop

Final Exam

- 8 -

9. What is a position for the Quick Access toolbar? A. Within Backstage view B. Below the Ribbon C. Drop-down list D. Home tab 10. What is the first step in accessing ScreenTips settings? A. Right-clicking on the Ribbon B. Choosing Collapse the Ribbon C. Clicking the File tab D. Pressing the Alt key 11. What can be accessed by right-clicking the mouse? A. Context-sensitive menus B. Ribbon C. Show Feature Descriptions in ScreenTips D. Option to turn off ScreenTips 12. What assists in switching between tabs? A. Left-clicking B. Right-clicking C. Options dialog box accessed on the File tab D. Pressing Alt Chapter 3 – Database Basics 13. Which field type allows users to link or embed an item to an Access table? A. Long Text B. OLE Object C. Lookup & Relationship D. Calculated Field 14. Which data type stores URLs? A. Hyperlinks B. Rich Text C. Attachment D. Short Text 15. Which of the following avoids redundant data by splitting data into several tables? A. Flat-file system B. Relational system C. Rich Text D. OLE Object Chapter 4 – Sounds Like a Plan 16. What term is used for the process of building tables so that you don’t repeat fields or data? A. Organization B. Centralization C. Signification D. Normalization Chapter 5 – Table Tune Ups 17. What is one function of the primary key? A. Assist Access in finding records quickly B. Link fields C. Find common fields between two or more tables D. Identify relationship types

Final Exam

- 9 -

18. What does Access automatically name the primary key if one is not created? A. Hyperlink B. OLE Object C. ID D. Memo 19. What must all primary key indexes have? A. Attachment B. Hyperlink C. ID D. Name 20. Which of the following is a linking field used by Access to tie related tables together? A. AutoNumber B. Foreign key C. Relational database D. OLE Object 21. What is the default relationship type? A. One-to-many B. One-to-one C. Many-to-many D. Junction tables 22. What is a limitation in building a table relationship? A. You must connect one record in a table to multiple records in another table B. You must link one record in one table to exactly one record in another table C. You must link many records in one table to many records in another table D. You must relate tables that are in the same database Chapter 6 – Remodeling Your Data 23. Which of the following is used to open a table for editing? A. File tab to the left of the Home tab B. Formatting section tab C. Field column D. Ribbon’s Field tab 24. What is a step in adding a record? A. Access the switchboard screen B. Click inside the first empty cell at the bottom of the table C. In Datasheet view chose Click to Add D. Right-click an empty cell 25. What is the shortcut for inserting the current date in a field? A. Ctrl+Z B. Ctrl+Shift C. Ctrl+; D. Esc Chapter 7 – Types, Masks, and Triggers 26. What controls how data appears without changing the way it is stored? A. Format B. Input Mask C. Required D. Validation

Final Exam

- 10 -

27. Which formatting code for text fields can be used to create special formats such as a Social Security number? A. Greater-than symbol B. Less-than symbol C. At sign D. Ampersand 28. Which of the following shows the decimal value without a comma as a thousands separator? A. Fixed B. Standard C. Percent D. Scientific 29. What is required when including special characters in an input mask? A. Putting a backslash in front of the characters B. Putting quotes around the characters C. Creating a validation rule D. Creating validation text 30. Which input mask code indicates that any character typed into the mask must fill it from right to left? A. Uppercase A B. Ampersand C. Exclamation point D. Less-than Chapter 8 – A Form for All Reasons 31. What type of form layout displays one record at a time? A. Simple form B. Split form C. Multiple item form D. Datasheet form 32. Which form layout displays multiple records at the same time with an attractive style applied to the form? A. Columnar B. Tabular C. Datasheet view D. Justified 33. Which control type is attached to a field that can store only true/false, on/off, or yes/no answers? A. Text box B. Label C. Combo box D. Check box 34. Which of the following behave as a group when sized? A. Anchored controls B. Bound text boxes C. Unbound text boxes D. List boxes Chapter 9 – Importing and Exporting Data 35. Which importing function is ideal for creating a database when some of the data is already in spreadsheets? A. Create a new table in an Access database for the data B. Append the data as new records at the end of an existing table C. Linking D. Create a plain text file

Final Exam

- 11 -

36. Which of the following makes a web page a web page? A. .TXT B. .XML C. .HTML D. .MDB 37. What is the best choice when replacing the source with a new database? A. Creating a .TXT file B. Linking C. Importing D. Using SharePoint 38. What is the keystroke shortcut Ctrl+Break used for? A. Stopping the import process B. Linking C. Starting the import process D. Exporting Chapter 10 – Automatic Data Editing 39. What option is used to apply a change to the current record? A. Replace B. Find Next C. Look In D. Match Any Part of Field 40. What is characteristic of the Replace and Replace All options? A. The changes are permanent B. They tell Access to find complete matches C. They tell Access to find partial matches D. They tell Access to find matches appearing at the beginning of a field 41. Which of the following tells Access to locate only information that completely matches an entry in a table? A. Find Next B. Replace C. Find What D. Match Whole Field Chapter 11 – Access and the Web 42. What is a template for creating quick, online database applications that are distributed via SharePoint? A. Office 365 B. Cloud C. Custom Web App D. Excel 43. What is a URL? A. Required hyperlink part also identified as the address B. Required display text C. Required link on the same page or document D. Required text that pops up as a ScreenTip 44. Which hyperlink protocol code in Access links to a web page? A. ftp:// B. http:// C. mailto: D. SkyDrive

Final Exam

- 12 -

Chapter 12 – Finding, Filtering, and Sorting Your Data – Fast 45. What is searched using the Find command? A. Current field in all the records of a table B. Look In search results C. Every field in the table D. Characters found at the beginning of the field 46. What is found by checking the Match Case check box? A. Data anywhere in the field that matches the search criteria B. Search terms that fill the entirety of the field C. Search data at the beginning of the field D. Search terms exactly as entered 47. What tightens a search by using additional search criteria? A. Main Filter command B. Toggle Filter C. Filter by Selection D. Filter by Form Chapter 13 – I Was Just Asking . . . for Answers 48. What is characteristic of a filter? A. Use a set of criteria when searching a database B. Quickly scan a single table for data C. Provide a blank query grid D. Examines multiple tables at once 49. What can be accomplished using a select query? A. Show specific fields in the results B. Allows users to ask only simple questions C. Use one search criterion D. Always displays all the columns for every matching record 50. Which of the following relates Access tables to each other? A. Filter B. Toggle Filter C. Key fields D. Select query Chapter 14 – I Want These AND Those OR Them 51. What is characteristic of the OR operator? A. Provides users more options to pick and choose which items from a list to do B. Narrows a query C. Returns fewer matches D. Requires all items to be done in a query Chapter 15 – Number Crunching with the Total Row 52. Which Total row function tells Access to calculate a field? A. Max B. StDev C. Expression D. Var 53. Which instruction is used to eliminate duplicate entries in query results? A. Group By B. Min C. Sum D. Last

Final Exam

- 13 -

54. Which of the following determines how many entries are in a group without performing a mathematical calculation?

A. Count B. Avg C. Where D. First Chapter 16 – Express Yourself with Formulas 55. What is the appropriate action when a field name contains more than one word? A. Make it the first step in building your formula B. Substitute numbers for words C. Put square brackets around the additional word D. Create two columns 56. When you run a query containing a calculation, what is produced by Access? A. Field name B. A datasheet showing the fields specified C. The Show Table dialog box D. Nested formula 57. What is performed first in a calculation? A. All operations in parentheses B. Exponents C. Multiplication D. Addition Chapter 17 – Take Charge with Action Queries 58. What is the function of the update query? A. Add files from external sources to an existing Access table B. Change the value in a field for the records selected via the Criteria row C. Delete files D. Pre-populate a field Chapter 18 – Fast and Furious Automatic Reporting 59. What facilitates the creation of a columnar report? A. Show Margins button B. Print Data Only button C. Page Setup dialog box D. One Page button 60. Of the following, which displays the latest data in the tables included in the report? A. Margins button B. Page Setup button C. Refresh All button D. Data buttons 61. What is used to tell Access about the paper on which you plan to print your report? A. Print button B. Size button C. Margins button D. The Page Tab of the Page Setup dialog box 62. Which of the following provides greater horizontal space on a page? A. Portrait layout B. Landscape layout C. Columnar report D. Tabular report

Final Exam

- 14 -

63. What controls the number of columns a report uses and how far apart the different elements are from each other?

A. Grid Setting B. More Pages button C. Print button D. Landscape button Chapter 19 – Professionally Designed Reports Made Easy 64. What term is used for text markers that display a text message on a report? A. Text boxes B. Combo boxes C. Labels D. Headers 65. What appears on the report’s first page below the report header? A. Page header B. Page footer C. Report footer D. Page break 66. What displays the actual database records? A. The Detail section B. Headers C. Footers D. Labels 67. What starts a new page from the point where the control is placed in the Report layout? A. Text boxes B. Combo boxes C. Page Header D. Page Break 68. Which of the following is only visible while a report is in either Layout or Design view? A. Format tab B. Page footer C. Page header D. Page Break control 69. What includes all of the colors that have been created for you? A. Font color B. Theme color C. Standard color D. Recent color Chapter 20 – Headers and Footers and Groups, Oh My! 70. What is characteristic of the tabular layout? A. Field descriptions print with every record’s data B. Field descriptions print once per page in the Page Header section C. Only uses page header and page footers D. Only uses report headers and report footers 71. What is a good place to insert contact information for the author of the report? A. Page header B. Report header C. Page Footer D. Report Footer

Final Exam

- 15 -

Chapter 21 – Magical Mass Mailings 72. What default information is used by the Label Wizard? A. Standard query B. Active table’s fields C. Filter drop-down boxes D. Font elements 73. What should be entered after the field name appears in the Prototype Label box? A. Space B. Font choice C. Label’s product number D. Postal code Chapter 22 – Analyze This! 74. What is the process for naming a table? A. Double-clicking each table’s title bar B. Using the mouse to drag and drop fields from table to table C. Dragging a field into any open space D. Selecting the field and clicking the Set Unique Identifier button 75. What facilitates changing the key-field designation? A. Navigation pane B. Flat-file table C. Set Unique Identifier button D. Database Tools tab 76. What records information helpful to the developer should the database need to be recreated? A. Documenter B. Table Analyzer Wizard C. Key-field designation D. Performance Analyzer 77. Which of the following reviews each database object? A. Table Analyzer Wizard B. Documenter C. Key-field designation D. Performance Analyzer Chapter 23 – Steer Users in the Right Direction with Navigation Forms 78. Which of the following is a good layout choice for a complex database? A. Vertical Tabs, Left layout B. Horizontal Tabs and Vertical Tabs, Left layout C. Navigation form D. Navigation pane 79. Which of the following is created from a command on the Ribbon? A. Navigation form B. Navigation pane C. Navigation button D. Vertical Tabs, Left layout 80. What quality should be tested after creating a Navigation form? A. Complexity of the database B. Database objects C. Whether the database has been saved D. Legitimacy of the commands

Final Exam

- 16 -

81. What is the final step in implementing a Navigation form? A. Choosing the most appropriate layout B. Adding objects C. Correcting mistakes or omissions D. Ensure it opens when the database opens Chapter 24 – Ten Common Problems 82. What determines whether a table structure is being built properly? A. Normalization B. Number fields C. AutoCorrect D. Options button on the File tab 83. Which of the following is a default in Access? A. Setting all number fields to accept long integers B. Setting all number fields to display decimals C. Setting all number fields to round up to a whole number D. Setting all number fields to prompt user enter a size 84. What is the Unique Values property used for? A. Undo accidental deletions B. Determine whether a record was actually deleted C. Tell Access to stop duplicating records D. Backup a database Chapter 25 – Ten Uncommon Tips 85. What is essential in preventing bad data from getting close to tables in a database? A. Specifying network paths B. Creating unique report names C. Performing a backup process D. Validations

Thank you for taking our course. We hope you enjoyed it.

Access 2016

Course Number: CC265501Qualifies for 17 hours of CPE credit

Name as it should appear on your Certificate: Where should we send your results?

____________________________________________________

License State(s): ____________________________________

License Number: ___________________________________

Date Course Completed: ____________________________

* Answer each question A, B, C, or D, as appropriate. * Be sure you are answering questions from the Final Examination, not from the Study Guide* For instant online grading, go to www.cpestore.com and click the link for Online Services

1. 18. 35. 52. 69.

2. 19. 36. 53. 70.

3. 20. 37. 54. 71.

4. 21. 38. 55. 72.

5. 22. 39. 56. 73.

6. 23. 40. 57. 74.

7. 24. 41. 58. 75.

8. 25. 42. 59. 76.

9. 26. 43. 60. 77.

10. 27. 44. 61. 78.

11. 28. 45. 62. 79.

12. 29. 46. 63. 80.

13. 30. 47. 64. 81.

14. 31. 48. 65. 82.

15. 32. 49. 66. 83.

16. 33. 50. 67. 84.

17. 34. 51. 68. 85.

Page 1 of 1

If you are mailing or faxing your test to us for 

grading, please fill in Member ID ___________ and 

Validation number ____________________.

Course EvaluationCourse # ________________

Your Name ______________________

Were the stated learning objectives met?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

If applicable, were prerequisite requirements appropriate and sufficient?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely m N/A

Was the text well-written, accurate and easy to understand?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

Was the final exam well-written, accurate and easy to understand?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

Were course materials relevant and did they contribute to the achievement of the learning objectives?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

Was the time allotted to the learning activity appropriate?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

If applicable, were the individual instructors effective?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely m N/A

Were you satisfied with the ordering process?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

Were your course materials in good condition when they arrived?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

Did you receive your materials in a timely manner?m 1 - Not at all m 2 - Marginally m 3 - Somewhat m 4 - Mostly m 5 - Absolutely

What is your preferred method for completing your CPE?m Textbook m PDF materials downloaded from the internet m Online courses m Live seminars

Would you like us to notify you by email of our weekly specials and new courses?m No m Yes, my email address is _____________________________________ m Already receiving

Are there any particular topics you would like to see covered in a CPE course or any additional services you wouldlike to see us provide?

Please provide any additional feedback, either positive or negative, regarding our products or our service:

The CPE Store819 Village Square Drive

Tomball, TX 77375Phone 1-800-910-2755

www.cpestore.comFax 281-255-4337

About the Course

About the Service

About You

Comments PleaseComments Please

About the Service

About the ServiceAbout the Course