|
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
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.
Objective
Upon completion of this course, the student will be able to:
- Planning and Designing Databases
- Building and modifying tables
- Viewing and organizing information
- Producing reports
- Working with Access
- Building and modifying forms
- Defining relationships
- Integrating with other applications
Topics Include
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
Duration
10 hrs
Minimum Requirements
Shockwave 8.0, 200 MH Pentium CPU (266 recommended), 32 MB of available RAM, (64 recommended), Windows 95, 98, 2000 or NT; (Windows 2000 or NT require 64MB of RAM)
Media
Web Based Training
|
