Schedule	Course List
		Access Introduction
	Microsoft Access  Intermediate Two Day Course	Access Advanced

Course Outline This course is designed to give the delegate a good working knowledge of Access building on the skills learnt on the Introduction Course.At the end of the course the delegate will have the knowledge to design and run reports, queries and forms using the Access software. Delegates Requirements It is essential that the delegate has completed a Windows introductory course, and has attended an Access Introductory Course, or has gained similar knowledge within the work environment. Who Should Attend Anyone who is responsible for maintaining an existing Access database management system or needs to search and find information and assist in the design of reports.

MS Access Intermediate Course Objectives   Database Design What is a Relational Database? Primary and Foreign Keys Relationships   Using Field Properties for Protection Required Default Value Input Mask Validation Rule and Validation Text Lookups   Table Relationships What Is a Relationship? Relationship Types Creating and Editing Relationships Using Lookups for Referential Integrity Multi-table Datasheet View   Forms What is a Form? Form Sections Form Controls Form Control Layout Using form Controls Control Properties Control Wizards Multiple Table Forms   Access Introduction Access Advanced

Reports Using Report Wizards as the Basis for Reports Report Sections Report Controls Report Control Layout Using Specific Controls Publishing Datasheet Views on the Internet Adding Hyperlinks to Datasheet Views Adding Hyperlinks to HTML Pages   Queries Multi-table Queries Calculated Fields Adding a Calculated Field to a Query The Expression Builder Calculating Summary Information Crosstab Queries General Query Properties Checking Referential Integrity   Access Forms Importing from Other Data Sources Importing Data Using Drag-and-Drop Backing Up and Restoring a Database Compacting and Repairing a Database

Site Map