Microsoft Access 2000 Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'I have been using your 'Photoshop CD to demonstrate Photoshop technique to my students. I have been encouraging them to purchase it on their own, as I believe it to be an excellent training instrument, and the best instructional CD on this subject to date. Not only is it well-thought out and presented clearly, but it is also a bargain.
  Joe Doyle
  Vista Community College, Berkeley, CA ;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Topics covered on this Tutorial Video
are Listed Below:-

Introduction

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

Access Basics

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

Table Strcuture and Data Types

• The Structure of a Table
• Data Types

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 99.95

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
• Calculated Fields
• Saving 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

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft Access 2000 Training - VIDEO INFO

TitleMicrosoft Access 2000

TutorAngie Rawling/NMG

Duration12 hours - 132 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33106