COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 97 INTRODUCTION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Access 97 Introduction




Course Aims
MS Access 97 is the latest database from Microsoft designed specifically for a graphical environment. This course is designed to give you an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.
Assumed Knowledge
A working knowledge of PCs and Windows 95/98/NT is assumed, gained from the workplace or by prior attendance on an "MS Windows 95/98/NT User Introduction" course.
Course Audience
New, recent or intending users of Microsoft Access 97 who have little or no existing database knowledge.

This course can be found in the following categories:
Courses > Databases > Access 97
Courses > Microsoft > Office 97
Courses > Microsoft > Access

Table of Contents
Introduction to Databases
  		• What Are Databases?
  		• An Overview of Manual Databases
  		• A Comparison with Computerised Databases
  		• What is a Relational Database?
  		• Designing Tables
  		• Primary Keys and Foreign Keys
     
    Getting Started with Access 97
  		• Starting Access
  		• Exiting Access
  		• Access 97 Opening Screen
  		• The Title Bar
  		• The Menu Bar
  		• Toolbars
  		• Menus and Submenus
  		• SpeedKeys
  		• Dialogue Boxes
     
    Getting Help
  		• The Help Screen
  		• Getting Help while you Work
  		• Wizards
     
    Creating a Database
  		• The Database Window
  		• Creating Table Objects
  		• Table Definition Components
  		• Field Properties
  		• Setting the Primary Key
  		• Saving a Table
     
    Modifying Table Structures
  		• Making Changes to Fields
  		• Linking and Importing Data
  		• Importing Data
     
    Relating Tables
  		• Using Lookup Fields
  		• Relationships and Referential Integrity
     
    Data Entry
  		• Using Datasheet View
  		• Editing Records
  		• Keyboard Commands
  		• Adding a New Record
  		• When Data is Saved
  		• Undoing Changes Made in Error
  		• Copying, Moving and Deleting Data
  		• Deleting a Record
     
    Changing the Look of Data
  		• Freezing and Unfreezing Columns
  		• Sorting By a Column
  		• Changing the Font of Data in a Datasheet
    Searching Tables
  		• The Find Command
  		• Find and Replace
  		• Using Filters
     
    Designing Data Entry Forms
  		• Advantages of Forms in Access
  		• AutoForm
  		• Types of Form
  		• The Form Wizard
  		• Using AutoForm
  		• Working in a Form
  		• Creating a Form Using Multiple Tables
     
    The Form Design Work Surface
  		• The Object Property Sheet
  		• The Field List
  		• Toolbars
  		• The Toolbox
  		• Working in Forms Designer
     
    Select Queries
  		• What is a Select Query?
  		• What is a Dynaset?
  		• Adding Fields
  		• Moving Fields
  		• Showing Table Names
  		• Criteria
  		• Saving the Query - Creating a Dynaset
  		• Summarising Data
  		• Table Joins in Queries
  		• The Different Join Types
  		• Calculated Fields in Queries
  		• Expression Builder
     
    Action Queries
  		• What are Action Queries?
  		• Update Queries
  		• Make Table Queries
  		• Delete Queries
  		• Append Query
     
    Reporting in Access
  		• Printing Tables and Dynasets
  		• Using AutoReport
  		• Using the Report Wizards
  		• Changing the Design of Existing Reports
  		• The Report Bands
  		• Mailing Labels
     
    Year 2000 Best Practices
  		• Year 2000 Best Practices
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 21st November 2009  © COPYRIGHT 2009 - VISUALSOFT