We are happy to announce that MOS 2013 Study Guide for Microsoft Access, by John Pierce, (ISBN 9780735669192) has shipped to the printer! Please read on for preordering information, the Contents at a glance, and an excerpt from the Introduction.
Introduction Taking a Microsoft Office Specialist exam Microsoft Office Specialist certification Selecting a certification path Test-taking tips Certification benefits. For more information
1.2 Manage relationships and keys 1.3 Navigate through databases 1.4 Protect and maintain databases 1.5 Print and export databases
2.1 Create a table 2.2 Format tables 2.3 Manage records 2.4 Create and modify fields.
3.1 Create a query 3.2 Modify queries 3.3 Utilize calculated fields and grouping within queries
4.1 Create a form 4.2 Set form controls 4.3 Format forms
5.1 Create a report 5.2 Set report controls 5.3 Format reports
Index About the author
The Microsoft Office Specialist (MOS) certification program has been designed to validate 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.
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 demonstrate 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 database 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 familiar 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.
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 through the practice tasks. You can practice the procedures in this book by using the practice files supplied or by using your own files. (If you use your own files, keep in mind that functionality in Access 2013 is limited in files created in or saved for earlier versions of the program.)