Insight IT Training - a flexible computer training service for business users

Microsoft Access Introductory Outline

Aims of the One-Day Course

This course has been designed to give new or recent users, with no formal training, the skills they need to use Microsoft Access to design and create a database. The course is 100% hands-on, with exercises to practice the skills as you learn them.

Course Content

What is a Database?
- Uses for a Database
- Database Object Types
- Steps to Creating a Database
Designing and Creating a Database
- Field Properties & Formats
- Design View and Design Properties
Data Manipulation
- Entering; Editing; Deleting Data
- Finding and Replacing specific entries
- Validating Data Entry

Building Forms
Filtering and Sorting
Building a Query
- Analysing and Summarising Data
- Using the Query Wizard
Printing Reports
- Report Wizard Grouping & Totalling; Summary Reports; Mailing Labels
An explanation of Relational Databases

Prerequisites

No previous experience of using Access is necessary, although keyboard and mouse experience is assumed. Familiarity with the use of Windows software is essential.

Course Duration

Six hours (9.30am to 12.30pm and 1.30pm to 4.30pm).

Next Course

Microsoft Access Intermediate

Prices