Access 2007

Introduction1min 30sec

Understanding Relationships2min 35sec Enforcing Referential Integrity7min 16sec Modifying and Deleting Relationships4min 14sec

Understanding Field Components2min 00sec Accessing Field Properties0min 54sec Using Text-Based Field Types1min 02sec Using Numeric Field Types3min 02sec Using Other Field Types0min 44sec Setting Formats3min 11sec Setting Input Masks5min 35sec Adding Captions1min 35sec Setting Default Values2min 04sec Setting Validation Rules2min 40sec Working with Required Property0min 43sec Working with Indexed Property2min 17sec Working with Unicode Compression Property1min 42sec

Performing Calculations with Queries1min 22sec Concatenating Text9min 18sec Calculating Totals in a Query6min 33sec

Understanding Multi-Table Queries1min 27sec Creating a Multi-Table Query5min 04sec Grouping and Counting Totals8min 05sec Referencing Calculated Fields in Another Query4min 43sec Fixing WHERE Clause Errors3min 59sec Calculating the Top Five Customers1min 10sec

Understanding Action Queries3min 24sec Using Make Table and Append Queries12min 12sec Using Update Queries14min 19sec Using Delete Queries4min 21sec

Understanding Parameter Queries0min 58sec Using a Simple Parameter Query4min 02sec Using Parameter Queries with Wildcards5min 38sec Finding Date Ranges4min 27sec Creating Multi-Parm Queries1min 58sec

Understanding Forms4min 51sec Understanding The Hidden Table1min 28sec Resizing Controls1min 36sec Performing Calculations with Bound Text Boxes3min 41sec Setting Control Properties10min 06sec

Creating a Combo Box9min 33sec Creating a Calculated Control2min 07sec Adding Label and Formatting Control4min 28sec

Using the Report Wizard2min 36sec Using a Calculated Control to Concatenate Text6min 28sec Creating Other Calculated Controls3min 25sec Making the Control Source a Parameter Query9min 29sec Using Report Bands2min 28sec Using the GroupSort Panel4min 33sec

Course Recap1min 32sec