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

Product Information

  • Title: Access 2007 Intermediate
  • Author(s): Tim Miles
  • Release date: January 2013
  • Publisher(s): Intellezy
  • ISBN: 00004COMPUWORKS