RTM’d today: MOS 2013 Study Guide for Microsoft Access


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.


Order from The Microsoft Press Store

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



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


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

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

Skip to main content