Training Materials for:
  Windows Vista 
  Windows 2000 / XP 
  Microsoft Word
  Microsoft Excel
  PowerPoint XP
  Microsoft Access
  Internet Explorer
  Outlook
  Expression Web
  Microsoft Project
  Microsoft Publisher
  Microsoft FrontPage
  Microsoft Visio
  Computer Concepts

  ECDL / ICDL Downloads
     
      PLUS MANY MORE ...

Microsoft Access 97 Courseware
Foundation Level Training Course

Training Course Outline  

Database design and table creation

• Design and document your database
• Basic design rules
• Determine relationships
• Creating a database
• Using the table wizard
• Adding fields using the table wizard
• Creating a table without a wizard
• Adding fields to a new table
• Field properties
• The input mask property
• Setting a primary key
• Saving a table
• Adding records to a table datasheet

Formatting a table

• Editing records
• Selecting records with the mouse
• Selecting records using the keyboard
• Selecting fields with the mouse
• Selecting columns using the mouse
• Selecting fields and columns using the keyboard
• Deleting records and fields
• Viewing or setting datasheet default values
• Re-ordering columns within a table
• Re-ordering fields in the table
• Changing column width and row height
• Hiding and un-hiding columns
• Freezing columns
• Formatting datasheet cells
• Changing datasheet fonts
• Copying and moving fields and records
• Another look at the database window

Relationships

• Defining relationships
• Opening the relationships window
• Adding tables to the relationships window
• Making relationships
• Referential integrity
• Editing relationships

Locating and replacing information

• A simple search
• Wildcards
• Finding specific values
• Find and replace
• Sorting records
• Sorting records on more than one field
• What is a filter?
• Filtering records by selection
• Filtering records by form

Creating simple queries

• Creating queries, using the simple query wizard
• Creating queries without the wizard
• The query grid
• Logical operators in criteria
• Text in criteria - wildcards
• Multiple criteria and alternative criteria
• Calculated fields
• Summary queries
• Update queries
• Append queries
• Make-table queries

Creating calculated fields

• Creating calculated fields
• Using the expression builder

Introducing forms

• Basic form layout types
• Creating a form
• Different ways of viewing forms

More about creating forms

• Creating forms without using the form wizard
• The form design view window
• Manipulating form design
• Types of control
• The toolbox
• Creating a combo box control
• Changing form properties
• Using forms with Subforms
• Creating a form with a subform
• Controlling data input
• Changing tab order
• Adding command buttons
• Adding page breaks
• Switchboards

Reports

• Creating a report using AutoReports
• Creating reports using the report wizard
• Using the label wizard
• Using the chart wizard
• Grouping levels in reports
• Creating a report without a wizard
• Creating controls
• Setting properties