SUMMIT
		COMPUTING
			ASSOCIATES

Intro to Programming in Access	• Overview of Access • The Programming Environment • Event procedures • The Anatomy of Code     - Subs vs. Functions     - Public vs. Private • Constants and Variables     - Dim, Static, and Global Statements     - Data Types     - Arrays • Introduction to Object Variables     Access Objects, DAO • Creating Custom Message and Dialog Boxes • Naming Standards
Programming in Access Intermediate Level	• Creating Conditional Statements and Loops     - If, Then, Else, Select Case, Do Until and Do While • Working with Recordsets     - Manipulating data with  DAO and ADO     - Passing variable parameters • Applying Properties and Methods to Objects     - Controls, Forms, and Reports as objects • Data Access Objects     - Workspaces, TableDefs, QueryDefs • Debugging and Error Handling     - Using the Immediate Window
Developing Access Applications	• Develop an application from the ground up     - brainstorming, table design, build a relationship model • Learn to Speed Up Access 10x with ADO • Learn to Import/Export to SQL Server with ADO • Develop a user interface     - learn which features of form design to pay attention to and which to avoid     - write code to automate data entry and search tasks • Develop management reports • Customize Excel spread sheets using automation • Customize Word with automation • Learn How to Add Database to Your Web Site  • Add the finishing touches