Microsoft Access
Introduction	Intermediate		Advanced
Getting started Database Concepts Exploring the Access environment Databases and tables Planning and designing databases Exploring tab les Creating tables Fields and records Changing the design of a table Finding and editing records Organizing records Data Entry rules Setting field properties Working with input masks Setting validation rules Basic queries Creating and using queries Modifying query results and queries Performing operations in queries Using forms Creating forms Using Sorting and filtering records Working with reports Creating reports Modifying and printing reports	Relational databases Database normalization Table relationships Referential integrity Related tables Creating lookup fields Modifying lookup fields Subdatasheets Complex queries Joining tables in queries Using calculated fields Summarizing and grouping values Advanced form design Adding unbound controls Graphics Adding calculated values Adding combo boxes Advanced form types Reports and printing Report formatting Calculated values and subreports Printing Label printing Charts Charts in forms Charts in reports		Querying with SQL SQL and Access Writing SQL statements Attaching SQL queries to controls Advanced queries Creating crosstab queries Creating parameter queries Using action queries Macros Creating, running, and modifying macros Attaching macros to the events of database objects Advanced macros Creating macros to provide user interaction Creating macros that require user input Creating AutoKeys and AutoExec macros Creating macros for data transfer Importing, exporting, and linking objects Importing objects Exporting objects Working with XML documents Linking Access objects Using hyperlink fields Database management Optimizing resources Protecting databases Setting options and properties
Computer Training of America, Inc.	Telephone: (413) 283-7740		Toll Free: (877) 283-7740
Fax: (413) 283-7730		Web Site: www.computertrainingofamerica.com