Access 2000 - Introduction

Introduction to database concepts

·          What is a database?

·          Tables and relationships

·          The Access application window

Database design and table creation

·          Design and document your database

·          Define your needs

·          Basic design rules

·          Determine relationships

·          Creating a database

·          Using the table wizard

·          Adding fields using the table wizard

·          Creating a table without a wizard

·          Adding fields to a new table

·          Field properties

·          The input mask property

·          Setting a primary key

·          Adding records to a table datasheet

Formatting a table

·          Editing records

·          Selecting records, fields and columns

·          Deleting records and fields

·          Viewing or setting datasheet default values

·          Re-ordering columns and fields

·          Changing column width and row height

·          Hiding and un-hiding columns

·          Freezing columns

·          Formatting datasheet cells

·          Changing datasheet fonts

·          Copying and moving fields and records

·          Printing

Relationships

·          Defining relationships

·          Opening the relationships window

·          Adding tables to the relationships window

·          Making relationships

·          Referential integrity

·          Editing relationships

Locating and replacing information

·          A simple search

·          Wildcards

·          Finding specific values

·          Find and replace

·          Sorting records

·          What is a filter?

·          Filtering records

Creating simple queries

·          Opening an existing query

·          Creating queries

·          The query grid

·          Logical operators in criteria

·          Text in criteria - wildcards

·          Multiple criteria and alternative criteria

·          Calculated fields

·          Summary queries

·          Update queries

·          Append queries

·          Make-table queries

Creating calculated fields

·          Creating calculated fields

·          Using the expression builder

Introducing forms

·          Basic form layout types

·          Creating a form using autoform

·          Creating a form using the form wizard

·          Different ways of viewing forms

More about creating forms

·          Creating forms without using the form wizard

·          The form design view window

·          Manipulating form design

·          Types of control

·          The toolbox

·          Creating a combo box control

·          Changing form properties

·          Using forms with subforms

·          Creating a form with a subform

·          Controlling data input

·          Changing tab order

·          Adding command buttons

·          Adding page breaks

·          Switchboards

Reports

·          Opening and viewing existing reports

·          Printing reports

·          Creating a report using autoreports

·          Creating reports using the report wizard

·          Using the label wizard

·          Using the chart wizard

·          Grouping levels in reports

·          Creating a report without a wizard

·          Creating controls

·          Setting properties

• Introduction

• Intermediate

• Advanced

Excel 2000

• Introduction

• Intermediate

• Advanced

Word 2000

• Introduction

• Intermediate

• Advanced

PowerPoint 2000

• Introduction

• Intermediate

Windows

• 2000 Foundation

• 2000 Intermediate

• 98 - Foundation

• 98 - Intermediate

• 98 - Update

Miscellaneous

• Project

• Publisher

• FrontPage

• Outlook

Office 97

• List of office 97 Courses