Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Access 2000 Course

Microsoft Access 2000 Self Paced Training Course

Course Description: This is a comprehensive self-paced course that covers introductory, intermediate and advanced topics for Access 2000.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

Microsoft Access 2000 Self-Paced Course Syllabus

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

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Business Computer Skills Facebook PageBusiness Computer Skills Google+ PageBusiness Computer Skills Twitter PageBusiness Computer Skills Youtube Page Business Computer Skills LinkedIn Page

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Business Computer Skills BBB Profile