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 2000 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
	Inserting a Lookup Column
	Inserting a Hyperlink Column
	Creating a Many-to-Many Relationship

Using Operators in Queries

	Using Comparison Operators
	Using an And/Or Condition
	Using the Between And Operators
	Using Wildcard Characters to Filter

Designing Advanced Queries

	Setting Top Values in a Query
	Creating a Calculated Field
	Creating a Function Query
	Creating a Parameter Query
	Creating a Concatenation in a Query (Joining two fields together)
	Using Multiple Tables in a Query
	Filtering a Query

Creating Action Queries

	Creating a Make-table Query
	Creating a Update Query
	Creating a Append Query
	Creating a Delete 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

	Printing a Relationship Document
	Linking Data to an Access Table
	Importing Data
	Setting a Database Password
	Compacting a Database
	Backing Up a Database

Manipulating Form or Report Controls

	Using Controls - Adding/Deleting
	Selecting, Sizing & Moving Controls
	Sizing Controls Automatically

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 a Label; Image; Rectangle
	Editing an Unbound Control

Using Advanced Form Design

	Using Forms in Design View
	Creating a Combo/List Box
	Creating an Option Group
	Setting the Tab Order
	Adding a Form Header and Footer

Using Editing Tools

	Selecting a Font/Size/Style
	Selecting Objects with the Toolbar
	Using AutoFormat / Spelling Checker
	Adding/Deleting AutoCorrect Entries

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