Access 2002 Online Learning

Part of the Desktop Computing Online Learning Library featuring high quality self-paced eLearning training titles for Microsoft Access 2002.

This series shows how to create, plan, and modify databases and database objects in Access 2002. Modules cover the following topics: understanding relational databases, creating and planning databases, selecting and printing database objects, creating tables, entering records, modifying tables and field properties, using advanced sorts, finding records, applying and removing filters, establishing and managing table relationships, specifying query criteria, creating calculated fields, running multi-table queries, creating forms and reports, implementing standard and calculated controls in both forms and reports, importing data, saving Access objects as Web pages, and performing administrative tasks. This series is procedure focused and assumes that the student is familiar with the mechanics of getting around in a Microsoft Office application.

Modules included in this course   Creating Databases Module Building Tables Module Modifying Tables Module Sorting and Filtering Module Relationships & Queries Module

Building Forms Module Producing Reports Module Advanced Tasks Module Questions? Would you more information on this or any of our training courses?  Call us toll free 1-800-730-7115.

 

Access 2002 Online Learning    order now Pricing: 10-24 $3.29/mo 25-49 $1.88/mo 50-99 $1.74/mo 100-249 $1.64/mo 250-499 $1.55/mo 500-999 $1.45/mo course outline  •  download sample

Desktop Computing Online Learning Library    order now Pricing: 10-24 $10.79/mo 25-49 $9.60/mo 50-99 $8.40/mo 100-249 $7.20/mo 250-499 $5.60/mo 500-999 $4.80/mo complete bundle   •  best value     The complete Desktop Computing Online Computer Training  Library includes:   Access 2000 MOS   Access 2002   Access 2003   Access 2007   Computer Basics   Computing Concepts   Crystal Reports 8   Excel 2000 MOS   Excel 2000 MOS Expert   Excel 2002   Excel 2003   Excel 2007   GroupWise 5.5   GroupWise 6.5   Internet Explorer 6   Internet Explorer 7   Introduction to PC's   Lotus Notes 6.5   Lotus Notes R5   Office 2000   Office 2003 - What's New   Office 2007   Office XP Upgrade   Outlook 2002   Outlook 2003   Paint Shop Pro 5   PowerPoint 2000 MOS   PowerPoint 2002   PowerPoint 2003   Project 2000 MOS   Project 2003   SAP R/3 Release 4.6   SharePoint 2003   Visio 2002   Windows XP Upgrade   Windows 2000 Basics - Client   Word 2000 MOS   Word 2000 MOS Expert   Word 2002   Word 2003

Using our online computer training materials is easy and cost effective.
They provide the training necessary to survive and flourish in today's fast paced work environment. It includes courses on the latest desktop technology such as Word, Excel, PowerPoint and Flash.

Why write Access  2002 training materials when we've done it for you? We've saved you thousands of hours.  We do the prep work... you do the training.

By offering such flexible training solutions, you will enjoy how easy it is to meet the training needs of your organization.  Unlimited access 24 hours a day, seven days a week - users learn at their own pace - at work, at home, or on the road. 

Access 2002 Course Outline

 

Creating Databases Module: This module shows users how to plan and create a database in Access 2002.. Identify appropriate input and output for a database Plan a database Create a database with and without the wizard Select and print database objects Building Tables Module: This module shows users how to create and populate database tables in Access 2002.. Explain the structure of a table, the data types used in the table, and the function of primary keys Create a table using the wizard Enter records into the table through a form or datasheet Modifying Tables Module: This module shows users how to edit table data, table structure, and field properties in Access 2002.. Insert and delete records and fields Modify the appearance and structure of the table in Design View Change the size, format, and default value of fields Use the Lookup and Input Mask wizards Sorting and Filtering Module: This module shows users how to find, filter, and sort records in Access 2002.. Sort records Create advanced sorts Search for records Apply and remove filters Relationships & Queries Module: This module shows users how to establish table relationships, perform join operations, and define and execute queries in Access 2002.. Define table relationships Manage table relationships Display related records Specify query criteria Create calculated fields Create and modify multi-table queries Building Forms Module: This module shows users how to create forms in Access 2002, to change the appearance of reports, and to add bound and unbound controls to reports.. Create a form Edit the form in design view Add and modify controls Create and use calculated controls Producing Reports Module: This module shows users how to create reports with the Report Wizard, arrange and organize reports, and add bound and unbound controls to the report in Access 2002.. Describe the components of reports Create a report using the Report Wizard Edit the report in design view Add and modify controls in a report Create and use calculated controls in a report Advanced Tasks Module: This module shows users how to import data into Access databases, create Web hypertext pages based on Access objects, incorporate hyperlinks into Access objects, and perform administrative tasks such as backing up the database in Access 2002.. Import data into a table Save an Access object as a Web page Add hyperlinks to an Access object Back up, restore, and compact a database