DATABASES
Email the course tutor Jacky or telephone 0116 232 5166

Click on the course of your choice for details

ONE DAY COURSES

• FD11 - Microsoft^® Access - Introduction

• FD11i - Microsoft^® Access - Intermediate

• FD17 - Microsoft^® Access - Advanced

LESSONS AT TIMES TO SUIT

• C16 - Database For Beginners

• C17 - Database - Advanced

FD11 - Microsoft^® Access - Introduction

Using Microsoft^® Access version 97, 2000,  XP or 2003, this course is suitable if you have little or no experience of the program.
Email the course tutor Jacky or telephone 0116 232 5166

Topics may be tailored and include:

Introduction; Getting Started; Creating Databases; Creating and Saving Tables; Creating and Modifying Field Definitions; Entering, Editing and Saving Data; Navigating the Database; Adding and Changing Records; Filtering Records; Creating Different Types of Queries; Printing; Understanding the Database; More about Queries; Report Wizards; Form Wizards; Managing a Database.

1 Full Day 9.30 am to 4 pm - Certificate upon completion
Also available as a longer course at times to suit - see C16.

FD11i - Microsoft^® Access - Intermediate

Using Microsoft^® Access version 97, 2000, XP or 2003, this course is suitable if you are already able to use the functions covered in the introductory course.
Email the course tutor Jacky or telephone 0116 232 5166

Topics may be tailored and include:

Introduction; Creating a New Database.  Using Wizards. Adding Fields and Including Sample Data.  Choosing a Style for Screen Displays and Reports.   Inserting Pictures. Changing and Adding Records. Creating Input Masks.   Sorting and Filtering Records. Creating Tables and Defining Fields. Adding Primary Keys. Changing Table Designs. Copying Field Properties. Adding Date Fields.  Entering and Importing Data. Choosing the Data Source; Choosing Where to Store the Data. Creating Forms. Using AutoForm and Form Wizards.  Sorting Records.  Changing Form Designs.  Moving Fields. Creating New labels.  Changing Colours.  Changing Form Width and Length. Adding and Changing Form Controls. Adding Combo Boxes. Adding Tables and Creating Relationships. Producing Mailing Labels. Changing Report Designs.   Using The Trim Function and the Can Shrink and Grow Property. Creating a Switchboard.  Adding a Picture.  Changing the Colour Scheme. Compacting and Deleting a Database.

2 Full Days 9.30 am to 4 pm - Certificate upon completion

Tutor led training in a very small group of a maximum of 6 people.  For more information please email the course tutor Jacky or telephone 0116 232 5166.  Course manuals and certificates supplied.

FD17 - Microsoft^® Access - Advanced

Using Microsoft^® Access version 97, 2000,  XP or 2003, this course is suitable if you are already familiar with the functions covered in the introductory and intermediate courses.
Email the course tutor Jacky or telephone 0116 232 5166

Topics may be tailored and include:

Introduction. Compacting Sample Databases.  Forms and Subforms.  Form Views.  Checking Form Designs and Opening Property Sheets. Changing Design to Continuous Forms or Datasheet View. Creating Subforms. Navigating and Editing the Main Forms and the Subforms. Adding Data to a Form with Subforms. Using the Form and Subform Wizard.  Linking a Different Subform.   Adding Expressions.  Using the Expression Builder. Calculating Totals in a Subform.  Displaying Totals in the Main Form. Adding New Transaction Records. Creating Calculations in Queries. Parameter Queries. Crosstab Queries. Creating Append and Delete Queries.  Removing Duplicate Records. Using Aggregate Functions with Calculated Fields. Using Dates in a Query. Using Wildcards. Using Several Parameters. Backing up Tables. Creating Reports. Report Design. Grouping and Sorting.  Adding Pictures.  Using Expressions in Reports.  Creating Running Totals.  Adding a Bound Text Box.  Autofitting Labels.  Parameters in Reports.  Creating a Subreport. Creating Command Buttons.  Creating a Print Labels Button.  Events and Macros.  Creating and Running a Macro.  Using a Macro to Update Fields. The AutoExec Macro.  The Verification Macro.  Conditional Macros.  MailMerge.   Linking a Database Table to an Existing Document.  Entering Merge Fields.   Merging to a Printer.  Changing and Editing the Data Source.  Merge Options in Word.

2 Full Days 9.30 am to 4 pm - Certificate upon completion

C16 - Database For Beginners

Using Access version 97, 2000, XP or 2003 this course is suitable for absolute beginners who have some experience of other programs. Also available as a distance learning / home study course.  
Email the course tutor Jacky or telephone 0116 232 5166

Introduction; Getting Started; Creating Databases; Creating and Saving Tables; Creating and Modifying Field Definitions; Entering, Editing and Saving Data; Navigating the Database; Adding and Changing Records; Filtering Records; Creating Different Types of Queries; Printing; Understanding the Database; More about Queries; Report Wizards; Form Wizards; Managing a Database.

5 Lesson Certificate Course - Total of 10 hours - Certificate upon completion
Attend at times to suit you, possibly daily for 1 week or once a week for 5 weeks.

C17 - Database - Advanced

Progressing from the beginners course to the advanced features required to create complex relational database structures using Microsoft^® Access version 97, 2000,  XP or 2003.  Also available as a distance learning / home study course.  
Email the course tutor Jacky or telephone 0116 232 5166

Topics include:

Introduction. Compacting Sample Databases.  Forms and Subforms.  Form Views.  Checking Form Designs and Opening Property Sheets. Changing Design to Continuous Forms or Datasheet View. Creating Subforms. Navigating and Editing the Main Forms and the Subforms. Adding Data to a Form with Subforms. Using the Form and Subform Wizard.  Linking a Different Subform.  Adding Expressions.  Using the Expression Builder. Calculating Totals in a Subform.  Displaying Totals in the Main Form. Adding New Transaction Records. Creating Calculations in Queries. Parameter Queries. Crosstab Queries. Creating Append and Delete Queries.  Removing Duplicate Records. Using Aggregate Functions with Calculated Fields. Using Dates in a Query. Using Wildcards. Using Several Parameters. Backing up Tables. Creating Reports. Report Design. Grouping and Sorting.  Adding Pictures.  Using Expressions in Reports.  Creating Running Totals.  Adding a Bound Text Box.  Autofitting Labels.  Parameters in Reports.  Creating a Subreport. Creating Command Buttons.  Creating a Print Labels Button.  Events and Macros.  Creating and Running a Macro.  Using a Macro to Update Fields. The AutoExec Macro.  The Verification Macro.  Conditional Macros.  MailMerge.   Linking a Database Table to an Existing Document.  Entering Merge Fields.   Merging to a Printer.  Changing and Editing the Data Source.  Merge Options in Word.

5 Lesson Certificate Course - Total of 10 hours - Certificate upon completion
Attend at times to suit you, possibly daily for 1 week or once a week for 5 weeks.

Home | About KeyNet | Courses | Information | Enrolment | Form

Copyright © 1999 KeyNet - Website built by Keynet Internet Services