MOS: Microsoft Access 2007

Structuring Databases

à  Create Microsoft Access databases

à  Create and modify tables

à  Define and modify field types

à  < /span>Modify field properties

à  Create and modify one-to-many relationships

à  Enforce referential integrity

à  Create and modify queries

à  Create forms

à  Add and modify form controls and properties

à  Create reports

à  Add and modify report control properties

à  Create a data access page

Entering Data

à  Enter, edit, and delete records

à  Find and move among records

à  Import data to Access

Organizing Data

à  Create and modify calculated fields and aggregate functions

à  Modify form layout

à  Modify report layout and page setup

à  Format datasheets

à  Sort records

à  Filter records

Managing Databases

à  Identify object dependencies

à  View objects and object data in other views

à  Print database objects and data

à  Export data from Access

à  Back up a database

à  Compact and repair databases