TSC - Access 97: Module II


Prerequisites Completion of Courses: Access 97: Module I or equivalent experience
Duration 6-8 hours
Starting Please call for dates

Course Topics

Working with Queries
  • A Quick Review
  • Creating a Multiple Table Query
  • Creating a Calculated Field
  • Using Expressions
  • Using an IIF Function
  • Summarizing Groups of Records
  • Using Criteria
  • Display Top or Bottom Values
  • Parameter Queries
  • Finding Duplicate Records
  • Finding Unmatched Records
  • Crosstab Queries
  • Delete Queries
  • Append Queries
  • Make Table Queries
  • Update Queries

Working with Forms

  • Creating a Form with AutoForm
  • Modifying a Form
  • Adding & Deleting Fields
  • Moving & Sizing Controls
  • Changing the Tab Order
  • Working with Control Properties
  • Control & Form Property Reference
  • Working with Form Properties
  • Working with Multiple Controls
  • Adding, Cutting, Copying, & Pasting
  • Controls
  • Changing a Controlís Data Source
  • Creating a Calculated Control
  • Changing a Controlís Default Value
  • Using the Control Wizard
  • Creating a Subform
  • Modifying & Working with Subforms

Working with Reports

  • Creating a Report with AutoReport
  • Modifying a Report
  • Adding & Deleting Fields
  • Moving & Sizing Controls
  • Adjusting Page Margins & Orientation
  • Adding Page Numbers & Dates
  • Understanding Report Sections
  • Grouping & Sorting Records
  • Creating Calculated Controls
  • Concatenating or Combining Fields
  • Working with Section Properties
  • Creating Charts with the Chart Wizard
Forrmatting Forms and Reports
  • Formatting Fonts with the Formatting Toolbar
  • Changing Text Alignment
  • Using AutoFormat
  • Changing Colors
  • Applying Special Effects
  • Using the Format Painter
  • Adding Pictures and Lines
  • Aligning Controls
  • Changing a Controlís Formatting Properties

Working with Macros

  • Creating & Running a Macro
  • Editing a Macro
  • Working with Macro Groups
  • Assigning a Macro to an Event
  • Creating Conditional Expressions
  • Assigning a Macro to a Keystroke
  • Combination
  • Macro Action Reference

Working with Other Programs

  • Importing Information
  • Exporting Information
  • Importing Objects from another Access
  • Database
  • Linking Information from an External
  • Source
  • Analyzing Records with Microsoft Excel
  • Exporting Records to Microsoft Word
  • Mail Merging Records to Microsoft Word
  • Using Hyperlink Fields
  • Using OLE Object Fields

For more information call (248) 848-1484 x 100

© 2001 Technical Software Consulting, Inc.