Microsoft Access 2007

(Available soon!) The Access 2007 course is divided into 13 chapters containing a total of 126 interactive learning lessons which takes you through the skills and knowledge you need to make effective use of Microsoft Access 2007.

The beauty? It's there all the time, at your elbow - when you need a little help on how to do something, go to your online learning - look it up and get a refresher, in just a few minutes - no need to trouble anyone else and you don't need to remember.

The content covered:

Chapter One: The Fundamentals  

Introduction to Databases 

Starting Access 2007 

The Getting Started Page and Opening a Database 

What´s New in Access 2007 

Understanding the Access Program Screen 

Understanding the Ribbon 

Using the Office Button and Quick Access Toolbar 

Using Keyboard Commands 

Using Contextual Menus 

Using Help 

Chapter Two: Database Basics 

Working with Database Objects 

Tour of a Table 

Adding, Editing and Deleting Records 

Tour of a Form 

Tour of a Query 

Tour of a Report 

Previewing and Printing a Database Object 

Selecting Data 

Cutting, Copying and Pasting Data 

Using Undo and Redo 

Checking Your Spelling 

Using the Zoom Box 

Exiting Access 2007 

Chapter Three: Creating and Working with a Database 

Planning a Database 

Creating a New Database 

Creating a Table 

Modifying a Table 

Creating a Query 

Sorting a Query 

Using AND and OR Operators in a Query 

Creating a Form with the Form Wizard 

Creating a Report with the Report Wizard 

Creating Mailing Labels with the Label Wizard 

Converting an Access Database 

Chapter Four: Finding, Filtering, and Formatting Data 

Finding and Replacing Data 

Sorting Records 

Using Common Filters 

Filtering by Selection 

Filtering by Form 

Creating an Advanced Filter 

Adjusting and Rearranging Rows and Columns 

Changing Gridline and Cell Effects 

Changing the Datasheet Font 

Freezing a Column 

Hiding a Column 

Chapter Five: Working with Tables and Fields 

Understanding Field Properties 

Indexing a Field 

Adding a Primary Key to a Table 

Inserting, Deleting, and Reordering Fields 

Adding Field Descriptions and Captions 

Changing the Field Size 

Formatting Number, Currency, and Date/Time Fields 

Formatting Number, Currency, and Date/Time Fields by Hand 

Formatting Text Fields 

Setting a Default Value 

Requiring Data Entry 

Validating Data 

Creating an Input Mask 

Creating a Lookup Field 

Creating a Value List 

Modifying a Lookup List 

Chapter Six: Creating Relational Databases 

Understanding Table Relationships 

Creating Relationships between Tables 

Enforcing Referential Integrity 

Printing and Deleting Table Relationships 

Understanding of Relationship Types 

Chapter Seven: Working with Queries 

Understanding the Different Types of Queries 

Creating a Multiple Table Query 

Creating a Calculated Field 

Working with Expressions and the Expression Builder 

Using an IIF Function 

Summarizing Groups of Records 

Display Top or Bottom Values 

Parameter Queries 

Finding Duplicate Records 

Finding Unmatched Records 

Crosstab Queries 

Delete Queries 

Append Queries 

Make Table Queries 

Update Queries 

Chapter Eight: Working with Forms 

Creating and Using a Form 

Understanding Form Views 

Modifying a Form in Layout View 

Form Design View Basics 

Changing Tab Order 

Working with Control Properties 

Control Property Reference 

Working with Form Properties 

Form Property Reference 

Changing a Control´s Data Source 

Creating a Calculated Control 

Changing a Control´s Default Value 

Creating a Subform 

Modifying and Working with Subforms 

Chapter Nine: Working with Reports 

Creating a Report 

Working in Layout View 

Adding a Logo 

Working in Design View 

Adjusting Page Margins and Orientation 

Adding Page Numbers and Dates 

Grouping and Sorting 

Summarize Data using Totals 

Using Report Sections 

Chapter Ten: Formatting Forms and Reports 

Formatting Fonts 

Changing Text Alignment 

Changing Colors 

Applying Special Effects 

Using Conditional Formatting 

Adding Pictures, Lines and Gridlines 

Working with Number Formatting 

Using AutoFormat 

Chapter Eleven: Working with Macros 

Creating and Running a Macro 

Editing a Macro 

Working with Macro Groups 

Assigning a Macro to an Event 

Creating Conditional Expressions 

Assigning a Macro to a Keystroke Combination 

Macro Action Reference 

Chapter Twelve: Advanced Topics 

Importing Information 

Exporting Information 

Linking Information from an External Source 

Using Hyperlink Fields 

Displaying Database Object Dependencies 

Setting a Password in Access 

Compacting and Repairing a Database 

Microsoft Office Access 2007 Review 

Index