Support Computers Teaching Online Word Tutoring DVDs PC Support Support Microsoft Guidance Guidance Programming Guidance Teaching Computers Tutorials Lessons IT Advice
Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Training Certification Help CDs Workstation Education Online Computers DVDs Help Graphics Advice DVDs Microsoft DVDs Education Computer Learning Assistance Notebook CDs

Microsoft Access 97

Microsoft Access 97Microsoft Access 97 Microsoft Access 97
Product Info 210
John Baddeley - access97 - 1
Date Added : 2000-03-31

Price : 99.95
Price : 99.95 Qty
Product Description : To get started, simply click one of the topics below.

Microsoft Access 97

Introduction

Introduction
Design Basics
Example Databases
The 6 Access Objects
One to Many Relationships

Access Basics

Starting Access97
Screen Tips
Keyboard Setup
Accessing Help
Help Menu
The Office Assistant
Setting Option

Table Structure & Data Types

The Structure of a Table
Data Types

Field Properties

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

Working with an Existing DB

Open an Existing Database
Passwords
Relationships
Documenter

Working in DataSheet View

DataSheet View
Sort & Find
Filter by Selection
Filter by Form
Saving a Filter
Navigating DataSheets
Adjust Column Width
Freeze/Unfreeze
Appearance
Data Entry
Delete, Copy, Paste
Printing DataSheets
Save & Close DataSheets

Using Forms

Introduction to Forms
Form Design Basics
Form Types
Form Views
Data Entry using Forms
Printing Forms
Save and Close Forms
Pop-up and Modal Forms

Using Queries

Introduction to Queries
Query Types
Query DataSheet View
Query Design View
SQL View
Saving Queries

Using Reports

Introduction to Reports
Viewing a Report
Report Types
Printing Reports

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

Relationship - Why?
Prerequisites
The Relationships Window
Referential Integrity

Creating Forms

Create Forms Manually
Autoforms
Forms Wizards
Form Design Facilities
Controls Overview
Moving & Sizing Controls
Formatting Controls
Alignment
Add & Delete Controls
Changing Form Size
Headers & Footers
Calculations (1)
Calculations (2)
Calculations(3)
Creating Command Buttons
Add a Combo-box
Create a Main & SubForm

Creating Queries

Introduction 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
Names & Numbers Query
Saving Queries
Parameter Queries
Totals Queries
Expression Builder

Creating Reports

Introduction to Reports
Creating Reports
Report Design View
Sorting & Grouping
More Sorting and Grouping
Layout Problems
Layout Problems, continued
Mailing Labels
Adding Calculated Fields
Adding Group Totals
Adding Sum Totals

External Data

Introduction
Importing Data
Importing from Excel
Mailmerging with Word
Linking/Attaching Tables

Replication

Replication Introduction
Replication Help
Considerations

Security/Backing Up

Security Introduction
Further Information
Everything about backing up

Macros

Macro Introduction
Example Macro
Conditional Macros

Publish on the Web

Introduction
The Web Wizard
View the Web Page

Switchboards

Create a Switchboard
Add Buttons
Improve Appearance