Access Training - Provisional Course Outlines

Using a training room within your organisation, and your PCs, charges per day for IT Training would be:

1 to 1 training	£275
2 to 4 delegates	£375
5 to 8 delegates	£450

All outlines can be adapted to the needs of the individual or organisation

Introductory Access

 

Aims of the course

 

This course aims to introduce delegates with little or no understanding of the Microsoft Access software to the basic features of the package.

 

Course Objectives

 

On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using a database. They should also be able to create and use tables and forms, and be able to retrieve information from a database using queries and reports.

 

The course is of one day's duration.

 

How the course is run - This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

 

Pre-requisites - Delegates attending the course should preferably have a basic understanding of the Windows environment and use of the keyboard and mouse.

 

Course Outline

Database Concepts

• Understanding what a database is

• Understanding how a database is organised in terms of tables, records, fields and with field data types, field properties

• Understanding what a primary key is

• Understanding what an index is

• Understanding the purpose of relating tables in a database

• Understanding the importance of setting rules to ensure relationships between tables are valid

 

First Steps with Databases

• Opening and closing Access

• Opening an existing database

• Creating a new database

• Saving a database to a location on a drive

• Using available Help functions

• Closing a database

 

Adjusting Settings

• Changing between view modes in a table, form, report

• Displaying and hiding built-in toolbars

 

Tables

• Creating and saving a table and specifying fields with their data types

• Adding and deleting records in a table

• Adding a field to an existing table

• Adding and modifying data in a record

• Deleting data in a record

• Using the undo command

• Navigating within a table to next record, previous record, first record, last record, specific record

• Deleting a table

• Saving and closing a table

• Defining a primary key

• Indexing a field with and without duplicates

• Changing field format attributes such as: field size, number format, date format

• Understanding consequences of changing field size attributes in a table

• Creating a simple validation rule for number, text, date/time, currency

• Changing column widths in a table

• Moving a column within a table

 

Table Relationships

• Creating a one-to-one, one-to-many relationship between tables

• Deleting relationships between tables

• Applying rules to relationships such that fields that join tables are not deleted as long as links to another table exist

 Forms

• Opening a form

• Creating and saving a form

• Using a form to enter, modify and delete records

• Navigating to next record, previous record, first record, last record, specific record using form display

• Adding and modifying text in form headers and footers

• Deleting a form

• Saving and closing a form

 

Searching and filtering

• Using the search command for a specific word, number, date in a field

• Applying a filter to a table or form

• Removing a filter from a table or form

 

Queries

• Creating a saving a query using specific search criteria

• Adding a criteria to a query using the operators <, <=, >, >=, = <>, AND, OR

• Editing a query by adding or removing criteria

• Editing a query by adding, removing, moving, hiding, unhiding fields

• Running a query

• Deleting a query

• Saving and closing a query

 

Sorting records

• Sorting data in a table, form or query output in ascending, descending, numeric and alphabetical order

 

Reports

• Creating and saving a report based on a table or query

• Changing arrangement of data fields and headings within a report layout

• Grouping data under a specific field in a report in ascending or descending order

• Presenting specific fields in a grouped report by sum, minimum, maximum, average, count, at appropriate break points

• Adding and modifying text in report headers and footers

• Deleting a report

• Saving and closing a report

 

Preparing outputs

• Previewing tables, forms and reports

• Changing report orientation: portrait, landscape. Changing paper size

• Print a page, selected records, a complete table

• Print all records or specific pages using form layout

• Printing the results of a query

• Printing a report or specific pages in a report

          

---

 

Intermediate Access

 Aims of the course

 This course aims to give delegates a greater understanding of Access.

 

Course Objectives

 

On completion of the course delegates will have improved their skills in using Microsoft Access. They will be able to:

·        Use field properties for protection

·        Understand table relationships and referential integrity

·        Create multi-table queries

·        Use calculations in a query

·        Design custom entry forms

·        Design custom reports

 

The course is of one day’s duration.

 

How the course is run – This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

 

Pre-requisites – Familiarity with the Windows environment, and a basic knowledge of Access.

 

Course Outline

 

Database Design

• Primary and Foreign Keys

• Relationships

 Using Field Properties for Protection

• The Required property

• Default Values

• Input Masks

• Validation Rules and Validation Texts

• Lookups

 Table Relationships

• Relationships Defined

• Relationship Types

• How to Create and Edit Relationships

• Using Lookups for Referential Integrity

• Multi-Table Datasheet view

 Queries

• Multi-table Queries

• Adding Calculated Fields to Queries

 Forms

• Form Sections

• Form Controls

• Layout of Form Controls

• Properties of Form Controls

• Control Wizards

• Introduction to Multi-Table Forms

Reports

• The Report Wizard

• Report Sections

• Report Controls

• Layout of Report Controls

Importing Data from Other Sources

 

Using Access Tools

• Backing up and restoring a database

• Compacting and repairing a database

---

Advanced Access

 

Aims of the course

 

This course aims to give delegates an insight into some of the more advanced features in Access.

 

Course Objectives

 

On completion of the course delegates will have added to their skills in using Microsoft Access. They will be able to:

·        Design databases

·        Creates indexes

·        Validate data

·        Use advanced forms features

·        Use Access in conjunction with the Internet

·        Create advanced queries

·        Produce reports

 

The course is of one day’s duration.

 

How the course is run – This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

 

Pre-requisites – Familiarity with the Windows environment, and a reasonable knowledge of Access. Prior attendance of the Intermediate Access course would be an advantage.

 

Course Outline

 

Database Design

• Theory of Normal Forms

• Naming Conventions

 

Getting the most out of Access

• Indexes

• Data Validation

• Table Level Validation

• Field Types

• Join Types

• Lookups

 

Advanced Forms

• Using Advanced Forms features

• The Form Worksurface

• Creating Calculated Controls

• Adding Graphics to Forms

• Multi-Table Forms

• Subforms

 

Access and the Internet

• Hyperlinks

• Exporting Datasheet views to HTML

• Data Access Pages

 

Advanced Queries

• Filtering Query results

• Parameter Queries

• Summary Queries

• Formatting the Output from Queries

• Query Join Types

 

Action Queries

• Make Table Queries

• Append Queries

• Delete Queries

• Update Queries

 

Advanced Reports

• Applying Sorting and Grouping to Reports

• Performing Calculations on Reports

• Adding Graphics to Reports

We provide computer training in Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, to London and the M25 corridor.

Please contact us for further details.