accessadv

Course	Microsoft Access Advanced
Duration	2 Days
Overview	This is an excellent course for those students wishing to advance their knowledge of the program. Students wishing to attend this course should be comfortable with the majority of the features covered on the introductory course.
Content	Principles of Database and Table Design	Normalising Data Analysing Relationships Printing Relationships Data Validation Techniques Indexing Techniques
	Action Queries	Append, Update, Delete CrossTab, Find Duplicates Union Queries, Changing Join Options AutoLookup Queries
	Forms	Option Buttons, Multitab Controls Format Painter, AutoFormat Colour Schemes Conditional Formats Form & Object Properties Grouping Objects Bound & Unbound Controls Calculated Controls Headers & Footers, Tab Order Using Functions
	Data Access Pages	Integrating with the Web Collect and distribute current data in several ways
	Reports Design	Functions for Reports & Queries Grouped Reports Group Headers & Footers Page Headers & Footers Subtotals & Totals Advanced Layout Design Hide Duplicate Data Report Properties, Filter in Reports Distribute Reports to non Access users
	Working with SubReports
	Macros	Creating, Saving, Running AutoMacros Using Conditions Synchronising Forms Macros on Forms Command Buttons
	Integrating with Office 97	Link and Import data from Outlook Analysing with Excel, Mail Merge in Word
	Creating a Switchboard
	Data Security	Passwords, Permissions, Multi-user Issues
	Database Replication