Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2010     77-885: Microsoft Office Access 2010

---

The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.

---

---

Objectives

Working with Data and Simple Relationships modify how data is presented in datasheets sort and filter records in datasheets find and replace data in records import data from an Excel spreadsheet into an Access database export data from one Access database to another recognize key characteristics of table relationships create table relationships in a database edit table relationships sort and filter records find and replace data import and export data create and edit table relationships in a database