Your Office: Microsoft  Access 2016 Comprehensive by Amy S. KinserYour Office: Microsoft  Access 2016 Comprehensive by Amy S. Kinser

Your Office: Microsoft Access 2016 Comprehensive

byAmy S. Kinser, Brant Paige Moriarity, Eric Kinser

Spiral Bound | May 13, 2016

Pricing and Purchase Info


Earn 688 plum® points

Prices and offers may vary in store


Ships within 1-2 weeks

Ships free on orders over $25

Not available in stores


This book offers full, comprehensive coverage of Access. Ideal for business courses.

Real world problem solving for business and beyond

The Your Office series prepares students to use both technical and soft skills in the real world. Hands-on technical content is woven into realistic business scenarios and focuses on using Microsoft Office® as a decision-making tool. The series features a unique running business scenario that connects all of the cases together and exposes students to using Office to solve problems relating to business areas like finance and accounting, production and operations, sales and marketing.


Each chapter introduces a realistic business case for students to complete via hands-on steps that are easily identified in blue shaded boxes.  Each blue box teaches a skill and comes complete with video and interactive support. Chapters are grouped into Business Units, which collectively illustrate a specific set of business concepts to achieve AACSB-related outcomes.  Each Business Unit ends with a Capstone section, testing students' ability to apply concepts and skills beyond a single chapter.


Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.


Amy S. Kinser, Esq., Series Editor Amy holds a B.A. degree in Chemistry with a Business minor from Indiana University, and a J.D. from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spen...
Title:Your Office: Microsoft Access 2016 ComprehensiveFormat:Spiral BoundDimensions:832 pages, 10.7 × 8.5 × 1.2 inPublished:May 13, 2016Publisher:Pearson EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0134479556

ISBN - 13:9780134479552


Table of Contents


Chapter 1: Understanding the Common Features of Microsoft Office                                     3


Chapter 1: The Four Main Database Objects                                                                      54

Chapter 2: Tables, Keys, and Relationships                                                                        98

Chapter 3: Queries and Data Access                                                                                 168

Chapter 4: Using Forms and Reports in Access                                                                  218

Chapter 5: Advanced Tables                                                                                            278

Chapter 6: Pattern Matching and Functions in Queries                                                       335

Chapter 7: Aggregated Calculations, Subquerying, and SQL                                               386

Chapter 8: Action Queries and Advanced Relationships                                                      447

Chapter 9: Advanced Form Settings and Form Types                                                         494

Chapter 10: Advanced Reports and Mailing Labels                                                             538

Chapter 11: Develop Navigation Forms and the User Interface                                            590

Chapter 12: Create a Refined User Experience with Macros                                                619

Chapter 13: Use VBA in Access                                                                                        670

Chapter 14: Implement Your Database                                                                             710

Appendix:                                                                                                                      748

Glossary:                                                                                                                       776

Index:                                                                                                                           785