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

Access 2003 - Introduction

 

 

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 Introduction Course will teach delegates the basic skills necessary to effectively begin creating & working with databases.

Exploring Access

bullet

Opening an Existing Database

bullet

Menu Commands

bullet

Looking at Database Objects

bullet

Using the Task Pane

Creating Tables

bullet

Using the Database Wizard

bullet

Creating a New Database

bullet

Designing & Saving Tables

bullet

Creating a Table in Design View

bullet

Adding Field Names & Data Types

bullet

Adding a Field Description

bullet

Setting a Primary Key

Working with Tables

bullet

Navigating Fields in Tables

bullet

Adding Records

bullet

Selecting Records

bullet

Editing Records

bullet

Saving & Deleting Records

Editing Tables

bullet

Changing the Row Height

bullet

Column Width

bullet

Changing a Font Attribute

bullet

Cell Effect

bullet

Selecting & Moving a Column

bullet

Hiding, Unhiding & Freezing Columns

Setting Field Properties

bullet

Using Field Properties

bullet

Limiting Field Size

bullet

Setting Number Formats

bullet

Setting Date/Time & Yes/No Formats

bullet

Setting Default Values

bullet

Validation Rules

bullet

Creating an Input Mask – Wizard/Manually

bullet

Creating a Custom Input Mask

Finding and Filtering Data

bullet

Sorting Records

bullet

Finding Specific Records

bullet

Finding Records using Wildcards

bullet

Using Filter By Selection

bullet

Filter Excluding Selection

bullet

Filter For & Filter By Form

Looking at Relationships

bullet

Creating a Relationship between Tables

bullet

Setting Referential Integrity

bullet

Viewing Subdatasheets

Using Simple Queries

bullet

Using Queries and Recordsets

bullet

Using the Simple Query Wizard

bullet

Creating a Query in Design View

bullet

Adding a Table/Joining Tables in a Query

bullet

Running a Query

Modifying Query Results

bullet

Sorting a Query

bullet

Adding Criteria to a Query

bullet

Hiding a Field in a Query

bullet

Adding a Record using a Query

Analysing Tables

bullet

Analyzing a Table

bullet

Using Relationships in Splits

bullet

Using the Table Analyzer Wizard

bullet

Using the Performance Analyzer

Creating Basic Forms

bullet

Using Forms Using the Form Wizard

bullet

Viewing & Printing Records in a Form

bullet

Basing a Form on a Query

bullet

Using AutoForm

bullet

Adding a Record using a Form

Creating Basic Reports

bullet

Using Reports

bullet

Using the Report Wizard

bullet

Grouping and Summarizing Report Data

bullet

Basing a Report on a Query

bullet

Using AutoReport

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