Access 2003 - Introductory level
Categories: Microsoft Access
Access 2003 - Introductory level

Objectives
After completing this course you will know how to:
- Create a database
- Use queries to interrogate the data
- Use forms to input the data
- Create and print reports

Pre-requisites
- Experience of Windows 2000 or later
- Basic keyboard skills

Course Contents
Getting started
- Database concepts
- Exploring the Access environment
- Getting help
- Closing a database and Access

Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables

Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records

Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
- Using indexes

Simple queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries

Using form
- Creating forms
- Using the Form Wizard
- Using Design view
- Finding, sorting, and filtering records

Working with reports
- Creating reports
- Modifying and printing reports




 
Tools
 
Key Details
Duration1 day
 
£250
per delegate