O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access 2007 Intermediate

Video Description

This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

Table of Contents

  1. Introduction
    1. Introduction 00:01:31
  2. Relational Database Concept Overview
    1. Understanding Relationships 00:02:36
    2. Enforcing Referential Integrity 00:07:17
    3. Modifying and Deleting Relationships 00:04:15
  3. Table Design
    1. Field Components 00:02:01
    2. Accessing Field Properties 00:00:54
    3. Using Text-Based Field Types 00:01:03
    4. Using Numeric Field Types 00:03:02
    5. Using Other Field Types 00:00:44
    6. Setting Formats 00:03:12
    7. Setting Input Masks 00:05:36
    8. Adding Captions 00:01:35
    9. Setting Default Values 00:02:05
    10. Setting Validation Rules 00:02:41
    11. Required Property 00:00:43
    12. Indexed Property 00:02:18
    13. Unicode Compression Property 00:01:43
  4. Calculations
    1. Performing Calculations with Queries 00:01:23
    2. Concatenating Text 00:09:18
    3. Calculating Totals in a Query 00:06:34
  5. Multi-Table Queries
    1. Understanding Multi-Table Queries 00:01:28
    2. Creating a Multi-Table Query 00:05:04
    3. Grouping and Counting Totals 00:08:05
    4. Referencing Calculated Fields in Another Query 00:04:44
    5. Fixing WHERE Clause Errors 00:04:00
    6. Calculating the Top Five Customers 00:01:11
  6. Action Queries
    1. Understanding Action Queries 00:03:25
    2. Using Make Table And Append Queries 00:12:12
    3. Using Update Queries 00:14:19
    4. Using Delete Queries 00:04:21
  7. Parameter Queries
    1. Understanding Parameter Queries 00:00:59
    2. A Simple Parameter Query 00:04:02
    3. Parameter Queries With Wildcards 00:05:38
    4. Finding Date Ranges 00:04:27
    5. Creating Multi-Parm Queries 00:01:59
  8. Calculations In Forms
    1. Understanding Forms 00:04:52
    2. Understanding The Hidden Table 00:01:28
    3. Resizing Controls 00:01:36
    4. Performing Calculations With Bound Text Boxes 00:03:41
    5. Setting Control Properties 00:10:07
  9. Advanced Form Functions
    1. Creating a Combo Box 00:09:34
    2. Creating a Calculated Control 00:02:08
    3. Adding Label and Formatting Control 00:04:29
  10. Advanced Report Functions
    1. Using The Report Wizard 00:02:37
    2. Using A Calculated Control To Concatenate Text 00:06:28
    3. Creating Other Calculated Controls 00:03:25
    4. Making The Control Source A Parameter Query 00:09:29
    5. Using Report Bands 00:02:29
    6. Using The Group/Sort Panel 00:04:34
  11. Conclusion
    1. Conclusion 00:02:38