Microsoft Access Course Outlines

Microsoft Access Introduction

Course Duration

Two Days

Course Level

Introduction

Course Overview

Our introduction to Microsoft Access training course is suitable for complete beginners to Microsoft Access. At the end of this training course you will have a good working knowledge of Microsoft Access basics. You will feel more confident using Microsoft Access and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and create reports.

Those who complete the introduction to Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Microsoft Windows is required or attendance on one of our Microsoft Windows introduction courses. No experience of Microsoft Access is required.

Course Contents

Introduction

  • What is a Database?
  • Relational Databases
  • Definitions of Terms used
  • Planning a Database
  • Identify Reasons to Build a Relational Database

Overview of Access

  • Starting & Exiting Access
  • Access Screen Layout & Toolbars
  • Accessing Help

Creating A New Database

  • Creating a Table
  • Customising Data Entry
  • Data Types and Formats
  • Setting Primary Keys
  • Setting Field Properties
  • Add/Edit Fields
  • Saving Tables
  • Entering /Editing/Deleting Data
  • Understand Different Types of Relationships
  • Set Relationships between Tables

Creating Forms

  • Autoform
  • Form Wizard
  • Columnar Form
  • Tabular Form
  • Entering Data in a Form
  • Modifying a Form
  • Create a Sub Form

Queries

  • Creating a Query
  • Sort Fields in a Query
  • Setting up Criteria
  • Used Expressions within the Query
  • Multi Table Queries
  • Concatenation and Calculation
  • Parameter Queries
  • Change Query Join Types

Reports

  • Create Reports
  • Print Reports

Availability

Contact us to see how we can schedule the Microsoft Access introduction course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Access Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Overview

Our intermediate Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will understand relational databases and be able to work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Pivot Charts and Pivot Tables. Those who complete the intermediate Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A basic working knowledge of Access is required, or completion of our Access Introduction course.

Course Contents

Tables

  • Tables Refresher
  • Importing/Exporting Data
  • Relationships & Referential Integrity
  • Primary & Foreign Keys

Queries

  • Queries Refresher
  • Multi-Table Queries
  • Action Queries
  • Group by Queries
  • Modifying Query Output
  • Using Calculations & Expressions

Reports

  • Using Report Wizard
  • Tailoring Design of Reports
  • Basing Reports on a Query
  • Mailing Labels

Forms

  • Using Form Wizard
  • Tailoring Design of Forms
  • Controls Changing Tab Order

Availability

Contact us to see how we can schedule the Microsoft Access Intermediate course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Access Advanced

Course Duration

One Day

Course Level

Advanced

Course Overview

Our advanced Microsoft Access training course is suitable for those with a sound working knowledge of Microsoft Access who wish to progress to the most complicated functions and features.

At the end of this computer training course you will have a complete understanding of the higher functions of Microsoft Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources. Those who complete the advanced Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Access or our Access Intermediate course.

Course Contents

Performance and Database Design

  • Designing a Relational Database
  • Normalisation of Data
  • Primary and Secondary Keys

Queries

  • Calculating in Queries
  • Summary Queries

Forms

  • Advanced Form features
  • Forms and Subforms
  • Calculated Fields
  • Command Buttons
  • Bound and Unbound Controls

Reports

  • Grouping Data in Reports
  • Creating Calculations

Macros

  • Creating Macros
  • Adding Macros to Command Buttons
  • Event Driven Macros
  • Attaching Macros to a Form or Report Event

Custom Menus & Toolbars

  • Creating Custom Menus
  • Creating New Toolbars
  • Attaching a Custom Menu/Toolbar to a Form

Creating a Menu Form

  • Menu Form Properties
  • Setting Startup Defaults
  • Database Documentation

Availability

Contact us to see how we can schedule the Microsoft Access Advanced course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Access Introduction

Course Duration

Two Days

Course Level

Introduction

Course Overview

Our introduction to Microsoft Access training course is suitable for complete beginners to Microsoft Access. At the end of this training course you will have a good working knowledge of Microsoft Access basics. You will feel more confident using Microsoft Access and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and create reports.

Those who complete the introduction to Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Microsoft Windows is required or attendance on one of our Microsoft Windows introduction courses. No experience of Microsoft Access is required.

Course Contents

Introduction

  • What is a Database?
  • Relational Databases
  • Definitions of Terms used
  • Planning a Database
  • Identify Reasons to Build a Relational Database

Overview of Access

  • Starting & Exiting Access
  • Access Screen Layout & Toolbars
  • Accessing Help

Creating A New Database

  • Creating a Table
  • Customising Data Entry
  • Data Types and Formats
  • Setting Primary Keys
  • Setting Field Properties
  • Add/Edit Fields
  • Saving Tables
  • Entering /Editing/Deleting Data
  • Understand Different Types of Relationships
  • Set Relationships between Tables

Creating Forms

  • Autoform
  • Form Wizard
  • Columnar Form
  • Tabular Form
  • Entering Data in a Form
  • Modifying a Form
  • Create a Sub Form

Queries

  • Creating a Query
  • Sort Fields in a Query
  • Setting up Criteria
  • Used Expressions within the Query
  • Multi Table Queries
  • Concatenation and Calculation
  • Parameter Queries
  • Change Query Join Types

Reports

  • Create Reports
  • Print Reports

Availability

Contact us to see how we can schedule the Microsoft Access introduction course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Access Intermediate

Course Duration

One Day

Course Level

Intermediate

Course Overview

Our intermediate Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. This computer training course is designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will understand relational databases and be able to work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Pivot Charts and Pivot Tables. Those who complete the intermediate Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A basic working knowledge of Access is required, or completion of our Access Introduction course.

Course Contents

Tables

  • Tables Refresher
  • Importing/Exporting Data
  • Relationships & Referential Integrity
  • Primary & Foreign Keys

Queries

  • Queries Refresher
  • Multi-Table Queries
  • Action Queries
  • Group by Queries
  • Modifying Query Output
  • Using Calculations & Expressions

Reports

  • Using Report Wizard
  • Tailoring Design of Reports
  • Basing Reports on a Query
  • Mailing Labels

Forms

  • Using Form Wizard
  • Tailoring Design of Forms
  • Controls Changing Tab Order

Availability

Contact us to see how we can schedule the Microsoft Access Intermediate course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.

Microsoft Access Advanced

Course Duration

One Day

Course Level

Advanced

Course Overview

Our advanced Microsoft Access training course is suitable for those with a sound working knowledge of Microsoft Access who wish to progress to the most complicated functions and features.

At the end of this computer training course you will have a complete understanding of the higher functions of Microsoft Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources. Those who complete the advanced Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.

Course Requirements

A working knowledge of Access or our Access Intermediate course.

Course Contents

Performance and Database Design

  • Designing a Relational Database
  • Normalisation of Data
  • Primary and Secondary Keys

Queries

  • Calculating in Queries
  • Summary Queries

Forms

  • Advanced Form features
  • Forms and Subforms
  • Calculated Fields
  • Command Buttons
  • Bound and Unbound Controls

Reports

  • Grouping Data in Reports
  • Creating Calculations

Macros

  • Creating Macros
  • Adding Macros to Command Buttons
  • Event Driven Macros
  • Attaching Macros to a Form or Report Event

Custom Menus & Toolbars

  • Creating Custom Menus
  • Creating New Toolbars
  • Attaching a Custom Menu/Toolbar to a Form

Creating a Menu Form

  • Menu Form Properties
  • Setting Startup Defaults
  • Database Documentation

Availability

Contact us to see how we can schedule the Microsoft Access Advanced course into your corporate schedule.

Our Experience

F1 Computer Services offer in-house training and open courses to companies located in Hampshire, Dorset, Wiltshire, Bournemouth and Salisbury. F1 Computer Services have been offering Microsoft courses in Dorset and Hampshire to companies and individuals for over 20 years.