1 Day Corporate Training

Computer Training Courses

Access

Course Level: Intermediate

Click on the escalator to select another level.

Course Objectives:

To Utilise Access to design Databases
To Use advanced features in Queries, Forms and Reports

Prerequisites:

Attendance at Introduction to Access Course or at least 6-9 months experience of using Access regularly. Good knowledge of use/basic design of tables, queries, forms and reports

Duration:

1 Day

Course Content:

Session 1 - Introduction

Introduction to the course
Discussion of needs

Session 2 - Revision on Tables

Table Design
Field Properties
Relationships

Session 3 - Queries

Copying and Editing Queries
Parameter Queries
Calculated Fields
Grouping/Calculation Queries
Crosstab Queries
Action Queries - Make Table, Update
Append, Delete

Session 4 - Form/Report Design - controls

Controls - Add, Delete, Move, Resize
Labels, Text Boxes, Lines, Pictures
Combo and List Boxes
Calculated, using Expression Builder
Changing the appearance of Controls
Control Properties

Session 5 - Form and Report Design

Creating Mainform/Subform
*Subreports
Detail and groups/Totals Reports
Mailing Labels

Session 6 - Macros

Creating Macros
Adding Buttons to Forms
Assigning Macros to buttons

Session 7 - Working with other Packages

* Mail Merge with Word
* Exporting to Excel
* Importing Data to Access
* Appending Data

* Optional parts of the course depending on ability and requirements of participants

Next Level - Advanced Access

Click here to reserve a place on this course

Home I Company Profile I Accreditations I Recruitment I FAQs I Links
Course Schedule I Delivery I Where We Are I Enquiry Form I Email Us