669192cvr.indd 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.

 

Preorder from O’Reilly click here
Preorder from Amazon click here
Preorder from Barnes & Noble click here
Preorder from Ada’s Technical Books and Café click here

 

Contents at a glance

 

Introduction

Taking a Microsoft Office Specialist exam
Microsoft Office Specialist certification
Selecting a certification path
Test-taking tips
Certification benefits.
For more information

Exam 77-424 Microsoft Access 2013

Prerequisites

1 Create and manage databases

1.2 Manage relationships and keys
1.3 Navigate through databases
1.4 Protect and maintain databases
1.5 Print and export databases

2 Build tables

2.1 Create a table
2.2 Format tables
2.3 Manage records
2.4 Create and modify fields.

3 Create queries

3.1 Create a query
3.2 Modify queries
3.3 Utilize calculated fields and grouping within queries

4 Create forms

4.1 Create a form
4.2 Set form controls
4.3 Format forms

5 Create reports

5.1 Create a report
5.2 Set report controls
5.3 Format reports

Index
About the author

 

Introduction (excerpt)

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.

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

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
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.)

 

NOTE: O'Reilly Media is the official distributor of Microsoft Press books. View O'Reilly's terms of service for use of their services (including payment services) and the privacy policy applicable to how O'Reilly handles your data.