Access 2003 Specialised

2e2 Training
In London

Want to speak to an Advisor about this course?

Important information

Typology Training
Location London
Duration 2 Days
  • Training
  • London
  • Duration:
    2 Days

Please refer to the enclosed course outline.
Suitable for: Microsoft Access 2003 Specialised is designed for users who are keen to extend their understanding and knowledge of the software.

Important information Venues
Where and when
Starts Location
On request
Gillingham House, 38-44 Gillingham Street, SW1V 1HU, London, England
See map
Starts On request
Gillingham House, 38-44 Gillingham Street, SW1V 1HU, London, England
See map

Frequent Asked Questions

· Requirements

Microsoft Access 2003 Specialised assumes the delegate has completed the Access 2003 Fundamentals course or has equivalent knowledge.

Course programme

Relational Select Queries

Creating AND QueriesClearing The Criteria From A QuerySelecting Numeric DataSelecting Dates In A QueryCreating OR QueriesUsing A Range ExpressionSelecting Opposite ValuesUsing WildcardsProblem SelectsAdding Criteria ProgressivelyDeleting Criteria Progressively

Calculated Fields

Creating A Calculated FieldFormatting CalculationsCalculating Across Two TablesCalculating DatesUsing Criteria In CalculationsConcatenating String Fields

Parameter Queries

Creating A Parameter QueryDisplaying All RecordsUsing Parameters To Display A Record RangeNominating Specific Data TypesUsing Parameters In Expressions

Aggregate Queries

Creating An Aggregate QueryWorking With Aggregate QueriesCreating Queries With Multiple AggregatesModifying Aggregate HeadingsAggregating Calculated FieldsApplying Criteria To AggregatesCreating A Query To NestCreating An Aggregate From A Query


Forms – How they WorkCreating A New Form Using The Form WizardWorking With A FormUnderstanding Form ObjectsModifying Field Widths In A FormMoving Fields On A FormAdding A Label To A FormChanging The Properties of A Form ObjectAdding A Picture To A FormChanging The Background Of A FormChanging A Field To A Combo BoxUsing A Combo Box Control On A FormCreating A Form From A Query

Calculated Reports

Creating A Report DesignLaying Out A Report DesignCreating Totals Using SUMCreating Groups In A ReportCreating Report SubtotalsFormatting & Aligning ObjectsAdding Labels To A DesignFormatting LabelsCreating A Summary Report

Importing Records

Importing From A SpreadsheetImporting From A Text FileBacking Up A TableImporting And Key ViolationsDeleting An Unwanted TableData Integrity And Importing

Exporting Records

Copying A TableExporting A Table To Microsoft ExcelExporting A Table To A Text FileExporting A Filtered TableExporting Selected RecordsCreating An Export QueryExporting From A Query

Exporting To HTML

Exporting A Table To HTMLViewing An HTML DocumentExporting A Report To HTMLCreating Hyperlinks

Table & Query Relationships

Understanding Join TypesUsing Default JoinsOrphan RecordsViewing Orphan RecordsDeleting Orphan RecordsCreating An Exception QueryViewing A Query In SQL


Creating A Chart Using A WizardModifying Chart SizeChanging Chart FontsChanging Chart BackgroundsUpdating Chart Data

Data Access Pages

Creating A Data Access PageApplying Themes To Data Access PagesWorking With Data Access PagesUsing A Data Access Page Outside Access

Data Access Page Techniques

Creating A Data Access Page DesignPromoting And Demoting FieldsWorking With Data Access Page FieldsDisplaying Related RecordsFormatting A Pivot Table ListAdding Columns To A Pivot Table ListCreating A Scrolling MarqueeFormatting A Page

Macro Basics

Macros Versus VBACreating A MacroRunning A MacroModifying An Existing MacroInteracting With The UserDocumenting Macros

Macro Techniques

Creating A Print MacroUsing Conditions To Enhance A MacroCreating A Sequence Of ConditionsUsing The MsgBox Action StatementThe MsgBox FunctionUsing MsgBox In A ConditionReconfiguring A Message BoxUsing The InputBox Function

Macros On Forms

Creating An Event MacroCreating A Group MacroAttaching Macros From A GroupCreating A Group Macro For FormsAttaching Macros To Form EventsSetting Form PropertiesTesting Form Property Changes

Crosstab Queries

Crosstab Query TheoryUsing The Crosstab Query WizardModifying A Crosstab QueryFormatting Crosstab Query ValuesCreating A Query As A Data SourceBasing A Crosstab Query On A QueryUsing Criteria In Crosstab QueriesAdding Parameters To A Crosstab Query

Action Queries

Creating A Make Table QueryViewing A Table Created By A Make Table QueryExpressions & Update QueriesCreating An Update QueryRunning An Update QueryCreating A Saved Update QueryRunning A Saved QueryCreating A Delete QueryCreating An Append Query

Database Protection

Setting A PasswordOpening A File With A PasswordRemoving A PasswordEncoding A Database FileDecoding A Database FileHiding Database ObjectsViewing And Unhiding An Object

Database Security

Understanding Database SecurityCreating A WorkgroupCreating An AdministratorRemoving The Default Admin UserLogging On As The System AdministratorSecuring A DatabaseAdding GroupsAdding UsersAssigning PermissionsTesting Database SecurityJoining Another Workgroup

VBA Introduction

Introductory VBA TerminologyWriting A Simple Form ProcedureExamining A Simple Sub ProcedureThe MSGBOX And INPUTBOX FunctionsEditing An Existing ProcedureCreating A Standard ModuleProject - Loan Simulator CodeTesting The CodeModifying A ModuleCreate A Button On A FormRunning A Procedure From A ControlNavigating The VBA Editor

Display Controls

Controls For FormsControl PropertiesCreating A Blank FormAdding Unbound ControlsAttaching Tables & FieldsRenaming Control Text BoxesNaming Label ControlsAdding A Tab ControlAdding A SubformEnhancing A SubformUnderstanding Calculated ControlsAdding Calculated Controls To SubformsWorking With Calculated ControlsAdding Another Tab Page

Option Groups And Macros

Testing A Sample Option Button MacroCreating An Option GroupCopying Toggle ButtonsOption Group PropertiesThe ApplyFilter Macro ActionCreating A Filter MacroUsing The ApplyFilter Macro ActionHandling ExceptionsAttaching A Macro To An Option Group

Using The Switchboard

Creating A SwitchboardCreating Subsidiary MenusCreating A Menu ItemReturning To Another MenuCreating A Number Of Menu ItemsLinking The MenusModifying The Menu FormsChanging The Startup

Splitting A Database

Using The Database SplitterWorking With A Split DatabaseUpdating Database Links

Database Replication

Understanding Database ReplicationCreating A ReplicaCreating Additional ReplicasCreating A Partial ReplicaSynchronising To A ReplicaSynchronising From A ReplicaSynchronising To A Partial Replica

Concluding Remarks

Students that were interested in this course also looked at...
See all