Training Classes   Learn How To  

COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS 2000 LEVEL 2; INTERMEDIATE 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 2000 Level 2; Intermediate




Course Aims
To build on some existing database design and/or user experience that may have been gained from our "Microsoft Access 2000 Level 1; Introduction" course.
Assumed Knowledge
This course assumes some previous experience of database design principles.
Course Audience
People who intend to design databases at intermediate level or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

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

Table of Contents
Action Queries
  		• Types Of Query
  		• The Crosstab Query
  		• The Make Table Query
  		• The Append Query
  		• The Delete Query
  		• The Update Query
     
    Customising Forms
  		• Forms
  		• Using AutoForm
  		• Creating A New Form
  		• Using the Form Wizard
  		• Creating A Form With A Subform
  		• Modifying And Redesigning The Form
     
    Reports
  		• Reports
  		• AutoReport
  		• The Report Wizard
  		• Creating a Report With Calculated Totals
  		• Using the Chart Wizard
  		• Altering the Chart
  		• Using the Label Wizard
  		• Modifying and Redesigning The Report
    Database Replication
  		• What Is Database Replication?
  		• Creating and Maintaining a Replicated Database
  		• Replication Commands
  		• To Replicate The Database With Access
  		• To Use Briefcase To Create A Replica
  		• Synchronisation
  		• Resolving Synchronisation Conflicts
  		• Convert A Replica Set To Access 2000
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Tuesday 22nd May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft