Courses
Courses
Services
Services
About 
About 
Home
FAQs
Mobile Site | Phone 0191 377 8377  |   Email Us 
Stay up to date with special offers

Click here to enquire online

Click here to contact us
  

"Really good course, will definitely recommend, learned exactly what I needed to!!"
R. Swales, Stockton Borough Council

"Friendly warm atmosphere with well thought out course presentation"
A. Davey, Conmech Engineers Ltd

"Felt relaxed and not worried about keeping up"
J. Robson, Red House Academy

"Course delivered to suit the needs of all individuals" R. Teeley, Studsvik UK

"Excellent, flexible so was made very relevant to my work situation"
R. Tunstall,
Homes for Northumberland Ltd

"Very useful and informative, good trainer"
A. Tunstall,
St Aidan's School

"Training facilities were good and good selection of biscuits!"

"Very good way to teach. Nice mix of theory and practice"
K. Ferguson, Durham University


Access 2003 Level 3

  Print    

Date Location Duration Cost
08 Sep 2010 (Wed)
09 Sep 2010 (Thu)		 Washington 2 £ 395
16 Nov 2010 (Tue)
17 Nov 2010 (Wed)		 Washington 2 £ 395
14 Dec 2010 (Tue)
15 Dec 2010 (Wed)		 Newcastle 2 £ 395
23 Feb 2011 (Wed)
24 Feb 2011 (Thu)		 Washington 2 £ 395
25 Apr 2011 (Mon)
26 Apr 2011 (Tue)		 Washington 2 £ 395
26 May 2011 (Thu)
27 May 2011 (Fri)		 Washington 2 £ 395
13 Jul 2011 (Wed)
14 Jul 2011 (Thu)		 Washington 2 £ 395

Please contact us to discuss private course dates and locations

Course Overview

This course is for delegates who already have sound skills in the use of Access and are now ready to expand their knowledge into some of the more specialised and advanced functions of the software. This course will provide delegates with skills to be able to create complex queries, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications. This course is ideal for those who are responsible for structuring data into properly designed tables, analysing data and automating tasks using Access, as well as producing advanced report outputs. This course will also look at using Data Access Pages as a means of accessing data on a corporate network.

Prerequisites

Objectives

Related Courses

Training Options

  • Scheduled public courses at one of our training venues
  • Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
  • Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • For further information please contact us on 0191 377 8377

What's Included

  • 1 delegate per computer
  • Telephone and email support
  • Relaxed refreshment area at our training venues
  • Lunch and refreshments when training is delivered at our training venue
  • Comprehensive course manual and exercises

Course Content

Importing Data

    Designing Select Queries

      Queries with calculated fields
      How to format a field in a query

    Creating Multiple Table Queries

      Selecting your Tables
      Description of the type of Joins in a Query
      Changing the Properties of a Join in a query
      Performing Group and Total Calculations
      Entering a criteria with a Group and Totals Query
      Querying for Unique Values
      Parameter Queries
      How to create a parameter query

    Action Queries

      Cross-Tab Query
      Make-Table Query
      Update Query
      Append Query
      Delete Query
      Pass-Through Query
      Data Definition Query
      Find Duplicates/Unmatched Query

    Enhanced Form Design

      Customising the Form design
      The ToolBox
      Adding Fields to a form
      Adding Calculated Controls
      Aligning Objects on a form
      Moving a Control
      Adding Combo Boxes and List Boxes to a Form
      Adding Unbound Controls
      Applying Colour
      Changing the Tab Order
      Adding a Tab Control

    Subform Design

      What are Subforms?
      Creating a form that contains a subform
      Changing the links between a Main Form and a Sub Form
      Editing a Subform
      Using the Form Wizard to create a form that contains a subform

    Customising Reports

      Customising a report created by the report wizard
      How a report is printed
      How to add an extra band to a report
      How to add a field to a report
      Customising a report
      Adding Subreports to a Report
      Creating a Chart or Labels Report
      Using AutoReport with Report Wizard

    Data Access Pages

      How to create a Data Access Page
      Autopage: Columnar
      The Page Wizard
      Viewing/using Pages with Grouping
      Using the Sort Facility on a Data Access Page
      Using a Filter on a Data Access Page
      Existing Web Page
      Design View
      How to edit the design of your Data Access Page
      Adding text or pictures to the page
      Adding, editing and aligning Controls on your Data Access Page
      How to add a pivot table
      How to add a Spreadsheet
      How to add a Chart
      Other Data Access Page Tools

    Advanced Form Design

      Unbound Forms
      Using Command Buttons
      Passing Values to Queries
      The Expression Builder
      Events on Forms - Macros
      Different Events on Forms

    Macros

      What is a macro?
      How to create a new macro.
      The MsgBox Macro
      Using Macros in Forms
      Passing values between Forms
      Custom Toolbars
      Editing the button on the toolbar
      To remove an icon from the toolbar
      Custom Menus
      To create a menu bar
      Attaching Toolbars and menu bars to objects
      The AutoExec Macro or Startup Options
      Changing the splash screen for your application
      Keyboard Shortcuts to run macros

    Database Utilities

      Compact and Repair Database
      Make MDE file
      Converting Access to previous versions

    Security In Access

      Setting a password to open a database

    Creating of a number of databases