COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 97 DATABASE AND FILING SYSTEMS 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 Database and Filing Systems




Course Aims
This course is designed to give you an understanding of some of the major features and functions within Access 7.0 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 is assumed, gained from the workplace or by prior attendance on a " Using the Computer and Managing Files " course.
Course Audience
New, recent or intending users of Microsoft Access 7.0 who have little or no existing database knowledge.

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

Table of Contents
Database Basic Level Driving Test
  		• Database Basic Level Driving Test
     
    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
     
    The Course Database
  		• The Course Database
     
    Year 2000
  		• Access Database Pivot Years
     
    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
  		• Creating a New Database and Table
     
    Modifying Table Structures
  		• Making Changes to Fields
  		• Importing Data
  		• Importing Tables
  		• Modifying the Table Structure
     
    Relating Tables
  		• Using Lookup Fields
  		• Relationships and Referential Integrity
  		• Setting Up Table Relationships
     
    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
  		• Working with Data in a Table
    Changing the Look of Data
  		• Freezing and Unfreezing Columns
  		• Sorting By a Column
  		• Changing the Font of Data in a Datasheet
  		• Changing the Layout of a Table
     
    Searching Tables
  		• The Find Command
  		• Find and Replace
  		• Using Filters
  		• Using the Find Command
  		• Find and Replace Text
  		• Filtering Records
  		• Completing the Products and Categories Tables
     
    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
  		• Creating Forms
     
    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
  		• Single Table Queries
     
    Reporting in Access
  		• Printing Tables, Dynasets and Forms
  		• Using AutoReport
  		• Using the Report Wizards
  		• Reporting
     
    Year 2000 Best Practices
  		• Year 2000 Best Practices
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Thursday 17th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft