Access 2003 - Intermediate

Course Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT

Overview: Access 2003 is a relational database application. A relational database contains a large amount of data that is split into numerous tables; each table should include only the information pertinent to one subject, such as Customer, Orders, or Items. As a result, each table is smaller; more manageable; and, in turn, more efficient. These tables can then be joined together to make them related. When tables are related, you can access information from any field in any related table, eliminating the need to add the same information to more than one table. In addition, you can create reports, forms, and queries from data stored in any related table.

The Intermediate Course introduces delegates to more advanced features of the software including tasks such as creating queries which can search for duplicates in database, creating calculated fields, importing & exporting data; manipulating Controls in Design View of Forms and more.

Modifying Tables

	Inserting / Deleting a Column in a Table
	Changing a Column Name
	Lookup Columns
	Hyperlink Columns

Using Operators in Queries

	Using Comparison Operators
	Using an And / Or Condition
	Using the Expression Builder
	Using a Wildcard Character

Designing Advanced Queries

	Setting Top Values in a Query
	Creating & Formatting a Calculated Field
	Function Query; Parameter Query
	Creating a Concatenation in a Query
	Filtering a Query

Creating Action Queries

	Creating a Make-table
	Creating a Delete Query
	Creating an Update Query
	Creating an Append Query

Using Advanced Query Wizards

	Using the Crosstab Query Wizard
	Using the Find Duplicates Query Wizard
	Using the Find Unmatched Query Wizard

Using Advanced Database Features

	Importing Data; Exporting Data
	Linking Data to an Access Table
	Using the Linked Table Manager
	Creating a Data Access Page - Page Wizard
	Compacting a Database

Creating Relationships

	Using Related Tables
	Creating a Relationship between Tables
	Setting Referential Integrity
	Viewing Subdatasheets
	Deleting a Join Line

Manipulating Controls

	Using & Selecting & Deleting Controls
	Sizing Controls
	Moving Controls
	Sizing Controls Automatically
	Changing the Properties of an Object

Using Design View

	Disabling the Snap to Grid Feature
	Displaying the Field List & Adding a Field
	Moving Part of a Paired Control
	Aligning & Spacing Controls
	Using the Toolbox
	Adding: Labels; Images; Rectangles; Lines
	Editing an Unbound Control
	Using Multiple Undo/Redo in Design View

Using Advanced Form Design

	Looking at Forms in Design View
	Combo Box; List Box; Option Group
	Adding a Logic Control
	Setting the Tab Order
	Adding a Form Header and Footer

Using Editing Tools

	Selecting Objects with the Toolbar
	Changing Fill and Background Colours
	Formatting Lines and Borders
	Applying Special Effects
	Using AutoFormat

If you have other questions, please contact us at enquiry@it-uk.com or complete our response form