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 Advanced Course introduces delegates to the advanced features of the software including Subforms, Switchboards; Using Command Buttons & ActiveX Controls; Replicating Databases; Hyperlinks; Creating & Using Macros and more.

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 Subforms

	Working with Subforms
	Creating a Subform
	Editing the Layout of a Subform
	Displaying in Datasheet View
	Adding a Form Header/Footer
	Displaying a Subform Total

Using Other Form Techniques

	Viewing Properties of an Object
	Changing a Control Property
	Adding a Logic Control
	Adding a Command Button
	Saving a Form as a Report
	Creating a Form Letter

Using ActiveX Controls

	Working with ActiveX Controls
	Registering an ActiveX Control
	Adding an ActiveX Control
	Attaching an ActiveX Control

Working with Indexes

	Creating a Single & Multiple Field Index
	Deleting an Index
	Creating a Multiple Field Key

Replicating Databases

	Replicating a Database
	Synchronizing Database Replicas
	Resolving Replication Conflicts

Using Access and the Internet

	Working with Hyperlinks
	Creating & Inserting a Hyperlink Field
	Editing & Deleting a Hyperlink Field
	Using the Publish to the Web Wizard

Creating Macros

	Working with Macros
	Creating & Saving a Macro
	Assigning an Argument to an Action
	Using Single Step Mode for Testing
	Running a Macro / Editing a Macro

Using Macros

	Assigning a Macro to a Control
	Creating a Command Button
	Using the Command Button Wizard
	Adding a Condition to a Macro
	Creating a Group Macro
	Creating an Autoexec Macro

Using Switchboards (Front End Screens)

	Opening and Using a Switchboard
	Creating a Switchboard Form
	Adding a Button to a Switchboard
	Setting Startup Options

Creating Custom Toolbars

	Creating a Custom Toolbar
	Adding a Built-in Menu Item
	Creating a Custom Menu Item
	Adding a Command to a Menu Item
	Adding Custom Commands
	Docking a Floating Toolbar
	Linking a Toolbar to a Report
	Creating & Linking a Shortcut Menu
	Adding Buttons to a Toolbar
	Changing a Button Image

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