Microsoft Access 2003

£29 (plus vat)

The Access 2003 course is divided into 11 chapters containing a total of 155 interactive learning lessons which takes you through the skills and knowledge you need to make effective use of Microsoft Access 2003.

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 

What´s New in Access 2003? 

Starting Access and Opening a Database 

Understanding the Access Program Screen 

Using Toolbars 

Hiding, Displaying, and Moving Toolbars 

Filling Out Dialog Boxes 

Keystroke and Right Mouse Button Shortcuts 

Opening and Modifying Database Objects 

Working with Multiple Windows 

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 

Checking Your Spelling 

Getting Help from the Office Assistant 

Changing the Office Assistant and Using the “What´s This” Button 

Using the Zoom Box 

Closing a Database and Exiting Access 

Chapter One Review 

Chapter Two: Creating and Working with a Database 

Planning a Database 

Creating a Database Using the Database Wizard 

Creating a Blank Database 

Creating a Table Using the Table Wizard 

Modifying a Table and Understanding Data Types 

Creating a New Table from Scratch 

Creating a Query in Design View 

Modifying a Query 

Sorting a Query using Multiple Fields 

Developing AND and OR Operators 

Creating a Form with the Form Wizard 

Creating a Report with the Report Wizard 

Creating Mailing Labels with the Label Wizard 

Database Object Management 

File Management 

Compacting and Repairing a Database 

Converting an Access Database 

Chapter Two Review 

Chapter Three: Finding, Filtering, and Formatting Data 

Finding and Replacing Information 

Sorting Records 

Filtering by Selection 

Filtering by Form 

Creating an Advanced Filter 

Adjusting Row Height and Column Width 

Rearranging Columns 

Changing Gridline and Cell Effects 

Freezing a Field 

Hiding a Column 

Changing the Datasheet Font 

Chapter Three Review 

Chapter Four: Working with Tables and Fields 

Understanding Field Properties 

Indexing a Field 

Adding a Primary Key to a Table 

Inserting, Deleting, and Reordering Fields 

Changing a Field´s Data Type 

Using Field Descriptions 

Adding a Caption 

Change 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 Four Review 

Chapter Five: Creating Relational Databases 

Understanding Table Relationships 

Creating Relationships between Tables 

Enforcing Referential Integrity 

Testing Referential Integrity and Deleting a Relationship 

Understanding of Relationship Types 

Chapter Five Review 

Chapter Six: Working with Queries 

A Quick Review 

Creating a Multiple Table Query 

Creating a Calculated Field 

Using Expressions 

Using an IIF Function 

Summarizing Groups of Records 

Using Criteria 

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 Six Review 

Chapter Seven: Working with Forms 

Creating a Form with AutoForm 

Modifying a Form 

Adding and Deleting Fields 

Moving and Sizing Controls 

Changing the Tab Order 

Working with Control Properties 

Control Property Reference 

Working with Form Properties 

Form and Report Property Reference 

Working with Multiple Controls 

Adding, Cutting, Copying, and Pasting Controls 

Changing a Control´s Data Source 

Creating a Calculated Control 

Changing a Control´s Default Value 

Using the Control Wizard 

Creating a Subform 

Modifying and Working with Subforms 

Chapter Seven Review 

Chapter Eight: Working with Reports 

Creating a Report with AutoReport 

Modifying a Report 

Adding and Deleting Fields 

Moving and Sizing Controls 

Adjusting Page Margins and Orientation 

Adding Page Numbers and Dates 

Understanding Report Sections 

Grouping and Sorting Records 

Creating Calculated Controls 

Working with Section Properties 

Creating Charts with the Chart Wizard 

Chapter Eight Review 

Chapter Nine: Formatting Forms and Reports 

Formatting Fonts with the Formatting Toolbar 

Changing Text Alignment 

Using AutoFormat 

Changing Colors 

Applying Special Effects 

Using the Format Painter 

Adding Pictures and Lines 

Aligning Controls with One Another 

Changing a Control´s Formatting Properties 

Chapter Nine Review 

Chapter Ten: 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 Ten Review 

Chapter Eleven: Advanced Topics 

Importing Information 

Exporting Information 

Importing Objects from another Access Database 

Linking Information from an External Source 

Analyzing Records with Microsoft Excel 

Exporting Records to Microsoft Word 

Mail Merging Records to Microsoft Word 

Using Hyperlink Fields 

Using OLE Object Fields 

Chapter Eleven Review 

Index