COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 97 EXPERT USER PART 1 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 Expert User Part 1




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
Relational 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 Best Practice
     
    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 in Access 97
  		• 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
  		• 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
  		• Types of Form
  		• The Form Wizard
  		• Using AutoForm
  		• Working in a Form
     
    Select Queries
  		• What is a Select Query?
  		• What is a Dynaset?
  		• Adding and Moving Fields
  		• Showing Table Names
  		• Criteria
  		• Saving the Query - Creating a Dynaset
     
    Reporting in Access
  		• Printing Tables and Dynasets
  		• Using AutoReport
  		• Using the Report Wizards
  		• Using the Chart and Label Wizards
     
    Year 2000 Best Practices
  		• Year 2000 Best Practices
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 21st November 2009  © COPYRIGHT 2009 - VISUALSOFT