ABN 76 104 620 484
 
 
 
 
Microsoft Office Courses | Soft Skills | Pricing
Contact Us | Home | Trainer Profiles
   

GETTING STARTED

Understanding How Access 2003 Works
  • What's New In Access 2003
  • How To Start Access 2003
  • How To Open A Database Using Task Pane
  • How To Close A Database
  • How To Exit Access 2003

Getting Familiar With The Access 2003 Screen
  • How To Use Menu
  • How To Show Or Hide Toolbars
  • How To Move Toolbar And Menu Bar
  • How To Use Toolbar Button
  • How To Use Shortcut Menu Using Right Mouse Click
  • How To Use Shortcut Key

Getting Help And Maintenance
  • How To Search Help
  • How To Use Content Help
  • How To Use Microsoft Office Online
  • How To Use Type A Question For Help Box
  • How To Use Office Assistant Help
  • How To Use Get Help In A Dialog Box
  • How To Get Office Updates From Microsoft Office Online
  • How To Detect And Repair Errors In Access
  • How To Recover Access When It Is Not Responding

Working With Database Objects
  • How To Open A Table
  • How To Open A Query
  • How To Open A Form
  • How To Open A Report
  • How To Rename An Object

WORKING WITH DATA

Managing Data
  • How To Navigate Through Records
  • How To Move To A Specific Record
  • How To Add Records
  • How To Edit Records
  • How To Delete A Record
  • How To Delete A Few Records

Controlling And Searching Records
  • How To Sort Records
  • How To Find Record
  • How To Filter Records By Selection
  • How To Filter Records By Criteria

 

WORKING WITH TABLES AND RELATIONSHIPS

Creating and Customising Tables
  • How To Create A New Blank Database
  • How To Create A New Table
  • How To Set Primary Key
  • How To Rearrange Fields
  • How To Add Field
  • How To Delete Field
  • How To Change Data Type
  • Get External Information
  • How To Import Table
  • How To Link Tables

Managing Relationships
  • How To Delete Table Relationship
  • How To Create Table Relationships

CREATING AND CUSTOMISING QUERIES

Creating Select Queries
  • How To Create Queries Quickly

Controlling Queries Output
  • How To Open / Switch Query To Design View
  • How To Rearrange Fields
  • How To Delete A Field
  • How To Add A Field
  • How To Sort The Query Output
  • How To Filter The Query Output With Criteria
  • How To Set Multiple Criteria
  • How To Hide A Field

CREATING AND CUSTOMISING FORMS

Creating Forms Effectively
  • How To Create A Form Quickly With AutoForm
  • How To Save And Rename Form
  • How To Create A Form Using Form Wizard

Customising Forms
  • How To Open Form Design View
  • How to Show / Hide Field List
  • How to Show / Hide Toolbox
  • How To Resize Control
  • How To Move Both Control And Label
  • How To Move Control And Label Separately
  • How To Delete A Field Control
  • How To Add A Field Control

CREATING USEFUL REPORTS

Creating Reports
  • How To Create A Report Using AutoReport
  • How To Create Mailing Labels
  • How To Set Page Margin
  • How To Change Page Orientation
  • How To Number Pages
RtB-logo-small