1 2 1 1 6 8 5 9
Site Navigation
Instructor Classes
Online Classes

Home Page
Course Catalog
Training Locations
FAQ
Partner Sites
User Login
My Account
Online Class Login
Call Toll Free for Customer Service
Chicago Locations
Chicago
Naperville
Northbrook
Schaumburg
Microsoft Courses
Excel Classes
Access Classes
Project Classes
PowerPoint Classes
Word Classes
Outlook Classes
Adobe Courses
Photoshop Classes
Illustrator Classes
InDesign Classes
Dreamweaver Classes
Flash Classes
HTML Classes
Acrobat Classes
Microsoft Access 2000 Online Course Detail
Microsoft Access 2000 Online Course

Microsoft Access 2000 Online Course Detail


Course Decription: MS Access

We offer one of the most comprehensive and easy to use online class for Microsoft Access 2000. Students will learn a variety of topics including:
  • Microsoft Access fundamentals
  • Database Design
  • Formatting Techniques
  • Creating Queries and Tables
  • Creating Macros
  • Intermediate and Advanced Topics
Special Offer:You will receive all the available Microsoft Access 2000 online courses, with the purchase of a single MS Access online course.
Microsoft Access 2000 Course Demo


Course Outline

The Fundamentals
     Introduction to Databases
     What's New in Access 2000?
     Starting Access and Opening a Database
     Understanding the Access Program Screen
     Using Toolbars
     Hiding, Displaying, and Moving Toolbars
     Filling Out Dialog Boxes
     Keystroke and Right Mouse Button Shortcuts
     Opening and Modifying Database Objects
     Working with Multiple Windows
     Tour of a Table
     Adding, Editing, and Deleting Records
     Tour of a Form
     Tour of a Query
     Tour of a Report
     Previewing and Printing a Database Object
     Selecting Data
     Cutting, Copying, and Pasting Data
     Using Undo
     Checking Your Spelling
     Getting Help from the Office Assistant
     Changing the Office Assistant and Using the "What's This" Button
     Using the Zoom Box
     Closing a Database and Exiting Access

Creating and Working with a Database
     Planning a Database
     Creating a Database Using the Database Wizard
     Creating a Blank Database
     Creating a Table Using the Table Wizard
     Modifying a Table and Understanding Data Types
     Creating a New Table from Scratch
     Creating a Query in Design View
     Modifying a Query
     Sorting a Query using Multiple Fields
     Developing AND and OR Operators
     Creating a Form with the Form Wizard
     Creating a Report with the Report Wizard
     Creating Mailing Labels with the Label Wizard
     Database Object Management
     File Management
     Compacting and Repairing a Database
     Converting an Access 97 Database

Finding, Filtering, and Formatting Data
     Finding and Replacing Information
     Sorting Records
     Filtering by Selection
     Filtering by Form
     Creating an Advanced Filter
     Adjusting Row Height and Column Width
     Rearranging Columns
     Changing Gridline and Cell Effects
     Freezing a Field
     Hiding a Column
     Changing the Datasheet Font

Working with Tables and Fields
     Understanding Field Properties
     Indexing a Field
     Adding a Primary Key to a Table
     Inserting, Deleting, and Reordering Fields
     Changing a Field’s Data Type
     Using Field Descriptions
     Adding a Caption
     Change the Field Size
     Formatting Number, Currency, and Date/Time Fields
     Formatting Number, Currency, and Date/Time Fields by Hand
     Formatting Text Fields
     Setting a Default Value
     Requiring Data Entry
     Validating Data
     Creating an Input Mask
     Creating a Lookup Field
     Creating a Value List
     Modifying a Lookup List

Creating Relational Databases
     Understanding Table Relationships
     Creating Relationships between Tables
     Enforcing Referential Integrity
     Testing Referential Integrity and Deleting a Relationship
     Understanding of Relationship Types

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 and Deleting Fields
     Moving and Sizing Controls
     Changing the Tab Order
     Working with Control Properties
     Control Property Reference
     Working with Form Properties
     Form and Report Property Reference
     Working with Multiple Controls
     Adding, Cutting, Copying, and 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 and Working with Subforms

Working with Reports
     Creating a Report with AutoReport
     Modifying a Report
     Adding and Deleting Fields
     Moving and Sizing Controls
     Adjusting Page Margins and Orientation
     Adding Page Numbers and Dates
     Understanding Report Sections
     Grouping and Sorting Records
     Creating Calculated Controls
     Working with Section Properties
     Creating Charts with the Chart Wizard

Formatting 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 with One Another
     Changing a Control’s Formatting Properties

Working with Macros
     Creating and 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

Using Access 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



Return to the Illinois Computer Training® online course list