Microsoft® Access 2007 Crash Course:  Learn Access in Two Days!

Length: 2 days
Prerequisites: Familiarity with the Windows operating system.

Target Student:  The Access 2007 Crash Course is designed for those who want to learn basic through advanced skills in a fast-paced environment.  Users will learn the fundamentals of setting up tables and relationships upon which everything else in Access depends.   Queries, Forms, and reports are covered in detail, as well as the features of the 2007 version.

Course Content

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   

 

         

Lesson 8: Working with Reports    

Organizing Report Data         

Formatting Reports    

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 

Click here for course cost and dates