Microsoft Access 2003 Tutorial Video

Introduction

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

Using Access 2003 Databases

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

Creating Database Objects - Tables

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

We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.

$99.95

Creating Microsoft Access 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 Tutorials
• Using Report and Page Sections
• Setting Page Breaks and Margins
• Adding Lines and Boxes
• Adding Images to a Report
• Setting Field Properties

Using the Microsoft Access Properties Window

• The Properties Sheet
• Format Properties Tutorials 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 in Microsoft Access

• What is a Relational Database?
• Primary and Foreign Keys Tutorials
• 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 Tutorials 1
• Creating Calculated Fields pt. 2

Advanced Queries in Access

• 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 in Access

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

Tutorial Wrap up

• Final Thoughts

Training CD Credits

• About this Author and this Training Course