Access

LEVEL 1	LEVEL 2	LEVEL 3
Introducing Access Examining the Projects Understanding Database Design Using Database Wizards Using the Office Assistant Understanding Tables Using Design View Opening, Saving and Closing Tables Modifying Columns and Rows Using the Table Wizard Working with Field Properties Entering and Importing Data Importing Data to a New Table Sorting Data and Deleting Data Creating and Establishing Relationships Enforcing Referential Integrity Printing and Saving Relationships Using Subdatasheets Using Forms Using the Form Wizard Entering Data in a Form Working in Design View Formatting Form Controls Filtering Data Sorting Filtered Records Creating Single-Table Queries Using the Query Wizard Creating Multi-Table Queries Creating Reports and Auto Reports Using the Report Wizard Previewing Multiple Pages Printing Reports Using the Help Window Using the Contents Card	Examining/Modifying Tables Design View Adjusting Data Types Changing Field Properties Using Default Values Looking at the Office Clipboard Copying and Pasting Data Understanding the Lookup Wizard Using the Input Mask Wizard Using Form Sections Binding Controls and Data Using Calculated Controls Adding Other Controls Creating Queries Using the Query Wizard Adding Tables and Fields Specifying Criteria Working with Query Fields Creating Action Queries Creating Calculated Fields Customizing Reports Using Report Sections Modifying Report Controls Changing Format Properties Adding Controls Using Calculated Controls Working with HTML and Hyperlinks Understanding Access on the Web Creating Web Documents Understanding Hyperlinks Backing up Databases Compacting and Repairing Databases Using Name AutoCorrect Printing Database Objects	Modifying Input Masks Creating Lookup Fields Assigning Multiple-filed Primary Keys Establishing Relationships Defining Cascade Updates and Deletes Specifying Join Properties Creating Forms in Design View Modifying Control Properties Customizing Form Properties Using the Subform Control Creating Switchboards Modifying Queries Creating Totals Queries Creating Parameter Queries Creating Action Queries Modifying Query Properties Creating Reports in Design View Modifying Report/Control Properties Setting Section Properties Using the Subreport Control Running Macros Creating Macros Starting Setup Options Understanding the Web Creating Data Access Pages Grouping/Sorting Data Access Pages Creating Hyperlinks Using the Table Analyzer Wizard Replacing Databases Using Database Security Using the Database Splitter Using the Linked Table Manager Converting Databases Dragging-and-Dropping Data Exporting Data to Excel Creating Data Charts Linking Existing Data