MOS Access 2013 Study Guide, Exercises of Microsoft Access Skills

Download MOS Access 2013 Study Guide and more Exercises Microsoft Access Skills in PDF only on Docsity!

Microsoft IT Academy

Microsoft

Access

EXAM 77-

MOS 2013

Study Guide

Note

This content also published as MOS 2013 Study Guide for Access

Available at your favorite booksellers

ISBN 978-0-7356-6919-

MOS 2013 Study Guide (^) Microsoft Access (^) Exam (^) 77- Pierce 77- MOS ft Office Specialist (MOS) n validates your proficiencysoft Office programs, ting you can meet globally experience with the tech equired to successfully passperformance standards.- Certification exams. tails at: com/learning/certification t:ms/mosAccess2013/files^ Files

Microsoft Access

EXAM 77-

John Pierce MOS 2013 Study Guide spine = .48” See all our titles at: microsoftpressstore.com

Microsoft IT Academy (ITA) E-Book License Agreement

Microsoft Corporation grants to Microsoft IT Academy (ITA) teachers and students the

non-exclusive right to download, view, and use, this e-book at no additional charge in

connection with an ITA class. ITA teachers may also display and/or make digital copies of this

e-book solely for distribution to ITA students currently enrolled in their class. ITA teachers

and students may only print limited sections of the e-book (but not the entire e-book) for

reference purposes only.

To obtain a complete print version of this e-book, please purchase the book from an

available retailer or from https://www.microsoftpressstore.com

Other than as stated in this E-Book Agreement, you may not copy, print, modify, remove,

delete, augment, add to, publish, transmit, sell, resell, license, create derivative works from,

or in any way exploit any of the e-book’s content, in whole or in part, in print or electronic

form, and you may not aid or permit others to do so. All other rights are reserved.

iii What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit: microsoft.com/learning/booksurvey Contents Introduction............................................................... ix Who this book is for...................................................... .ix How this book is organized................................................ .ix Download the practice files................................................. x Sidebar: Adapting exercise steps...................................... .xi Ebook edition............................................................ xii Get support and give feedback............................................. xii Errata.............................................................. xii We want to hear from you........................................... .xiii Stay in touch....................................................... .xiii Taking a Microsoft Office Specialist exam...................................... xv Microsoft Office Specialist certification...................................... xv Selecting a certification path............................................... xv Test-taking tips.......................................................... xvi Certification benefits..................................................... xvii For more information................................................... .xviii Exam 77-424 Microsoft Access 2013 Prerequisites.............................................................. 1 1 Create and manage databases 3 1.1 Create new databases.................................................. 4 Creating desktop databases............................................ 5 Creating Access web apps............................................. 7 Working with application parts......................................... 9 Using earlier Access file formats....................................... 14 Practice tasks....................................................... 15

viii Contents 5.3 Format reports...................................................... 194 Applying themes to reports.......................................... 194 Adding information to report headers and footers...................... 195 Adding backgrounds and images to a report........................... 197 Applying page setup options........................................ 198 Adding calculated fields............................................. 201 Sorting records in a report........................................... 202 Practice tasks...................................................... 203 Objective review........................................................ 203 Index.................................................................... 205 About the author......................................................... 213 What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit: microsoft.com/learning/booksurvey

ix Introduction The Microsoft Office Specialist (MOS) certification program has been designed to valid- ate your knowledge of and ability to use programs in the Microsoft Office 2013 suite of programs, Microsoft Office 365, and Microsoft SharePoint. This book has been designed to guide you in studying the types of tasks you are likely to be required to demonstrate in Exam 77-424: Microsoft Access 2013. Who this book is for MOS 2013 Study Guide for Microsoft Access is designed for experienced computer users seeking Microsoft Office Specialist certification in Access 2013. MOS exams for individual programs are practical rather than theoretical. You must dem- onstrate that you can complete certain tasks or projects rather than simply answering questions about program features. The successful MOS certification candidate will have at least six months of experience using all aspects of the application on a regular basis, for example, using Access at work or school to create and manage databases, build data- base tables, import and export data, design and run queries, create and format forms, and design detail and summary reports. As a certification candidate, you probably have a lot of experience with the program you want to become certified in. Many of the procedures described in this book will be famil- iar to you; others might not be. Read through each study section and ensure that you are familiar with not only the procedures included in the section, but also the concepts and tools discussed in the review information. In some cases, graphics depict the tools you will use to perform procedures related to the skill set. Study the graphics and ensure that you are familiar with all the options available for each tool. How this book is organized The exam coverage is divided into chapters representing broad skill sets that correlate to the functional groups covered by the exam, and each chapter is divided into sections addressing groups of related skills that correlate to the exam objectives. Each section includes review information, generic procedures, and practice tasks you can complete on your own while studying. When necessary, we provide practice files you can use to work

Introduction xi

Adapting exercise steps

The screen images shown in this book were captured at a screen resolution of 1024 × 768, at 100 percent magnification. If your settings are different, the ribbon on your screen might not look the same as the one shown in this book. For ex- ample, you might have more or fewer buttons in each of the groups, the buttons you have might be represented by larger or smaller icons than those shown, or the group might be represented by a button that you click to display the group’s com- mands. As a result, exercise instructions that involve the ribbon might require a little adaptation. Our instructions use this format: ➜ On the Insert tab, in the Illustrations group, click the Chart button. If the command is in a list or on a menu, our instructions use this format: ➜ On the Home tab, in the Editing group, click the Find arrow and then, on the Find menu, click Advanced Find. Tip On subsequent instances of instructions located on the same tab or in the same group, the instructions are simplified to reflect that we’ve already established the working location. If differences between your display settings and ours cause a button to appear differently on your screen than it does in this book, you can easily adapt the steps to locate the command. First click the specified tab, and then locate the specified group. If a group has been collapsed into a group list or under a group button, click the list or button to display the group’s commands. If you can’t immediately identify the button you want, point to likely candidates to display their names in ScreenTips. If you prefer not to have to adapt the steps, set up your screen to match ours while you read and work through the exercises in this book. In this book, we provide instructions based on the traditional keyboard and mouse input methods. If you’re using the program on a touch-enabled device, you might be giving commands by tapping with a stylus or your finger. If so, substitute a tap- ping action any time we instruct you to click a user interface element. Also note that when we tell you to enter information, you can do so by typing on a keyboard, tapping an on-screen keyboard, or even speaking aloud, depending on your com- puter setup and your personal preferences.

xii Introduction Get support and give feedback The following sections provide information about getting help with this book and contacting us to provide feedback or report errors. Errata We’ve made every effort to ensure the accuracy of this book and its companion con- tent. Any errors that have been reported since this book was published are listed on our Microsoft Press site: http://aka.ms/mosAccess2013/errata If you find an error that is not already listed, you can report it to us through the same page. If you need additional support, email Microsoft Press Book Support at: [email protected] Please note that product support for Microsoft software is not offered through the preceding addresses.

xv Taking a Microsoft Office Specialist exam Desktop computing proficiency is increasingly important in today’s business world. When screening, hiring, and training employees, employers can feel reassured by relying on the objectivity and consistency of technology certification to ensure the competence of their workforce. As an employee or job seeker, you can use technology certification to prove that you already have the skills you need to succeed, saving current and future employ- ers the time and expense of training you. Microsoft Office Specialist certification Microsoft Office Specialist certification is designed to assist employees in validating their skills with Office programs. The following certification paths are available: l (^) A Microsoft Office Specialist (MOS) is an individual who has demonstrated profi- ciency by passing a certification exam in one or more Office programs, including Microsoft Word, Excel, PowerPoint, Outlook, Access, OneNote, or SharePoint. l (^) A Microsoft Office Specialist Expert (MOS Expert) is an individual who has taken his or her knowledge of Office to the next level and has demonstrated by passing a certification exam that he or she has mastered the more advanced features of Word or Excel. Selecting a certification path When deciding which certifications you would like to pursue, you should assess the following: l (^) The program and program version(s) with which you are familiar l (^) The length of time you have used the program and how frequently you use it l (^) Whether you have had formal or informal training in the use of that program l (^) Whether you use most or all of the available program features l (^) Whether you are considered a go-to resource by business associates, friends, and family members who have difficulty with the program

Taking a Microsoft Office Specialist exam xvii l (^) Read the exam instructions carefully before beginning. Follow all the instructions provided completely and accurately. l (^) Enter requested information as it appears in the instructions, but without duplicat- ing the formatting unless you are specifically instructed to do so. For example, the text and values you are asked to enter might appear in the instructions in bold and underlined text, but you should enter the information without applying these formats. l (^) Close all dialog boxes before proceeding to the next exam question unless you are specifically instructed not to do so. l (^) Don’t close task panes before proceeding to the next exam question unless you are specifically instructed to do so. l (^) If you are asked to print a document, worksheet, chart, report, or slide, perform the task, but be aware that nothing will actually be printed. l (^) When performing tasks to complete a project-based exam, save your work frequently. l (^) Don’t worry about extra keystrokes or mouse clicks. Your work is scored based on its result, not on the method you use to achieve that result (unless a specific method is indicated in the instructions). l (^) If a computer problem occurs during the exam (for example, if the exam does not respond or the mouse no longer functions) or if a power outage occurs, contact a testing center administrator immediately. The administrator will restart the com- puter and return the exam to the point where the interruption occurred, with your score intact. Certification benefits At the conclusion of the exam, you will receive a score report, indicating whether you passed the exam. If your score meets or exceeds the passing standard (the minimum required score), you will be contacted by email by the Microsoft Certification Program team. The email message you receive will include your Microsoft Certification ID and links to online resources, including the Microsoft Certified Professional site. On this site, you can download or order a printed certificate, create a virtual business card, order an ID card, view and share your certification transcript, access the Logo Builder, and access other useful and interesting resources, including special offers from Microsoft and affili- ated companies.

xviii Taking a Microsoft Office Specialist exam Depending on the level of certification you achieve, you will qualify to display one of three logos on your business card and other personal promotional materials. These logos attest to the fact that you are proficient in the applications or cross-application skills nec- essary to achieve the certification. Using the Logo Builder, you can create a personalized certification logo that includes the MOS logo and the specific programs in which you have achieved certification. If you achieve MOS certification in multiple programs, you can include multiple certifications in one logo. For more information To learn more about the Microsoft Office Specialist exams and related courseware, visit: http://www.microsoft.com/learning/en/us/mos-certification.aspx