COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 97 ADVANCED 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 Advanced




Course Aims
This intensive course is designed to give existing users of Access for Windows 97 an insight into some of the more advanced features in Access. This entirely 'hands on' course will give readers a further understanding of database design principles, advanced forms, reports and query design, including using calculations. It will also show customisation of the database through command buttons, macros and customised menus, and Internet publishing.
Assumed Knowledge
A basic knowledge of Microsoft Access for windows gained through use of the product or by studying an introduction course for Microsoft Access.
Course Audience
Existing users of Microsoft Access for windows who want to design and customise databases.

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

Table of Contents
Building a Relational Database
  		• Designing a Relational Database
  		• Normalisation of Data
  		• De-Normalisation
  		• Primary and Secondary Keys
  		• Setting up Indexes
  		• Creating an Index
  		• Multiple Field Indexes
  		• Maintaining Data Integrity
  		• Setting Field Properties
  		• Using Validation Rules
  		• Setting Table Relationships
  		• Creating Input Masks
  		• Using Lookup Fields
  		• An Example Relational Model
  		• Types of Relationship Links
  		• Primary and Foreign Keys
  		• Relationships and Referential Integrity
     
    Creating Relational Queries
  		• Working with Related Tables in Queries
  		• Setting Joins Types in Queries
  		• Find Unmatched Query
  		• Find Duplicates Query
     
    Calculating in Queries
  		• Summary Queries
  		• Crosstab Queries
     
    Advanced Forms Features
  		• Using Advanced Forms Features
  		• Multi-Table Forms
  		• The Form Worksurface
  		• The Toolbox
  		• Bound and Unbound Controls
  		• Creating a Calculated Control
  		• The Expression Builder
     
    Producing Reports
  		• Creating Reports
  		• Applying Sorting and Grouping to Reports
  		• Performing Calculations on Reports
  		• Creating Custom Report Pages
  		• Using the Chart Wizard
  		• Using the Label Wizard
    Importing, Exporting, and Attaching Data
  		• Importing Data
  		• Attaching Data
  		• Exporting Data
     
    Action Queries
  		• Action Queries
  		• Make Table Queries
  		• Append Queries
  		• Delete Queries
  		• Update Queries
     
    Customizing Menus and Toolbars
  		• Creating Custom Menus and Toolbars
  		• Customizing Menus and Toolbars
     
    Macros and Command Buttons
  		• Creating a Macro
  		• Macro Examples
  		• Designing Application Menus
  		• Creating a Menu Form
  		• Setting Start-up Defaults
     
    Hyperlinks and Internet Publishing
  		• Using Hyperlinks and Publishing on the Internet
  		• Using Hyperlinks in Tables and Forms
  		• Publishing Data on the Internet
     
    Database Management Tools
  		• Database Management
  		• Setting a Database Password
  		• Encrypting and Decrypting a Database
  		• Compacting a Database
  		• Repairing a Database
     
    Multi-User Databases
  		• Shared Databases
  		• Setting Default Locking Properties
  		• Creating Groups and Users
  		• Setting User Permissions
  		• Assigning Ownership
     
    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