Microsoft Access Introduction
Introduction
Microsoft Access is the world's most popular desktop database program and takes full advantage of the Windows environment.
Objectives
To be able to plan and build an Access database. This involves creating tables and understanding the data types required, designing forms for entering data, sorting and filtering specific information and producing reports.
Designed for
New users of Access. Participants should have attended our "Introduction to Windows 95/98/NT" course or attained a similar level of proficiency.
Duration
Two days
Topics
- Introduction
- Database overview
- Terminology explained
- Access overview
- Database Design
- Database design issues
- One-to-many relationships
- Tables
- Creating a table
- Table structure – data types
- Primary keys
- Validation rules
- Input masks
- Indexing
- Data Entry
- Data sheet
- Forms
- Editing and deleting data
- Find and replace
- Sorting records
- Filtering records
- Importing data
Follow-up
Microsoft Access Intermediate 1 day course