Database Training Courses
Secretarial Courses

Executive / PA
Medical Secretary
Legal Secretary

OCR / RSA Qualification Courses

OCR / RSA Level 1
OCR / RSA Level 2
OCR / RSA Level 3
OCR / RSA Diploma Courses

Typing

Typing Skills

Applications

Accounts
Databases
DTP / Graphics
Spreadsheets
Word Processing

Please click the links below for more information on the courses that we have available. For additional information click to contact us

 

FD11 - Microsoft® Access – Introduction

Using Microsoft® Access this course is suitable if you have little or no experience of the program.  Please specify version required.

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

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

 

FD12 - Microsoft® Access – Intermediate

Using Microsoft® Access this course is suitable if you are already able to use the functions covered in the introductory course or have a basic knowledge of Microsoft® Access.  Please specify version required.

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

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

 

FD13 - Microsoft® Access – Advanced

Using Microsoft® Access this course is suitable if you are already familiar with the functions covered in the introductory and intermediate courses.  Please specify version required.

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.

Course manual supplied.  Certificate upon completion.

Email the course tutor or telephone 0116 232 5166 for more information.

sage training courses
ms excel training
ms word training
powerpoint training
outlook training
publisher training