MicroVideo Learning Systems Many Demands. One Solution.
Back

Microsoft Access 97 Learning System

Teach your end-users all aspects of using Microsoft's latest database tool! From creating forms and tables, to creating filters and reports, students will gain vital knowledge of the Access environment. MicroVideo's Access 97 learning system is perfect for a successful migration or implementation to Microsoft's Office 97.

Whether using our video, CD-ROM or Desktop Trainer 3 platform, users will be able to work right along with the program. Built on a video-based platform, all platform versions are fully interactive. The CD-ROM and DT3 versions include unique features such as Bookmarking, Random Access Help Index, and Quizzes, and they operate right on top of the Windows application, so end-users encounter the actual application environment. Note: none of the versions require the software application.


Volume 1
Access Basics
  • What's a database?
  • Launching Access 97
  • Viewing the Office Assistant options
  • Examining the Microsoft Access dialog box
  • Opening an existing database
  • Exploring the Access 97 program window
  • Exploring the Database toolbar
  • Exploring the work area
  • Exploring the status bar
  • Exploring the Database window
  • Opening a table
  • Examining the table window
  • Examining a query object
  • Viewing information in a form
  • Examining a report
  • Examining macros and modules
  • Exiting Access 97
  • Additional Exercises: Using Access Help Features

Working with Tables

  • Opening a database and a table
  • Navigating through a table using the keyboard
  • Using navigation buttons and scroll bars
  • Modifying data in a table
  • Entering data in a table
  • Using the "Undo" feature
  • Deleting data from a table
  • Creating a simple form
  • Arranging open windows
  • Adding a record using a form
  • Interactive exercise #1: Entering data in a table
  • Exiting Access 97
  • Additional Exercises: Deleting and copying records
 Creating a Database
  • Creating and naming a database
  • Planning a database
  • Creating a table
  • Naming fields in Datasheet view
  • Interactive exercise #2: Entering table fields
  • Entering data in a table
  • Interactive exercise #3: Entering a record
  • Saving a table
  • Creating a primary key automatically
  • Displaying a table in Design View
  • Examining the data type column
  • Changing data types
  • Examining field properties
  • Changing a field's text properties
  • Testing field properties
  • Restoring the table window and exiting the program
  • Additional Exercises: Settings Validation Rules

Working with Data

  • Opening a database and table
  • Resizing a column
  • Finding a specific record
  • Sorting records using a single field
  • Sorting records using two fields
  • Creating a filter
  • Removing a filter
  • Creating advanced filters
  • Creating a report
  • Printing a report
  • Saving a report and exiting the program
  • Additional Exercises: Customizing the view of a database
Volume 2
Importing, Linking and Exporting Data
  • Importing data
  • Linking data
  • Linking a table
  • Editing the linked table
  • Importing an Excel 97 workbook
  • The Import Spreadsheet Wizard
  • Exporting a table into Excel 97
  • Viewing the exported Excel file
  • Additional Exercises: Creating a Switchboard

Creating Advanced Queries

  • Viewing multiple tables
  • Using multiple tables in a query
  • Joining tables
  • Creating a Select query
  • Removing fields
  • Adding fields to a query
  • Interactive exercise #1: Adding more fields to the query grid
  • Executing a query
  • Using Multiple criteria in a select query
  • Sorting a field
  • Saving a query
  • Using the NOT operator
  • Creating a Parameter query
  • Additional Exercises: Creating and running an Update query

Customizing Forms

  • Launching Access 97
  • The form design window
  • Using AutoFormat
  • Form structure elements
  • Adding a title header
  • Adding a date
  • Editing a label
  • Customizing labels
  • Interactive exercise #2: Applying effects
  • Moving a label
  • Adding a field
  • Interactive exercise #3: Moving labels and fields
  • Adding a picture to the form
  • Viewing the form
  • Additional Exercises: Creating a Subform
 Customizing Reports
  • The report window
  • Inserting a line in a report
  • Customizing the header
  • Interactive exercise #4: Formatting the title and creating a footer
  • Centering all data
  • Deleting a control
  • Adding a control
  • Deleting a label
  • Grouping data
  • Interactive exercise #5: Creating the category header
  • Viewing the report
  • Additional Exercises: Performing calculations in a report

Automating Your Work

  • Creating a command button
  • The command button wizard
  • Modifying a control
  • Interactive exercise #6: Modifying a command button
  • Creating a macro to run a query
  • Exploring the macro window
  • Viewing the customized form
  • Additional Exercises: Adding a hyperlink to a form
DT3 CD-ROM Video
Training Time 8 - 12 Hours 8 - 12 Hours 4 Hours
Course Materials 1 CD-ROM 4 CD-ROMs 4 Videocassettes
2 Student diskettes
2 Course workbooks
Prerequisites Knowledge of Windows useful but not required

  © Copyright 1998 MicroVideo Learning Systems All Rights Reserved
800.231.4021 / 212.777.9595