COURSE SEARCH
 
   HOME > COURSES > ECDL DATABASE WITH MS ACCESS 97 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


ECDL Database with MS Access 97




Course Aims
This course is designed to prepare readers for the ECDL module 5 examination. The course will allow readers to create, update and manage basic databases using Microsoft Access 97. The course closely follows ECDL syllabus version 3.0, but can also be used in conjunction with the earlier syllabus, version 1.5.
Assumed Knowledge
A working knowledge of PCs and Windows is assumed, gained from the workplace or by reading a "Using the Computer and Managing Files" 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 > ECDL > Database

Table of Contents
Getting Started with Access97
  		• Starting Access
  		• Exiting Access
  		• Access 97 Opening Screen
  		• The Title Bar
  		• Menu Bar
  		• Toolbars
  		• Menus and Submenus
  		• SpeedKeys
  		• Dialogue Boxes
  		• Getting Assistance
  		• Wizards
     
    Introduction to Databases
  		• What Are Databases?
  		• Overview of Manual Databases
  		• Comparison with Computerised Databases
  		• What is a Relational Database?
  		• Designing Tables
  		• Primary Keys and Foreign Keys
  		• Main Tasks of a Database
     
    Creating a Database
  		• The Database Window
  		• Creating Table Objects
  		• Table Definition Components
  		• Field Properties
  		• Setting the Primary Key
  		• Saving a Table
  		• Design and Datasheet Views
     
    Modifying Table Structures
  		• Making Changes to Fields
  		• Importing Data
     
    Relating Tables
  		• Using Lookup Fields
  		• Relationships and Referential Integrity
     
    Data Entry
  		• Using Datasheet View
  		• Opening a Database
  		• 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 Columns
  		• Changing the Font of Data in a Datasheet
     
    Searching Tables
  		• The Find Command
  		• Find and Replace
  		• Using Filters
     
    Designing Data Entry Forms
  		• AutoForm
  		• Types of Form
  		• The Form Wizard
  		• Using AutoForm
  		• Working in a Form
  		• Creating a Form Using Multiple Tables
     
    The Form Design Worksurface
  		• The Form Worksurface
  		• The Object Property Sheet
  		• The Field List
  		• Bound and Unbound Controls
  		• Toolbars
  		• The Toolbox
  		• Working with Controls
  		• Formatting Controls
  		• Adding Controls to a Form
     
    Select Queries
  		• What is a Select Query?
  		• What is a Dynaset?
  		• Adding Fields
  		• Moving Fields
  		• Showing Table Names
  		• Criteria
  		• Saving the Query
  		• Summarising Data
     
    Reporting in Access
  		• Printing Tables, Dynasets and Forms
  		• Using AutoReport
  		• Using the Report Wizards
  		• Changing the Design of Existing Reports
  		• Modifying Fields
  		• The Report Bands
     
    Year 2000 Best Practices
  		• Access Database Pivot Years
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Tuesday 7th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft