599CD Computer Training

Beginner
NEW	Report Columns Using multiple columns in reports
	Creating a Parameter Query Entering criteria at run-time
	String Concatenation FirstName & LastName together
	Different Form Controls for Gathering User Input
	Calculated Query Fields LineTotal: Price * Quantity
	Form Control Wizards Not Starting
Intermediate
	Multi-Field Search Form Using the LIKE keyword and wildcards
	Sorting & Grouping Levels Multiple groups in Access 2010 Reports
	Open Report Find Specific Data Show only certain records
	Project Scoring Score projects based on multiple criteria
	Form / SubForm Track students and courses they're signed up for
	Last Day of Month Calculate last day of the month, DateSerial
	Report Counter Count items in a report, by group
	NULL v. Zero Length String What's the difference?
	Restart Page Numbering in Access Reports
	Rounding Numbers Using ROUND, INT, and FIX
	Relating a Table to Itself Head-of-household, geneaology tables
	Report Sorting & Grouping Calculating donations for each State
	Convert Numbers to Dates Turn 20021031 into 10/31/2002
	Form Footer Totals Sum up the values on a form
	Difference Between Two Dates DateDiff, DateAdd, IIF, Round
	Difference Between Two Times Calculate hours worked between times
	Building an Update Query Changing field values automatically
	Building an Append Query Tracking student attendance in class
	Using a Relational Combo Box Selecting a customer on a related form
	Making Relational Tables Proper Normalization Techniques
	Getting Query Criteria from a Form Forms!FormName!Field Notation
	Creating an Aggregate Query Adding up customer sales in a query
Advanced
	Using DCOUNT Count records in your table, determine record rank
	Breaking Up Text Strings InStr, Replace, Left, Right, Trim
	Requery v. Refresh What's the difference between these commands?
	Products & Units Track specific units for a product type in inventory
	ListBox AddItem ListBox Add / Remove Item in Access 2000
	Using Recordsets DAO database connectivity, multi-select listboxes
	Using MsgBox and vbYes to Close a Form Form Properties
	DMax: Increment Your Own Counter DMax, BeforeInsert, Nz
	AfterUpdate Event Running VBA code after a field value is changed
	Filtered Combo Boxes Filter one combo box by value selected in the other
	Using the DLOOKUP Function Changing fields after pick a customer
	Using the IIF Function Add IF/Then functionality to queries
	Prevent Duplicate Values on Multiple Fields BeforeUpdate event
	Resize a Form using VBA Code
Course Addendums
NEW	Image ControlSource New technique for Imaging Seminar to display picture
	Calendar Control Missing Calendar Control (MSCAL.OCX) in Access 2010
	Change Month with Buttons Also display name of month/year on top