DATABASES
Email the course tutor Caron or telephone 0116 232 5166

Click on the course of your choice for details

Distance Learning / Home Study
Choose to learn at home at times to suit you

• FD11 - Microsoft^® Access - Introduction

• FD11i - Microsoft^® Access - Intermediate

• FD17 - Microsoft^® Access - Advanced

• 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 Caron 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.

Certificate upon completion.

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 Caron 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.

Certificate upon completion

For more information please email the course tutor Caron 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 Caron 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.

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.
 

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.

Email the course tutor Caron or telephone 0116 232 5166

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. 
Email the course tutor Caron 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.

Certificate upon completion