major projects for IT training crown software and compter consultancy

Microsoft Access Intermediate Course Outline

Course Aims

This intensive one-day course is designed to give existing Access users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports.

Course Outline

Designing Tables in Access
Reviewing the Basics
Working with Indexes

Designing Queries in Access
Creating Action Queries
Calculating Summary Information
Crosstab Queries

Designing Forms in Access
Creating Data Entry Forms
Working with Subforms
Creating Pop-up Forms

Designing Reports in Access
Working with Standard Reports
Working with Pop-up Reports
Working with Subreports
Working with Report Snapshots

Target Audience

Existing users of MS Access who want to get grips with some of the more advanced features of this package as quickly as possible.

Assumed Knowledge

A basic understanding of PCs, Windows and MS Access is required, gained from previous experience or by attendance on an "MS Access Introduction" training course.

Related Courses

Access Introduction and Advanced; Windows; other MS Office Applications.

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited