PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   

Microsoft Course Index & Training Schedule


More Microsoft Courses

Microsoft Solutions Framework Essentials CourseMicrosoft Excel Macros CourseImplementing Security For Applications CourseAnalyzing Requirements and Defining Microsoft .NET Solution Architectures 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 CourseMicrosoft SharePoint Designer 2010 Level 1 CourseMicrosoft SharePoint Designer 2010 Level 2 Course


Late Availability Courses:

Training Course Subjects:

Applications Training Courses C Programming 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 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 Visual Studio Courses Visual Studio 2008 Courses Visual Studio 2010 Courses VMWare Courses Web Design 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.
 £450

2 day course

Scheduled Dates:

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



    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

    Overview of Microsoft Access