Microsoft Access 2000
Author:Angie Rawling/NMG
Language:english
Category:Business Applications,Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft Access 2000
Microsoft Access 2000 gives you powerful new tools for managing your data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Virtual Training Company's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational database theory. Go through using an existing database, then smoothly into creating a new database and new forms, queries, and reports. Click any of the topics below to get started right away.
Microsoft Access 2000Microsoft Access 2000: Microsoft Access 2000 gives you powerful new tools for managing your data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Discovery Computer Training 's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational database theory. Go through using an existing database, then smoothly into creating a new database and new forms, queries, and reports. Click any of the topics below to get started right awayListed below are all of the chapter and lesson contents for the Microsoft Access 2000 Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Microsoft Access 2000 freely available. Click on any of the linked lesson listings below to preview Free! Microsoft Access 2000
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Access 2000

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

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

01 Introduction
0101 Introduction
0102 Design Basics
0103 Example Databases
0104 The 7 Access Objects
0105 Relationships

02 Access Basics
0201 Starting Access 2000
0202 Screen Tips
0203 Keyboard Setup
0204 Accessing Help
0205 The Office Assistant
0206 Setting Options

03 Table Strcuture and Data Types
0301 The Structure of a Table
0302 Data Types

04 Field Properties
0401 Intro/Field Size
0402 Format
0403 Input Mask
0404 Caption
0405 Default Value
0406 Validation Rule/Text
0407 Required
0408 Indexed
0409 Primary Key

05 Working with an Existing Database
0501 Open an Existing Database
0502 Passwords
0503 Relationships
0504 Documenter

06 Working in Datasheet View
0601 DATASHEET VIEW
0602 Sort & Find
0603 Filter by Selection
0604 Filter by Form
0605 Save a Filter
0606 Navigating Data Sheets
0607 Adjust Column Width
0608 Freeze & Unfreeze
0609 Appearance
0610 Data Entry
0611 Delete, Copy, Paste
0612 Printing Datasheets
0613 Selecting Records To Print

07 Using Forms
0701 Introduction to Forms
0702 Form Design Basics
0703 Form Types
0704 Form Views
0705 Data Entry Using Forms
0706 Printing Forms
0707 Save & Close Forms
0708 Pop-up & Modal Forms

08 Using Queries
0801 Intro to Queries
0802 Query Types
0803 Query Views
0804 Calculation Queries
0805 Saving Queries

09 Usign Reports
0901 Intro to Reports
0902 Viewing a Report
0903 Report Types
0904 Printing a Report

10 Create a New Database
1001 Database Structure
1002 Create a Database

11 Creating Tables
1101 Ways to Create a Table
1102 Creating Fields
1103 Setting Properties
1104 Adding Fields
1105 Setting a Primary Key
1106 Lookup Wizard
1107 Table Wizard
1108 The Contacts Table

12 Setting up Relationships
1201 Relationships - Why?
1202 Prerequisites
1203 The Relationships Window
1204 Referential Integrity

13 Creating Forms
1301 Create Forms Manually
1302 Auto Forms
1303 Form Wizard
1304 Form Design Facilities
1305 Form Controls Overview
1306 Moving & Sizing Controls
1307 Formatting Controls
1308 Alignment
1309 Add & Delete Controls
1310 Changing Form Size
1311 Headers & Footers
1312 Create a Main and Sub-Form
1313 Calculations (1)
1314 Calculations (2)
1315 Creating Command Buttons
1316 Add a Combo Box

14 Creating Queries
1401 Intro to Queries
1402 New Query Options
1403 Query Design View
1404 Adding Fields to QBE Grid
1405 Adding a Table
1406 Running Queries
1407 Sorting in a Query
1408 Entering Criteria
1409 Ranges in Criteria
1410 Tips on Criteria
1411 More Tips on Criteria
1412 AND/OR
1413 Calculated Fields
1414 Saving Queries
1415 Parameter Queries
1416 Totals Queries
1417 Expression Builder

15 Creating Reports
1501 Intro to Reports
1502 Creating Reports
1503 Report Design View
1504 Sorting & Grouping
1505 Layout Problems
1506 Mailing Labels
1507 Adding Calculated Fields
1508 Adding Group Totals
1509 Adding Sum Totals

16 Creating Data Access Pages
1601 Intro to Pages
1602 Creating Pages
1603 Use the Page Wizard
1604 Accessing Data from the Web

17 External Data
1701 Introduction
1702 Importing Data
1703 Importing from Excel
1704 Mail Merging with Word
1705 Linking & Attaching Tables

18 Replication
1801 Replication Overview
1802 Setting Up Replicas
1803 Types of Security
1804 User-Level Security Wizard
1805 Backing Up Data

19 Macros
1901 Introduction
1902 Example Macro
1903 Conditional Macros

20 Switchboards
2001 Create a Switchboard
2002 Add Buttons
2003 Improve Appearance

Sponsors