Microsoft Access 2003
Introduction Relational Databases Analyzing Table Relationships Relating Tables Testing Referential Integrity Working with Tables Using the Lookup Wizard Modifying Lookup Fields Adding Data to Related Tables Defining Data Entry Rules Working with Input Masks Setting Required Properties Setting Validation Rules Setting Lookup Fields Advanced Query Features Joining Tables in Queries Creating Calculated Fields Using Action Queries Creating Advanced Queries Summarizing/Grouping Values Creating Crosstab Queries Using Parameter Queries Using Indexes Enhancing Forms Adding Graphics to a Form Adding Calculations to a Form Adding Combo Boxes to a Form Adding Unbound Controls Advanced Report Features Headers and Footers Combining Values From Multiple Fields Adding Calculated Values Working with Subreports Creating Charts Creating Charts in Forms Creating Charts in Reports	Intermediate Relational databases Database normalization Relating tables Implementing referential integrity Working with related tables Lookup fields Subdatasheets Complex queries Joining tables in queries Calculated fields Summarizing and grouping values Advanced form design Adding unbound controls Graphics Adding calculated values Adding combo boxes Advanced reports Creating customized headers and footers Adding calculated values Subreports Charts Charts in forms Charts in reports PivotTables and PivotCharts PivotTables Modifying PivotTables PivotCharts Internet integration Hyperlink fields Working with data access pages	Advanced 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 User Input macros AutoKeys/AutoExec macros Creating macros for data transfer Importing, exporting, and linking objects Importing objects Exporting objects Interacting with the XML documents Linking Access objects Working with Windows SharePoint Services Database management Optimizing resources Replicating and synchronizing databases Security fundamentals Protecting databases Encrypting and decrypting databases User-level security
Computer Training of America Telephone: 413.283.7740 Toll Free: 877.283.7740 Fax: 413.283.7730 www.computertrainingofamerica.com