Microsoft Access Foundation

Microsoft Access Foundation Course Outline

Database Introduction

• Database concepts and terminology
• Ground rules for database design
• Relational database concepts
• Getting started in Access
• Getting help

Table Design

• Creating a table in design view
• Data types
• Indexes
• Default values
• Validation rules
• Input masks
• Setting a primary key

Table Relationships

• Relational database design
• Creating relationships
• Database integrity and validation

Working with Tables

• Adding and editing data
• Navigating, adding, editing and deleting records
• Finding and replacing data
• Sorting and filtering records
• Filtering by selection
• Importing and exporting Data

Performing Select Queries

• Understanding queries
• Creating a select query
• Refining the results of a query
• Multi table queries

Form Design

• Understanding forms
• Creating forms
• Customising forms
• Main/sub forms

Reports

• Creating a report
• Previewing and printing