Home Products Skill Assessment Contact Us Become a Reseller Enterprise License

Call Us at 317-881-3826

Or

Click here:

Chat Live: Instant Message  

USING ACCESS 97
INTRODUCTION

Netscape 4.05 & earlier & Microsoft IE 4.5 for Macintosh Y2K Browser Bug

Access 97 Data Basics

  • Explaining What Is A Database
  • Basic Database Terminology
  • Description of Tables
  • Discussion About Fields
  • Discussion About Queries
  • Discussion About Forms
  • Discussion on Reports
  • Discussion On Relationships
  • Closing Comments

Getting Started With Access

  • Opening Microsoft Access 97
  • Opening An Existing Database
  • The Access Application Window
  • View Options
  • Viewing Existing Tables
  • Navigating Within Tables
  • Records
  • Navigating Between Records
  • Adding Records In Datasheet View
  • Working With Fields
  • Sorting Records By Field
  • Switching Between Tables
  • Embedded Images
  • Changing Object Views
  • A Queries Overview
  • The Select Query
  • Viewing Forms
  • Using A Form
  • Adding A Record In Form View
  • The Reports Tab
  • Opening A Report
  • Zooming In On A Report
  • Closing A Report
  • Viewing Multiple Pages
  • Macros
  • Modules
  • The Access Help System
  • Help’s What’s This Option
  • Help’s Content And Index
  • Help’s Contents Features
  • Help’s Index Feature
  • The Glossary
  • Closing Help

Creating A New Database

  • Creating An Access Shortcut
  • Creating A Blank Database
  • Filing Options
  • Access 97 Options
  • Creating A New Table
  • The Table Wizard
  • Adding Fields
  • Removing Fields
  • Renaming A Field
  • The Auto Number Feature
  • Design View
  • Auto Number Variables
  • Printing Your Table
  • Importing Data
  • Resizing Table Columns

Working with Forms And Data

  • The Open Database Button
  • Renaming The Database
  • Importing Existing Tables
  • Showing Relationships
  • Importing Multiple Objects
  • Using The Autoform Wizard
  • Adding Fields To A Form
  • Removing Fields From A Form
  • Selecting Form Style
  • Navigating Data In Form View
  • Switching To Datasheet View
  • Adding Records In Form View
  • Editing Records In Form View
  • Editing Data In Datasheet View
  • Using The Find Dialog Box
  • Deleting Records In Form View
  • Modifying Datasheet View
  • Moving Fields In Datasheet View
  • Sorting Records In Datasheet View
  • Sorting In Form View / Exiting Access 97
  • Closing The Microsoft Office Shortcut Bar

Simple Filters And Queries

  • Creating A Selection Filter
  • Applying A Selection Filter
  • Removing A Filter From A Table
  • Applying A Selection Filter Using The Shortcut Menu
  • Removing A Filter Using The Shortcut Menu
  • Filter By Excluding Selection
  • Filtering For
  • Using Queries
  • Creating A Query
  • Using The Simple Query Wizard
  • Displaying Multiple Datasheets Simultaneously
  • Modifying A Query
  • The Query Design Window
  • Creating A Calculated Field
  • Adding A Field To A Query
  • Using A Numeric Expression In A Query
  • Hiding Fields In A Query

Introduction To Reports

  • Creating A Tabular Report
  • Viewing Your Report
  • The Report Design View
  • Adding A Field To A Report
  • Binding A Field To A Text Box
  • Grouping Fields In A Report
  • Creating A Group Header
  • Formatting A Group Header
  • Creating Multiple Groups
  • Printing Your Report
 
© Copyright PCPAL Solutions, Inc. and New Century Marketing Concepts