Access 2007 Crash Course: Learn Access in Two Days Training Class

Lesson 1: Getting Started    

Starting Out

Using the Getting Started Window

The Trust Center         

Getting Help

Lesson 2: The New Interface

Using the Quick Access Toolbar       

Basics of Ribbons

The Home Ribbon

Create Ribbon

External Data Ribbon

Database Tools Ribbon

Lesson 3: Creating a Database       

First Steps

About Records

Creating a Table         

Formatting Text         

Lesson 4: Doing More with your Database           

Creating Forms          

Creating Queries        

Reports           

Sorting and Filtering Data     

Viewing Data 

Printing a Database Object    

Lesson 5: Advanced File Tasks       

Using My Computer within Access   

Database Management           

Saving Your Files      

Exporting Files           

Linking Files  

Lesson 6: Working with Tables      

Customizing Tables    

Formatting Tables      

Controlling Table Data Entry

Managing Table Data Entry   

Lesson 7: Working with Forms      

Basic Form Controls  

Advanced Form Controls      

Formatting Your Form           

Formatting Controls   

Formatting Records   

Common Report Tasks 

Lesson 9: Working with Queries    

Basic Queries 

Multiple Table Queries           

Advanced Queries     

Management (Action) Queries

Lesson 10: Advanced Data Management  

Referential Integrity  

Table Relationships    

Switchboards 

Modal Dialogue Boxes          

Lesson 11: Advanced Form Tasks 

Using Subforms         

Advanced Form Tasks           

Exporting Your Form

Lesson 12: Pivoting Data     

Creating a PivotTable

Creating a PivotChart

Using PivotTables and PivotCharts   

Lesson 13: Access and Windows    

Access and Windows

Using the Access Viewer

Lesson 14: Add-ons to Access         

COM Add-Ins

Digital Signatures

Smart Tags

Managing Your Database      

Customizing Access   

Lesson 15: Using Scripts in Access 

Macro Basics  

Other Macro Tasks