Microsoft Access Course Outline

Structuring Databases

• Create and modify Ms Access databases, tables, field types, field properties
• Create and modify one-to-many relationships
• Enforce referential integrity
• Create and modify queries
• Create, add and modify form controls and properties
• Create, add and modify report and 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 and Filter records

Managing Databases

• Identify object dependencies
• View objects and object data in other views
• Print database objects and data
• Export data from Ms Access
• Backup, compact and repair databases