ms access 2000 tutorial training course online
ms access
2000 tutorial

MS Access 2000 Tutorial

High quality microsoft access tutorial online course to help achieve your tutorial goals conveniently Anytime, Anywhere!. No parking hassles, no missed assignments, and nothing to install. 12-months of learning.

Microsoft Access Tutorial - Relationships & Queries shows users how to establish table relationships perform join operations and define and execute queries in Access 2000 Affordable annual subscription plans give you 12 months of unlimited access to tutorials at price that you just won't find anywhere else.

Relationship and Queries

Building the Forms

Producing Reports

Advanced Tasks

Modifying Tables

Sorting and Filtering

Creating Database

Building Tables


Microsoft Access
Training Courses
Info and Order


Online Microsoft access 2000 tutorial is empowering, engaging and cost-effective. It's done entirely over the internet. It's learning that can be taken anytime, anywhere. Most importantly, it works.

Access 2000 Tutorial Objectives

  • Define table relationships
  • Display related records
  • Specify query criteria
  • Create calculated fields
  • Create and modify multi-table queries

Topics

  • Establishing Table Relationships
    • Creating table relationships
    • Applying relationships
    • Defining relationship types
    • Using joins

  • Managing Table Relationships
    • Enforcing referential integrity
    • Cascading options
    • Printing database relationships

  • Displaying Related Records
    • Displaying records in a subdatasheet
    • Expanding and collapsing subdatasheets

  • Specifying Query Criteria
    • Defining a query
    • Establishing a query
    • Using expressions
    • Applying a query

  • Creating Calculated Fields
    • Calculating statistical information
    • Adding summary information
    • Defining formulas

  • Using Multi-Table Queries
    • Creating a multi-table select query
    • Using the Simple Query Wizard

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

If you are looking to learn new IT skills to aid in your current job, increase your chances of finding that perfect job or just to learn for personal use, then our courses are just what you have been looking for. We have hundreds of professionally developed online IT and Softskills courses available for a wide range of skill levels. Gain access to a wealth of IT and Softskills content aimed at all audiences from Beginners through to Intermediate and Advanced users in many areas. Access over 35,000 pages available in a structured, easy to learn system. Each course has been professionally developed by Courseware provider that have years of experience in their subject field.

Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.