Learning Access

Intro to Access	Intermediate Access	Advanced Access
Introducing a database Planning a database Using a database Determining table structure Discussing table relationships Opening Access Changing/Printing views Selecting objects. Creating a database Customizing a database. Navigating through tables/records Adjusting columns Entering/Adding records Finding records Filtering data Deleting records Creating a new table Using the toggle icon Discussing data types Modifying field formats Using Input Masks Accessing Lookup Setting/Removing primary keys Creating new forms Exploring form sections Using controls Formatting properties Inserting graphics	Examining table relationships Establishing relationships Enforcing referential integrity Setting cascade options Printing database objects Creating/Modifying fields Defining validation criteria Setting validation text Modifying an input mask Optimize data usage Displaying records Creating forms in Design View Modifying form properties Customizing form sections Modifying control properties Using the sub form control Applying Calculated Controls Creating/Modifying queries Modifying query properties Specifying criteria in fields Setting join properties Filtering by form Indexing a field Exploring query types Creating a Parameter query Examining Action queries Creating an Action queries Using a Totals query	Opening Access 2000 Creating a new report Designing a report Adding grouping levels Creating a report in Design View Producing reports from queries Moving/Resizing controls Personalizing reports Previewing/Printing reports Exploring report sections Adding a report header Setting section properties Grouping records Using the control toolbox Modifying control properties Inserting a graphic Creating/Using a calculated control Importing/Exporting data Using drag & drop features Inserting a chart Linking existing data Converting a database Backing up a database Restoring a database Compacting and Repairing a database Creating a switchboard Designing a Data Access Page Using group and sort features Saving data in HTML format Creating hyperlinks Encrypting/Decrypting a database Setting/Modifying database passwords Establishing startup options Exploring add-ins Creating replications Using the Macro Builder Running a macro