Courses
Courses
Services
Services
About 
About 


Access 2003 Level 2

  Print    

Date Location Duration Cost
29 Sep 2010 (Wed)
30 Sep 2010 (Thu)		 Washington 2 £ 295
08 Nov 2010 (Mon)
09 Nov 2010 (Tue)		 Newcastle 2 £ 295
09 Dec 2010 (Thu)
10 Dec 2010 (Fri)		 Washington 2 £ 295
17 Jan 2011 (Mon)
18 Jan 2011 (Tue)		 Washington 2 £ 295
28 Feb 2011 (Mon)
01 Mar 2011 (Tue)		 Washington 2 £ 295
18 May 2011 (Wed)
19 May 2011 (Thu)		 Newcastle 2 £ 295
07 Jul 2011 (Thu)
08 Jul 2011 (Fri)		 Washington 2 £ 295
15 Aug 2011 (Mon)
16 Aug 2011 (Tue)		 Washington 2 £ 295

Please contact us to discuss private course dates and locations

Course Overview

This course is aimed at people who have used access from a self-taught basis or have been on the level 1 course, but now need to know about the more detailed aspects of access. This course will develop further the advantages of multiple table relational databases.

Prerequisites

Objectives

Follow on Courses

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

Database theory

    Database Normalisation - How to design your tables in an efficient manner to avoid data replication, and ensure good database design.
    What is a relational database?

Tables

    Importing data, from Excel, Access and text files
    Linking data from Outlook or Exchange.
    Converting an Access database to a previous version.
    Customising input masks using your own code, not using the wizard
    How to use lookups when designing your fields in a table
    Format using format codes, how to ensure consistent data entry.
    Indexes, speeding up your database (pros and cons).
    Multiple primary keys, setting more than one field as a primary key

Queries

    Multiple table queries
    Selecting all fields
    Parameter queries, supplying the criteria for a query when you run the query
    Cross tab query. How to display your data in a succinct format.
    Make table query. Make a table from the results of a query.
    Update query. Update values in a table using a queryAppend query. Add the results of a query to a table.
    Delete query. Delete all the records in a table that are displayed by the query
    Relationships in a query and the different types of relationships
    Adding and deleting relationships
    Printing the relationship

Forms

    Creating and modifying forms
    Tab order. Changing the order boxes on a form are selected when the tab key is pressed
    Adding information into the form header and footer area, e.g. date
    Adding information into the page header and footer area, e.g. page number
    Adding text to your form i.e. labels and text boxes
    Description of the form toolbox
    Adding combo and boxes to a form.
    Adding option boxes and yes/no boxes to a form
    Adding pictures or charts to a form
    Using tabs on a form to group information or sub forms.
    Sub Forms and multiple sub forms
    Changing a forms properties using the property sheet.
    Changing the format properties
    Command Buttons using the wizard. Adding a close button, next record etc

Reports

    Creating reports from scratch
    Modifying a report
    Grouping. Grouping information together on a report, e.g. grouping sales data by company.

Data Access Pages

    Using a data access page to view, store or manipulate data in a database
    Creating data access pages in design mode
    Pivot Table reports in Data Access Page mode
    The "New" Database Window
    Creating new Groups and editing others
    Customising its reactions to your actions