Access Training Courses - Microsoft Access VBA & Access 97 - 2000

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

Getting Started

	Opening an Existing Database
	Using Menu Commands
	Displaying and Hiding Toolbars
	Selecting Object Types
	Opening a Database Object

Creating Tables

	Creating & Designing a New Database
	Using Design View
	Adding Field Names
	Assigning Data Types
	Adding a Field Description
	Setting a Primary Key & Saving a New Table
	Using the Table Wizard

Working with Tables

	Using Datasheet View
	Navigating Fields in Tables
	Adding & Deleting Records
	Moving through Records
	Selecting & Editing Records

Editing Tables

	Changing the Row Height & Column Width
	Changing a Font Attribute
	Selecting a Column; Moving a Column
	Hiding/Un-hiding a Column
	Freezing Columns

Setting Field Properties

	Limiting Field Size
	Setting Number Formats, Date/Time Formats
	Setting Yes/No Formats, Default Values
	Setting Validation Rules
	Creating an Input Mask

Finding and Filtering Data

	Sorting Records
	Finding Specific Records
	Finding Records using Wildcards
	Using Replace; Filter By Selection
	Applying/Removing a Filter
	Using Filter Excluding Selection
	Using the Filter For Feature
	Using Filter By Form

Using Simple Queries

	Using Queries and RecordSets
	Using the Simple Query Wizard
	Creating a Query in Design View
	Opening a Query
	Adding a Table to a Query
	Joining Tables in a Query
	Running a Query

Modifying Query Results

	Sorting a Query
	Adding Criteria to a Query
	Hiding a Field in a Query
	Adding a Record using a Query
	Printing a Query

Creating Basic Forms

	Using the Form Wizard
	Viewing Records in a Form
	Printing Records in a Form
	Basing a Form on a Query
	Using AutoForm
	Adding a Record using a Form

Creating Basic Reports

	Using the Report Wizard
	Using Print Preview
	Printing Pages of a Report
	Basing a Report on a Query
	Using AutoReport

Creating Relationships

	Using Related Tables
	Creating a Relationship
	Setting Referential Integrity
	Adding a Table - Relationships Window

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