Exam 77-885 Microsoft Access 2010 with Microsoft Office 2010 Evaluation Software

The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student—technical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.

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