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

Course Outline This course is designed to give the delegate a good working knowledge of Access so that they can create and edit Access databases. Delegates Requirements It is essential that the delegate has completed a Windows 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 prepare reports and lists.

Database Design Relationships Designing Databases Relational Database Theory Database Objects and Container   Microsoft Access File Menu Icon Bar Database Window Status Bar   Creating Tables Field Properties Data Types Views Data Entry Creating Key Fields   Forms Using Form Wizards Auto Forms Form Properties   Access Intermediate Access Advanced

Queries Different Query Types Queries Select and Action Queries Setting Criteria Update Queries Multi-table Queries Adding a Calculated Field to a Query   Reports Wizards Using Report Wizards Designing Reports Sorting and Grouping Data in Reports Using the Expression Builder Automatic Summary Reports Adding Controls to a Report   Using Field Properties for Protection Required Default Value Input Mask Validation Rule and Validation Text Lookups

Site Map