ICUC - Enabling Efficient Measurable Learning

Full Library Membership

Microsoft Office 2007

Microsoft Office 2003

Microsoft Office 2002

Microsoft Office 2000

Microsoft Windows

Other Courses

Microsoft Access 2002


Purchase Access 2002 for just £25.49
Submit Form

Microsoft Access 2002

  • A complete Access training solution that includes hands-on lessons, student assessments, reports, printable certificates and more!
  • Master what you want at your own pace and at a time and place that suits you.
  • Learn real-world skills you can apply right away with our bite-sized interactive lessons that simulate the experience of using Microsoft Access.
  • You have the support of a UK local-rate helpline.

The Access 2002 course is divided into 10 chapters containing a total of 143 interactive learning lessons which takes you through the skills and knowledge you need to make effective use of Microsoft Access 2002.

The beauty? It's there all the time, at your finger-tips - when you need a little help on how to do something, go to your online learning - look it up and get a refresher, in just a few minutes - no need to trouble anyone else and you don't need to remember.

The content covered:

The Fundamentals
Introduction to Databases, What's New in Access 2003?, Starting Access and Opening a Database, Understanding the Access Screen, Using Menus, Using Moving Toolbars, Filling Out Dialog Boxes, Keystrokes 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, Changing the Office Assistant, 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 Older Versions of Access

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, Changing 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 Relationships, Understanding Relationship Types

Working with Queries
A Quick Review, Understanding the Different Types of Queries, Creating a Multiple Table Query, Creating a Calculated Field, Working with Expressions and the Expression Builder, Using an IIF Function, Summarizing Groups of Records, Displaying 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, Working with Form Properties, 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

Using Access with Other Programs
Importing Information, Exporting Information, Importing Objects from another Access Database, Linking Information from an External Data Source, Analyzing Records with Microsoft Excel, Exporting Records to Microsoft Word, Mail Merging Records to Microsoft Word, Using Hyperlink Fields, Using OLE Object Fields, Displaying Database Object Dependencies