Everything Desktop Training

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 2000 Training

Access 2000 Training provides the user with the core skills necessary to efficiently use the Access 2000 application, Microsoft's powerful database program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) exam.

Microsoft Access 2000 Training covers topics such as

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

With Microsoft Access 2000 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 2000 Training takes the guesswork out of using Access 2000.

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 2000 Training prepares you for the Microsoft Office User Specialist (MOUS) certification exam.

Access 2000 Training

Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Planning and designing databases
» Building and modifying tables, forms, reports, and queries
» Viewing and organizing information
» Defining relationships between databases
Media Selection
Contextual Simulations: 57 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 2000 Training will provide the user with the core skills necessary to efficiently use
the Access 2000 application, Microsoft's powerful database program. It is also excellent
preparation for the Microsoft Office User Specialist (MOUS) exam.
Audience Definition
Designed for learners who currently use or are beginning to use Microsoft Access 2000.
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
Using Access Tools

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
The objectives in the following Learning Objects cover the Microsoft Office User Specialist (MOUS)
requirements.
Getting Started
» Use the Menu bar, the Standard toolbar, and the Formatting 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 database
» Create a basic table structure
» Establish relationships between tables
Working With Access Objects
» Select an object using the Objects Bar
» 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 using a Wizard or in Design View
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 using the Form Wizard
» Use sections of a form
» Add controls to the details section of a form
Access 2000 Training Product Description
Modifying Forms
» Modify a control's format using the Properties window
» Build a calculated control on a form
Switching Between Object Views
» Use the Office Clipboard
» Switch between object views
Entering and Deleting Records
» Enter records using a datasheet
» Enter records using a form
» Delete records from a table
Finding and Sorting Records
» Sort records
» Find a record
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
» Display related records in a subdatasheet
» 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
» Save a table, query, or form as a Web page
» Add hyperlinks
Using Access Tools
» Back up an Access file and restore it later
» Compact and repair a database
» Print database relationships