Datrix Training
Site Search
  Home About Us Support FAQs Contact Us
   
  All Courses
Project Management
PRINCE2 Training
Microsoft Training
ITIL Training
IT Training
Delegate Information
On Site Training
Locations
T & Cs
Privacy Policy
Vacancies
Microsoft Access 2002 Advanced Training Course Outline
Last Updated 4th Febuary
IT Homepage > Microsoft Access Homepage > Microsoft Access 2002 Advanced Training Course Outline
Datrix Training offers all versions of Microsoft Access available for immediate course delivery. Stay informed by controlling your Access work, schedule, and finances, and effectively communicate Microsoft Access data. If you want a Microsoft Access course covering the basics or an advanced course concentration on deploying a Access management methodology we have all MIcrosoft Access knowledge you need.

Print this course outline
MICROSOFT ACCESS 2002 ADVANCED – 1 DAY COURSE

Module 1: Working with Forms in access 2002
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

Module 2: Working with Reports in access 2002
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

Module 3: Formatting Forms and Reports in access 2002
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colours
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control’s Formatting Properties

Module 4: Working with Macros in access 2002
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

Module 5: Advanced Topics in access 2002
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

Displaying Database Object Dependencies

Microsoft Access Course Outlines
Microsoft Access 2007
link
Microsoft Access 2003
link
Microsoft Access 2002
link
Microsoft Access 2000
link
Note: It is possible to customise and tailor each Microsoft Access course ot meet your training objectives. There is usually no extra charge for customising your training course.
Microsoft Project 2007
Freephone us on 0800 781 0626
Training venues located*:
h
Merseyside
h
West Yorkshire
h
Merseyside
h
South Yorkshire
h London (Alie Street)  
h London (Clerkenwell)  
h
Greater Manchester
h Nottingham (Racecourse) Nottinghamshire
h
Lancashire
  *Not all Datrix courses are available at every venue, please call us for details on 0800 781 0626
Gold Microsoft Certified Training Partner