Software Solutions Team - Course Schedule

Learn the basics of planning and designing databases by creating and modifying tables, creating and running queries, designing forms and generating reports. This course provides a great foundation for understanding the concepts of relational databases. (2003 / 2007 / 2010 courses)

Prerequisites: Windows Introduction or previous Windows experience, Word Introduction, and Excel Introduction.

Access 2003 Introduction	#6707	$219	Thu	09/23/10	9:00AM-4:00PM
	#6830	$219	Wed & Thu	10/13 & 10/14	9:00AM-12:00PM	CLOSED
	#6831	$219	Mon	11/01/10	9:00AM-4:00PM
Access 2007 Introduction	#6835	$219	Fri	10/01/10	9:00AM-4:00PM	CLOSED
Access 2007 Introduction	#6836	$219	Fri	11/12/10	9:00AM-4:00PM
Access 2010 Introduction	#6832	$219	Thu	10/07/10	9:00AM-4:00PM	CLOSED
	#6833	$219	Wed	11/17/10	9:00AM-4:00PM
	#6834	$219	Thu	12/09/10	9:00AM-4:00PM

Access Intermediate ◄-- Click here for Course Outline

This course covers topics including table relationships, the Lookup Wizard; data integrity; input masks and validation rules, advanced queries including calculations, crosstabs, and parameters. Students also learn advanced form features including calculations and combo boxes, customizing reports; using functions and expressions; and macros. (2003 / 2007 / 2010 courses)

Prerequisites: Access Introduction.

Access 2003 Intermediate	#6711	$219	Fri	09/03/10	9:00AM-4:00PM
	#6837	$219	Wed	11/17/10	9:00AM-4:00PM
	#6838	$219	Fri	12/03/10	9:00AM-4:00PM
Access 2007 Intermediate	#6713	$219	Wed	09/01/10	9:00AM-4:00PM
	#6839	$219	Tue	10/26/10	9:00AM-4:00PM
	#6840	$219	Wed	12/01/10	9:00AM-4:00PM
Access 2010 Intermediate	#6841	$219	Fri	10/29/10	9:00AM-4:00PM

Access Essentials of Table Design ◄-- Click here for Course Outline

A little knowledge is dangerous - truer words were never spoken especially as they refer to designing a relational database like Access. A must class for database designers. Learn the five rules of "data normalization" that will save you grief and pain as you develop your database. Also learn how to make sure your database has integrity.

Prerequisites: Access Introduction and Access Intermediate.

Access Essentials of Table Design	#6715	$219	Wed	09/15/10	9:00AM-4:00PM	CLOSED
	#6842	$219	Thu	11/04/10	9:00AM-4:00PM
	#6843	$219	Wed	12/15/10	9:00AM-4:00PM

Access Advanced ◄-- Click here for Course Outline

For the power users, this class will cover building advanced forms with grouped controls and subforms, creating advanced macros requiring user interaction and AutoKeys, writing and attaching basic SQL statements, Internet integration, and security fundamentals. (2003 / 2007 / 2010 courses)

Prerequisite: Access Intermediate and Access Essentials of Table Design.

Access 2003 Advanced	#6717	$219	Tue	09/21/10	9:00AM-4:00PM	CLOSED
	#6844	$219	Fri	11/12/10	9:00AM-4:00PM
	#6845	$219	Tue	12/21/10	9:00AM-4:00PM
Access 2007 Advanced	#6718	$219	Mon	09/27/10	9:00AM-4:00PM
Access 2007 Advanced	#6846	$219	Thu	12/16/10	9:00AM-4:00PM
Access 2010 Advanced	#6847	$219	Thu	12/02/10	9:00AM-4:00PM

<<Back to Top>>

NEED TO GET UP AND RUNNING QUICKLY WITH AN ACCESS DATABASE?

CONTACT US TODAY TO DISCUSS OUR DATABASE CONSULTING SERVICES!