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 4 Application Development Course

Course Description

Access 2000: Introduction to Application Development is a hands-on instruction book that will guide you through the process of developing an application by using one or more Access 2000 databases.

Course pre-requisites:

Access 2000: Introduction to Application Development is for the delegate who is proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who needs to draw on all these skills and add code to create an application. The prerequisite PTR courses for this course are:
  • Access 2000: Level 1
  • Access 2000: Level 2
  • Access 2000: Advanced

    • Topics covered on the 2 day Microsoft Access 2000 Level 4 Application Development course

    Application Design Concepts

  • Planning an Application
  • Moving through a Completed Application
  • Developing a Distributed Application Design


    • Adding Command Buttons to Guide User Navigation

  • Using One Form for Two Purposes: To Add or Edit Records


    • Automating a Dialog Box Form with a Macro Group

  • Creating a Macro Group
  • Customizing an Unbound Form to Behave like a Dialog Box
  • Documenting a Macro Group


    • Creating a Switchboard Form

  • Using the Switchboard Manager
  • Setting Database Startup Properties


    • Working with Command Bars: Toolbars and Menus

  • Using a Macro Group to Show and Hide a Toolbar
  • Creating a Custom Menu Bar and Shortcut Menu for a Form
  • Startup Properties for Toolbars and Menu Bars


    • Creating a Splash Screen Form

  • Creating a Form as a Splash Screen
  • Automating the Splash Screen Form by Using Visual Basic Code
  • Modifying Startup Properties to Display a Splash Screen Form
  • Documenting the Application


    • Using Visual Basic Procedures

  • Creating a Public Function
  • Adding General Procedures in a Form Module
  • Creating Event Procedures
  • Viewing a Live Web Site on a Form


    • Adding Security to an Application

  • Security Overview
  • Steps to Securing a Database by Using User-level Security
  • Documenting Database Security
  • Securing a Database with a Database Password
  • Distributing the Secured Application


    • Appendix A: APP.MDB Diagrams

  • Book Invoice Application
  • Access Application


    • Appendix B: Planning an Application

  • Planning an Application


    • Appendix C: Importing Spreadsheets, Databases, and Delimited Text Files

  • Importing and Linking Data from Spreadsheets
  • Importing and Linking Database Files
  • Importing Text Files


    • Appendix D: Securing Your Database Using the Access 2000 Security Wizard

  • A Summary of Using the Access 2000 Security Wizard

    • 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