Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP
Telephone: 08456 44 1234
Email: enquiry@it-uk.com

Access 2002 (XP) - 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 2002 (XP) 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

bullet

Inserting / Deleting a Column in a Table

bullet

Changing a Column Name

bullet

Inserting a Lookup Column / Hyperlink Column

bullet

Creating a Many-to-Many Relationship

Using Operators in Queries

bullet

Using Comparison Operators

bullet

Using an And / Or Condition

bullet

Using the Expression Builder

bullet

Using a Wildcard Character

Designing Advanced Queries

bullet

Setting Top Values in a Query

bullet

Creating & Formatting a Calculated Field

bullet

Function Query; Parameter Query

bullet

Creating a Concatenation in a Query

bullet

Filtering a Query

Creating Action Queries

bullet

Creating a Make-table Query

bullet

Creating an Update Query

bullet

Creating an Append Query

bullet

Delete Query

Using Advanced Query Wizards

bullet

Using the Crosstab Query Wizard

bullet

Using the Find Duplicates Query Wizard

bullet

Using the Find Unmatched Query Wizard

Using Advanced Database Features

bullet

Importing Data

bullet

Linking Data to an Access Table

bullet

Using the Linked Table Manager

bullet

Exporting Data; Converting Files

bullet

Creating a Data Access Page - Page Wizard

bullet

Compacting a Database

Manipulating Controls

bullet

Using & Selecting & Deleting Controls

bullet

Sizing Controls; Moving Controls

bullet

Sizing Controls Automatically

bullet

Viewing & Changing the Properties of an Object

Using Design View

bullet

Disabling the Snap to Grid Feature

bullet

Displaying the Field List & Adding a Field

bullet

Moving Part of a Paired Control

bullet

Aligning Controls; Spacing Controls

bullet

Using the Toolbox

bullet

Adding a Label; Image; Rectangle; Line

bullet

Editing an Unbound Control

bullet

Using Multiple Undo/Redo in Design View

Using Advanced Form Design

bullet

Using Forms in Design View

bullet

Creating a Combo Box

bullet

List Box

bullet

Option Group

bullet

Adding a Logic Control

bullet

Setting the Tab Order

bullet

Adding a Form Header and Footer

bullet

Creating a Blank Form

Using Editing Tools

bullet

Selecting Objects with the Toolbar

bullet

Changing the Font & Colour

bullet

Changing the Character Format

bullet

Changing Fill and Background Colours

bullet

Formatting Lines and Borders

bullet

Applying Special Effects

bullet

Using the Format Painter

bullet

Using AutoFormat
 

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

Back Next

Computer Training Solutions © 2008
Email: 
enquiry@it-uk.com

About CTS
Course Outlines
Contact Us
Links

Access
Adobe Acrobat
ACT!
ASP
AutoCAD 2000+
CorelDraw
Cascading Style Sheets
DHTML / DOM
Dreamweaver
Excel
Fireworks
Flash
Freehand
FrontPage
HTML / XHTML
Illustrator
ImageReady
InDesign
Microsoft Office XP
Outlook
Adobe PageMaker
Paint Shop Pro 7
Photoshop
PowerPoint
Project
Publisher
QuarkXpress
Sage Line 50
SQL Server
Visio
Visual Basic / VBA
Web Development
Word
XML