Course Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT

Overview: A database is a collection of related information or data. Common examples of databases include phone books, mailing list, medical records, personnel records etc. Access is a Relational Database Management System (RDBMS) and can be used for the classification, storage and retrieval of information. The way the information is organised is what makes it possible to easily and flexibly extract or re-arrange data.

This module introduces students to the more advanced features in Access. Tasks include using charts, subforms/subreports, other form techniques, and ActiveX controls. Students will also learn how to work with indexes, replicate databases, and use Access and the Internet. Other topics include creating and using macros and working with switchboards plus exporting data to Excel and Word.

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 Subforms/Subreports

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

Using Other Form Techniques

	Viewing the 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 & attaching an ActiveX Control

Replicating Databases

	Replicating a Database
	Synchronizing Database Replicas
	Resolving Replication Conflicts

Using Access and the Internet

	Creating/Inserting a Hyperlink/Field
	Editing/Deleting a Hyperlink Field
	Hiding/Displaying the Web Toolbar
	Creating a Data Access Page
	Grouping and Sorting Data Access Pages

Creating Macros

	Opening the Macro Design Window
	Creating & Saving a Macro
	Assigning an Argument to an Action
	Using Single Step Mode for Testing
	Running & Editing a Macro
	Creating a Macro using the Macro Builder

Using Macros

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

Using Switchboards

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

Exporting Data to Excel and Word

	Exporting Data to an Excel Workbook
	Dragging and Dropping Data into Excel
	Creating Excel Workbooks - Office Links
	Creating Word Documents - Office Links

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