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 97 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 creating advanced queries; calculated fields, advanced form design; creating charts; database utilities; and more.

Setting Field Properties

	Limiting Field Size
	Number Formats
	Date/Time Format
	Yes/No Format
	Setting Default Values
	Setting Validation Rules/Text

Modifying Tables

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

Using Operators in Queries

	Using Comparison Operators
	Using an And Condition
	Using an Or Condition
	Using Between...And Operator
	Using a Wildcard Character
	Designing Advanced Queries
	Setting Top Values in a Query
	Creating a Calculated Field
	Creating a Function & Parameter Query

Creating Action Queries

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

Using Advanced Query Wizards

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

Manipulating Controls

	Using Controls
	Deleting Controls
	Sizing a Control by Dragging
	Selecting & Moving Selected 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 Controls
	Spacing Controls
	Using the Toolbox
	Adding a Label; Image; Rectangle; Line
	Editing an Unbound Control

Using Advanced Form Design

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

Using Charts

	Creating & Adding a Chart to a Report
	Activating Microsoft Graph to Edit
	Changing the Chart Type & Title
	Adding Data Labels to a Chart

Using Advanced Report Design

	Using Reports in Design View
	Creating a Calculated Control
	Grouping Data in a Report
	Creating a Header for Each Group
	Creating a Running Summary
	Inserting a Date/Time Control
	Inserting a Page Break
	Changing the Report Margins
	Using the Label Wizard

Using Database Utilities

	Changing Database Properties
	Linking Data to an Access Table
	Importing Data
	Setting a Database Password
	Compacting a Database

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