Everything Desktop Training

Investing in employee training today means success tomorrow. Take advantage of our best-of-breed training for Microsoft Office applications, operating systems and basic PC skills and improve workforce performance.

Our curriculum combines proven instructional design techniques, realistic simulation and unparalleled interactivity with challenges, tests and feedback. Master the world's leading productivity tools today

Microsoft Access 97 Training

Access 97 Training provides the learner with the fundamental concepts and basic skills necessary to efficiently use the Access 97 application, Microsoft's powerful database program.

Microsoft Access 97 Training covers topics such as

Planning, designing, and creating a database
Building tables
Defining relationships
Making queries
Creating forms and reports

With Microsoft Access 97 Training, learn the ins and outs of Microsoft's powerful database application. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. Microsoft Access 97 Training takes the guesswork out of using Access 97.

Learn exactly what you need to know with our interactive, multimedia courseware. Our animations and simulations teach fundamental techniques and let you apply what you have learned in a realistic application environment.

Microsoft Access 97 Training is part of the Microsoft Office 97 Training suite. It is not available separately

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Planning and Designing Databases » Working with Access
» Building and modifying tables » Building and modifying forms
» Viewing and organizing information » Defining relationships
» Producing report » Integrating with other applications
Media Selection
Contextual Simulations: 54 Audio: Yes
Graphics display the user interface and key concepts
Rollovers let users interact with and view supplemental information
Animations illustrate processes
Advanced simulation technology allows users to practice skills and gauge their proficiency
Course Description
Access 97 Training will provide the learner with the fundamental concepts and basic skills
necessary to efficiently use the Access 97 application, Microsoft's powerful database program.
Audience Definition
Designed for learners who currently use or are beginning to use Microsoft Access 97.
Prerequisites
Familiarity with the Microsoft Windows environment, and ability to use a keyboard and mouse.
Estimated Length
Each Learning Object is approximately 15-20 minutes in duration with a total
approximate time of 6 hours.
Course Outline
Getting Started
Planning and Designing Databases
Working With Access Objects
Creating a Database
Building Tables
Modifying Tables
Building Forms
Modifying Forms
Switching Between Object Views
Entering and Deleting Records
Finding and Sorting Records
Making Queries
Organizing Information
Defining Relationships
Creating and Previewing Reports
Using Controls
Modifying and Enhancing Reports
Integrating With Other Applications
eSchool Essentials

Assessment Description
Pre-assessment Challenge
(3-4 standard questions and a performance-based simulation)
Lesson Review
(2 standard questions)
Final Test
(3-4 standard questions and a performance-based simulation)
Detailed Course Outline and Objectives
Getting Started
» Use the Menu bar and the Database toolbar
» Choose options in a dialog box
» Use the Database window
» Enter data in a field
» Save and close a database
» Close Access
Planning and Designing Databases
» Determine suitable data inputs and outputs for your databases
» Create a basic table structure
» Establish relationships between tables
Working With Access Objects
» Select an object using the Database window's object tabs
» Print database objects (tables, forms, reports, queries)
» Navigate through records in a table, query, or form
Creating a Database
» Use the Office Assistant
» Create a database
Building Tables
» Create tables by using the Table Wizard
» Set primary keys
» Use multiple data types
Modifying Tables
» Modify field properties
» Modify tables using Design View
» Use the Lookup Wizard
» Use the Input Mask Wizard
Building Forms
» Create a form with the Form Wizard
» Use sections of a form
» Add controls to the details section of a form
Modifying Forms
» Modify a control's format using the Property Sheet
» Build a calculated control on a form
Switching Between Object Views
» Switch between object Views
» Copy, Cut, and Paste data
Entering and Deleting Records
» Enter records using a datasheet
» Enter records using a form
» Delete records
Finding and Sorting Records
» Find a record
» Sort records
Making Queries
» Specify criteria in a query
» Create and modify a multi-table select query
Organizing Information
» Apply and remove filters using Filter by Form and Filter by Selection
» Create a calculated field
Defining Relationships
» Establish relationships between tables
» Enforce referential integrity rules on a relationship
Creating and Previewing Reports
» Create a report with the Report Wizard
» Preview and print a report
Using Controls
» Move and resize a control
» Add controls using the Control Toolbox
» Build a calculated control in a report
Modifying and Enhancing Reports
» Modify format properties of a report's controls
» Resize report sections, and add and delete header and footer sections
Integrating With Other Applications
» Import data to a new table
» Insert a hyperlink
» Save a report, table, or query as an HTML document