Scheduled Courses	Course List
		Access Introduction
	Microsoft Access  Advanced One Day Course	Access Intermediate

Course Outline This course is designed to give delegates a greater understanding of the advanced features in Access and to design and use macros. Delegates Requirement A good working knowledge of Windows or NT is required. A working knowledge of the Access interface, table creation, basic query and report writing functions gained from practical experience or by prior attendance on an Access Introduction Course is desirable Who Should Attend Experienced users of Access who have to administer or create Access databases

Database Design Theory of Normal Forms De-normalisation Naming Conventions   Access  Performance Issues Indexes Data Validation Table Level Validation Relationships and Referential Integrity Relationships Field Types Referential Integrity Options Join Types Using Lookups for Referential Integrity Multi-Table Datasheet View   Access and the Internet Using Hyperlinks Using Hyperlinks in Forms Exporting Datasheet Views to HTML Data Access Pages   Advanced Form Design Using Advanced Forms Features The Form Worksurface Creating a Calculated Control Adding a Graphic to a Form Multi-Table Forms Using the Subform Control Switchboard Forms   Access Introduction Access Intermediate

Action Queries What is an Action Query? Planning an Action Query Make Table Queries Append Queries Delete Queries Update Queries   Advanced Report Design Applying Sorting and Grouping to Reports Performing Calculations on Reports Adding a Graphic to a Report Using the Subreport Control Modifying Section Properties Using the Chart Wizard   Creating Macros What is a macro? Creating a macro Running a Macro Using Macros with Events Grouped Macros Using the Macro Builder Attaching Macros to Controls Form Events Send Keys Conditional Macros

Site Map