Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: train 2 gain | itq level 3 | outlook express 2003 | itq level 2 | nvq level 3 courses | nvq 2 | nvq level 4 courses | ilm level 3 certificate in first line management | nvq 2 in care | 6129 level 3
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Access Courses

Microsoft Access 2003 Level 2

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£450 + VAT

Duration:

2 Days

Start:

16/12/2008 calendar
See course programme

Requirements:

To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the ... see more

Request free information

Course objectives:

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new ...

PTR Associates Ltd

PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 2 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new ...
Requirements
To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source: Microsoft Access 2003: Level 1.
Price £450 + VAT
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Access Intermediate
CTS - Computer Training Solutions
Berkshire - £250 + VAT
 
Microsoft Access 2003 Application Development
WWP Training Limited
Berkshire - £650 + VAT
 
Microsoft Access 2003 - Proficient Level to Expert User
focus4training
Online - £24 + VAT
 
Microsoft Access Introduction
Prolog Training
Distance - £300 + VAT
 
Introduction to Microsoft Access
DS Data Training
Berkshire - Price: On request
Compare the selected courses
+ access Courses + Access Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Microsoft Access 2003 Level 2
Course objectives:
As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Course content:
Planning a Database
  • Design a Relational Database
  • Identify Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize the Data
  • Designate Primary and Foreign Keys
    Building the Structure of a Database
  • Create a New Database
  • Create a Table Using a Wizard
  • Create Tables in Design View
  • Create Relationships between Tables
    Controlling Data Entry
  • Restrict Data Entry with Field Properties
  • Create an Input Mask
  • Create a Lookup Field
    Finding and Joining Data
  • Find Data with Filters
  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table
    Creating Flexible Queries
  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries
    Improving Your Forms
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add Command Buttons
  • Create a Subform
    Customizing Your Reports
  • Organize Report Information
  • Set Report Control Properties
  • Control Report Pagination
  • Summarize Information
  • Add a Subreport to an Existing Report
  • Create Mailing Labels
    Expanding the Reach of Your Data
  • Publish Access Data as a Word Document
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 16/12/2008 Finish: 17/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Access

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Access | Courses Database Design | Courses Database training | Courses Microsoft Access XP | Courses Microsoft Office

    Information related to Access

    More related courses
    Access 2002 £75 + VAT Online
    Access 2007 Training £195 + VAT Multimedia
    + access Courses + Access Courses in Berkshire + PTR Associates Ltd Courses
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: microsoft office database design microsoft office specialist
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights