Microsoft Access 97
Intermediate Course
This course follows on from the Microsoft Access 97 Beginners Course. As this is not a course for beginners, it is assumed that you have a basic working knowledge of Access and can perform certain elementary tasks. It is designed to guide you through the most important features of the program, using language that is easy to understand and examples that are easy to follow.

Participants will need to prioritise which of the following topics they wish to cover:
  • Database Wizards
  • choosing a style for the screen displays
  • choosing a style for the reports
  • inserting a picture
  • Using The Membership Database
  • using the database window
  • adding a new record
  • filtering/sorting records
  • Creating A Database Table
  • planning your database
  • opening a new database
  • using the table wizard
  • Changing The Table Design
  • creating a input mask
  • copying field properties
  • Entering & Importing Data
  • opening a table
  • entering/importing data
  • Creating A Form
  • autoform
  • adding new records
  • using the form wizard

 
  • Changing The Form Design
  • creating/selecting labels
  • changing/saving colours
  • changing the form width and length
  • selecting several controls at once
  • Adding Tables & Creating Relationships
  • setting up the company type table
  • setting up the origins/status table
  • More About Forms
  • changing the customers form
  • checking the form view
  • adding combo boxes
  • Producing Mailing Labels
  • creating mailing labels for every record
  • the report design
  • creating mailing labels from a query
  • Creating A Switchboard
  • planning/designing the switchboard
  • where is the switchboard?
  • changing the switchboard design
  • Compacting & Deleting A Database
  • compacting/deleting a database
  • compacting/deleting the mailbase database

 
What you already need to know about Access, 

You Should Know How To:

  • Start and exit Access

  • Open and close a database

  • Hide and show the Office Assistant; reset the Office Assistant tips

  • Use the Main Switchboard and Database window to open forms, tables, reports, and queries, as appropriate

  • Use the menus, toolbar buttons and some shortcut key combinations

  • Navigate the database, moving between windows, records and fields

  • Use simple Sort options to order records in a form or a table

  • Change and add records in either a form or a table; delete records

  • Use Filter By Selection to select a sub-set of records

  • Understand the structure of a simple database

  • Work with tables; changing the design, printing the datasheet and using print preview

  • Print a report

  • Understand simple select queries

In this Intermediate Course you will learn to create a database in two ways. First, you will use the Database Wizard to create a membership database. Then you will build a customer database from scratch, creating database objects - tables, forms, reports, etc. - as you require them.

"The sessions will be largely self directed using the latest commercial training manuals, thus allowing you to work at your own pace and cover the topics important to you. You will therefore need to prioritise from this information sheet, prior to the training day, to decide what you want to cover....."

The Trainer/Tutor
Our trainers are all "Quality Assured" and have a wealth of practical experience in the field of computer applications with qualifications to match. We are using the latest in purpose written Information Technology training courseware.

With so much to learn, it's time to get started!

GOOD LUCK!

Back | Register | Home | E-Mail