Microsoft Access 2003 Tutorial Try for FREE

Introduction

• Course Introduction/Requirements Demo
• Introduction to Access 2003 Demo
• Starting and Using Access Demo
• Creating a New Database Demo
• Setting Options Demo
• Customizing Toolbars Demo
• Access 2003 Assistance Demo
• Design Mode and Normal Mode Demo
• Simple Form Development Demo

Using Access 2003 Databases

• Opening a Database/Creating Shortcuts Demo
• Setting a Simple Password Demo
• Compacting/Repairing a Database Demo
• Converting a Database Demo
• Using the Documentation Feature pt. 1 Demo
• Using the Documentation Feature pt. 2 Demo
• Opening a Form View Demo
• Searching Fields in a Form Demo
• Navigating Records in a Form Demo
• Sorting Records in a Form Demo
• Filtering Records in a Form Demo
• Data Entry Tips and Tricks Demo
• Printing Forms and Reports Demo

Creating Database Objects - Tables

• Creating Tables Demo
• Fields/Names/Indexes Demo
• Data Types Demo
• Primary Keys Demo
• Field Validation (Required) Demo
• Field Validation (Rules) Demo
• Lookup Fields Demo
• Setting Default Values Demo
• Using Input Masks pt. 1 Demo
• Using Input Masks pt. 2 Demo
• Making Captions Demo

Creating Database Objects - Forms

• What is a Form?
• Using the Form Wizard
• Creating a Form Manually
• Using the Toolbox/Adding Controls
• Sizing and Aligning Controls
• Form Properties/Caption/Default View
• Form Field Properties
• Tabbing/Tab Order/Tab Stops
• Form Field Cosmetic Properties
• Adding a Text Field
• Formatting Field Values

Creating Database Objects - Queries

• What is a Query?
• Creating a Query in Design View
• Using the Query Wizard
• Moving Fields in a Query
• Sorting Query Results
• Setting Search Criteria in a Query
• Using Operators and Wildcard Characters
• Searching for a Range of Values
• Using AND/OR/NOT in a Query
• Creating Parameter Queries

Creating Database Objects - Reports

• What is a Report?
• Using the Report Wizard
• Creating a Report Manually
• Adding Fields to a Report
• Using Report and Page Sections
• Setting Page Breaks and Margins
• Adding Lines and Boxes
• Adding Images to a Report
• Setting Field Properties

Using the Properties Window

• The Properties Sheet
• Format Properties pt. 1
• Format Properties pt. 2
• Event Properties
• Data Properties
• Other Properties

Using the Expression Builder

• Opening the Expression Builder Tool
• What are Expressions?
• Expression Builder Parts
• Using String Operators
• Using Values in Other Forms
• Using SQL Aggregate Functions
• Using the IIf Function

Relational Databases

• What is a Relational Database?
• Primary and Foreign Keys
• The Relationships Window
• Creating Relationships Between Tables
• Editing Relationships
• Resetting the AutoNumber Field
• Fixing Data For Relationships
• Setting Relationships in a Query

Advanced Forms Design

• Creating a Switchboard Form
• Using the Switchboard Manager
• Creating Admin Tables/Forms
• Adding a Combo Box
• Setting Combo Box Properties Manually
• Setting Control Default Properties
• Adding a Subform with the Wizard
• Adding a Subform Manually
• Creating Calculated Fields pt. 1
• Creating Calculated Fields pt. 2

Advanced Queries

• Using SQL View
• Creating Relational Queries
• Grouping in Queries (Aggregates)
• Creating Update Queries
• Creating Delete Queries
• Using Null Values in a Query
• Creating Additional/Calculated Fields

Advanced Reports

• Connecting Reports to Queries
• The Sorting and Grouping Window
• Cleaning up the Report pt. 1
• Cleaning up the Report pt. 2
• Using Counts and Sums by Group
• Advanced Report Formatting
• Using the Labels Wizard

Course Wrap up

• Final Thoughts

Credits

• About this Author