Textbook

77-885 Microsoft Access 2010

< >

This MOAC Microsoft Access 2010 77-885 text best prepares students for the Microsoft Office Specialist exam. The program is based upon the same curriculum as the Microsoft Office Specialist Exam to build the skills students need to succeed at work and the preparation they need to validate those skills and get the jobs they seek.

for 77-885 Microsoft Access 2010. Learn more at WileyPLUS.com

Create a customized edition with Wiley Custom Select

Instant access to textbooks as eTextbooks. Learn more at coursesmart.com

Table of Contents

LESSON 1: DATABASE ESSENTIALS 1

LESSON 2: CREATE DATABASE TABLES 30

LESSON 3: WORK WITH TABLES AND DATABASE RECORDS 49

LESSON 4: MODIFY TABLES AND FIELDS 78

LESSON 5: CREATE FORMS 107

CIRCLING BACK 1 129

LESSON 6: CREATE REPORTS 134

LESSON 7: CREATE AND MODIFY QUERIES 155

LESSON 8: USE CONTROLS IN REPORTS AND FORMS 183

LESSON 9: ADVANCED TABLES 224

LESSON 10: ADVANCED FORMS 240

CIRCLING BACK 2 261

LESSON 11: ADVANCED REPORTS 265

LESSON 12: ADVANCED QUERIES 286

LESSON 13: DISPLAY AND SHARE DATA 325

LESSON 14: IMPORT AND EXPORT DATA 350

LESSON 15: DATABASE TOOLS 382

CIRCLING BACK 3 401

APPENDIX A 406

APPENDIX B 410

GLOSSARY 411

CREDITS 414

INDEX 415

New To This Edition

Now in full-color for enhanced learning!
Instructors: Save hours grading Office documents with OfficeGrader for automated grading of spreadsheets
Page count increased by 25-30% - reflecting popular new features such as the Backstage View.

Hallmark Features

180 day trial version of Microsoft Office Professional 2010 packaged with corresponding textbook in select markets
Task based approach to learning software uses, features, and commands
Maps to 100% of the Microsoft Office Specialist (MOS) exam objectives
MOS exam vouchers available with the book (for additional fee)
MOS practice tests available with the book (additional fee)
Free 3 year introductory DreamSpark Premium license for the department available upon adoption