Microsoft Access 2000 Tutorial Try for FREE

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Access 2000 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Introduction to tutorials

• Introduction Demo
• Design Basics Demo
• Example Databases Demo
• The 7 Access Objects Demo
• Relationships Demo

Access Basics

• Demo

• Starting Access 2000 Demo
• Screen Tips Demo
• Keyboard Setup Demo
• Accessing Help Demo
• The Office Assistant Demo
• Setting Options Demo

Table Strcuture and Data Types

• The Structure of a Table Demo
• Data Types Demo

Field Properties

• Intro/Field Size
• Format
• Input Mask
• Caption
• Default Value
• Validation Rule/Text
• Required
• Indexed
• Primary Key

Working with an Existing Database

• Open an Existing Database
• Passwords
• Relationships
• Documenter

Working in Datasheet View

• DATASHEET VIEW
• Sort & Find
• Filter by Selection
• Filter by Form
• Save a Filter
• Navigating Data Sheets
• Adjust Column Width
• Freeze & Unfreeze
• Appearance
• Data Entry
• Delete, Copy, Paste
• Printing Datasheets
• Selecting Records To Print

Using Forms

• Introduction to Forms
• Form Design Basics
• Form Types
• Form Views
• Data Entry Using Forms
• Printing Forms
• Save & Close Forms
• Pop-up & Modal Forms

Using Queries

• Intro to Queries
• Query Types
• Query Views
• Calculation Queries
• Saving Queries

Usign Reports

• Intro to Reports
• Viewing a Report
• Report Types
• Printing a Report

Create a New Database

• Database Structure
• Create a Database

Creating Tables

• Ways to Create a Table
• Creating Fields
• Setting Properties
• Adding Fields
• Setting a Primary Key
• Lookup Wizard
• Table Wizard
• The Contacts Table

Setting up Relationships

• Relationships - Why?
• Prerequisites
• The Relationships Window
• Referential Integrity

Creating Forms

• Create Forms Manually
• Auto Forms
• Form Wizard
• Form Design Facilities
• Form Controls Overview
• Moving & Sizing Controls
• Formatting Controls
• Alignment
• Add & Delete Controls
• Changing Form Size
• Headers & Footers
• Create a Main and Sub-Form
• Calculations (1)
• Calculations (2)
• Creating Command Buttons
• Add a Combo Box

Creating Queries

• Intro to Queries
• New Query Options
• Query Design View
• Adding Fields to QBE Grid
• Adding a Table
• Running Queries
• Sorting in a Query
• Entering Criteria
• Ranges in Criteria
• Tips on Criteria
• More Tips on Criteria
• AND/OR
• alculated Fields
• aving Queries
• Parameter Queries
• Totals Queries
• Expression Builder

Creating Reports

• Intro to Reports
• Creating Reports
• Report Design View
• Sorting & Grouping
• Layout Problems
• Mailing Labels
• Adding Calculated Fields
• Adding Group Totals
• Adding Sum Totals

Creating Data Access Pages

• Intro to Pages
• Creating Pages
• Use the Page Wizard
• Accessing Data from the Web

External Data

• Introduction
• Importing Data
• Importing from Excel
• Mail Merging with Word
• Linking & Attaching Tables

Replication

• Replication Overview
• Setting Up Replicas
• Types of Security
• User-Level Security Wizard
• Backing Up Data

Macros

• Introduction
• Example Macro
• Conditional Macros

Switchboards

• Create a Switchboard
• Add Buttons
• Improve Appearance