PTR - People, Training ResultsPeople, Training, Results
Independent Technical IT Computer Training Courses

Microsoft Course Index & Training Schedule


More Microsoft Courses

Analyzing Requirements and Defining Microsoft .NET Solution Architectures CourseImplementing Security For Applications CourseMicrosoft Solutions Framework Essentials CourseMicrosoft Excel Macros CourseDeploying & Managing Microsoft Commerce Server 2000 CourseFundamentals of Developing a Business-to-Consumer Solution with Microsoft Commerce Server 2000 CourseDeploying and Managing E-Business Solutions using Microsoft BizTalk Server 2004 CourseBuilding e-Business Solutions with Microsoft BizTalk Server 2004 CourseMicrosoft® Windows® SharePoint® Services 3.0 Level 1 CourseMicrosoft® Windows® SharePoint® Services 3.0 Level 2 CourseMicrosoft® SharePoint® Designer 2007 Level 1 CourseMicrosoft® SharePoint® Designer 2007 Level 2 CourseCustomizing Microsoft SharePoint Products and Technologies 2003 Course


Late Availability Courses:


Training Course Subjects:

Applications Training Courses ASP .Net Courses C Programming Courses Cisco Courses Citrix Courses CIW Courses CompTia Courses Database Courses Exchange Server Courses Fortran Courses Internet Courses ITIL Service Management Courses Java Courses Linux Courses MCSD Courses MCSE Courses Microsoft Courses Microsoft .NET Courses Microsoft Access Courses Microsoft Excel Courses Microsoft Outlook Courses Microsoft Powerpoint & Visio Courses Microsoft Project Courses Microsoft Server Products Courses Microsoft Word Courses Networking Courses Oracle Courses Perl Courses Programming Courses Security Courses SQL Courses SQL Server 2005 Courses SQL Server 2008 Courses Unix Courses VBA Courses Visual Basic Courses Visual Basic 2008 Courses VMWare Courses Web Design Courses Windows 2000 Courses Windows Server 2003 Courses Windows Server 2008 Courses Windows 7 Courses Windows Vista Courses Windows XP Courses XML Courses

Online e-Learning Courses

Scheduled Classroom based Training Courses

Microsoft Access 2000 Level 2 Course

Course Description

Access 2000: Level 2 is a hands-on course that will help you enhance your database designs by using the principles of data normalization and table relationships, querying multiple tables for data used in customized forms and reports, and using data access pages.

Course pre-requisites:

Delegates attending this course should have previously attended the PTR Access 2000: Level 1 course or have equivalent knowledge

What’s Next: Access 2000: Level 2 is the second course in this series. Access 2000: Advanced, the next course in this series, teaches delegates how to use a variety of query techniques, and how to create more efficient forms and reports, and macros. After taking the Advanced course, students who want to learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code can take Access 2000: Introduction to Application Development.

Topics covered on the 2 day Microsoft Access 2000 Level 2 course

Principles of Table Design

  • Normalizing Data
  • Normalizing Data for Fourth and Fifth Normal Forms


  • Principles of Table Relationships

  • Analyzing Table Relationships
  • Establishing and Testing Referential Integrity


  • Table Design Techniques

  • Data Validation Techniques
  • Indexing Techniques


  • Designing Select Queries

  • Using Calculated Fields in Queries
  • Creating Multiple-table Queries


  • Customizing Form Designs

  • Customizing the Form Design
  • Performing Calculations on a Form
  • Adding Combo Boxes to a Form
  • Adding Unbound Controls


  • Working with Data Access Pages

  • Creating Data Access Pages
  • Integrating with Other Applications


  • Customizing Reports

  • Customizing a Report Created by the Report Wizard
  • Working with Subreports
  • Creating a Report in Design View

  • Course Classification: 


    Course Fee = £450   (excl.VAT)

    Scheduled course dates

    September 2010October 2010November 2010December 2010January 2011

    Print / Download PDF Version of full course schedule

    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses

    Access 2003 Training SAVE IT Scheme

    Overview of Microsoft Access