COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 97 ESSENTIALS 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 Essentials




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 a "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
     
    Main Tasks of a Database
  		• Storage of Data
  		• Viewing, Entering and Editing Data
  		• Searching For and Asking Questions Of the Data
  		• Printing Reports
     
    Year 2000 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
    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
     
    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
     
    Reporting in Access
  		• Printing Tables and Dynasets
  		• Using AutoReport
  		• Using the Report Wizards
  		• Changing the Design of Existing Reports
  		• The Report Bands
  		• Mailing Labels
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Sunday 20th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft