Microsoft Access 2007 Essentials

Video-Based Training with Instructor Deanna Reynolds

Microsoft Access 2007: Beginner

• 1.0 Getting Started
• 1.1 About Relational Databases and Access 2007
• 1.2 Launching Access 2007
• 1.3 Touring the Access Environment
• 1.4 Using the Office Menu
• 1.5 Database Components
• 1.6 Using the Navigation Pane
• 1.7 Getting Help
• 1.8 Opening and Closing Access Databases
• 1.9 Creating an Access Database Using a Preloaded Template

• 2.0 Working with an Existing Table
• 2.1 Exploring Datasheet View
• 2.2 Editing and Selecting Table Data
• 2.3 Adding and Deleting Records
• 2.4 Find and Replace
• 2.5 Undo and Redo

• 3.0 Working with an Existing Form
• 3.1 Exploring Form View
• 3.2 Editing and Selecting Form Data
• 3.3 Adding and Deleting Records
• 3.4 Find and Replace

• 4.0 Sorting and Filtering
• 4.1 Sorting a Table and a Form
• 4.2 About Filters
• 4.3 Common Filters
• 4.4 Filter by Selection
• 4.5 Filter by Form
• 4.6 Advanced Filter

• 5.0 Designing Select Queries
• 5.1 Using the Query Wizard
• 5.2 Using Query Design View
• 5.3 Using Criteria
• 5.4 Sorting and Showing Query Fields
• 5.5 Adding Tables to a Query

• 6.0 Form Basics
• 6.1 Using the Forms Wizard
• 6.2 Using the Form Tool
• 6.3 Working with Form Design View
• 6.4 Working with Form Layout View
• 6.5 Working with Form Controls

• 7.0 Report Basics
• 7.1 Using the Reports Wizard
• 7.2 Using the Report Tool
• 7.3 Working with Report Design View
• 7.4 Working with Report Layout View
• 7.5 Working with Report Controls

• 8.0 Printing Database Objects
• 8.1 Printing Tables or Queries
• 8.2 Printing Forms
• 8.3 Printing Reports

Microsoft Access 2007: Intermediate

• 1.0 Planning and Designing a Database
• 1.1 Database Design Process
• 1.2 Creating a Database Using a Wizard
• 1.3 Creating a Database from Scratch

• 2.0 Building and Modifying Tables
• 2.1 Creating a Table Using a Table Template
• 2.2 About Data Types
• 2.3 Creating a Table in Datasheet View
• 2.4 Creating a Table in Design View
• 2.5 Using Field Templates
• 2.6 Setting Primary Keys

• 3.0 Working with Relationships
• 3.1 Types of Relationships
• 3.2 Referential Integrity
• 3.3 Cascading Updates and Deletes
• 3.4 Multi-Valued Fields
• 3.5 Printing Relationships

• 4.0 Sharing Your Data
• 4.1 Export Your Access Report to Word
• 4.2 Export Your Access Table to Excel
• 4.3 Import Your Excel Spreadsheet into Access
• 4.4 Copying the Table Structure and Data

• 5.0 Enhancing Your Forms
• 5.1 Using the Field List Task Pane
• 5.2 Using the Forms Controls Group
• 5.3 Adding and Formatting Labels
• 5.4 Adding Graphics
• 5.5 Adding Command Buttons

• 6.0 Enhancing Your Reports
• 6.1 Using the Reports Control Group
• 6.2 Adding Graphic Details
• 6.3 Working with White Space and Report Width

Microsoft Access 2007: Advanced

• 1.0 Preventing Data Entry Errors
• 1.1 Using the Lookup Wizard
• 1.2 Data Validation
• 1.3 Working with Combo Boxes
• 1.4 Working with List Boxes

• 2.0 Advanced Table Design
• 2.1 Field Properties
• 2.2 Using Input Masks
• 2.3 Using the Datasheet Total Row
• 2.4 Using Rich Text in the Memo Field

• 3.0 Advanced Query Design
• 3.1 Creating a Calculated Field
• 3.2 Creating a Crosstab Query

• 4.0 Advanced Form Design
• 4.1 Split Forms
• 4.2 Working with the Property Sheet
• 4.3 Changing Control Tab Order
• 4.4 Conditional Formatting
• 4.5 Adding Tab Pages

• 5.0 Advanced Report Design
• 5.1 Creating Groups and Total Reports
• 5.2 Working with Total Fields
• 5.3 Adding Calculated Controls to a Report

• 6.0 Managing Databases
• 6.1 Identify Object Dependencies
• 6.2 Database Documenter

Microsoft Access 2007: Expert

• 1.0 Expertly Designed Select Queries
• 1.1 Single Parameter Queries
• 1.2 Multiple Parameter Queries
• 1.3 Query Joins

• 2.0 Action Queries
• 2.1 Types of Action Queries
• 2.2 Update Queries
• 2.3 Append Queries
• 2.4 Make Take Queries
• 2.5 Delete Queries

• 3.0 Expertly Designed Forms
• 3.1 Creating a Lookup Field
• 3.2 Using a Bitmap as a Form Background
• 3.3 Adding Calculated Controls to a Form

• 4.0 Expertly Designed Reports
• 4.1 Setting Section Properties
• 4.2 Adding Graphics
• 4.3 Arranging Report Data Into Columns

• 5.0 Data Access Pages
• 5.1 Creating a Data Access Page
• 5.2 Editing a Data Access Page
• 5.3 Grouping a Data Access Page
• 5.4 Creating a PivotTable Data Access Page

• 6.0 Macros
• 6.1 Create a Macro
• 6.2 Edit a Macro
• 6.3 Attach a Macro to a Command Button

• 7.0 Database Security
• 7.1 About Database Security
• 7.2 Using a Database Password
• 7.3 Creating Users and Groups