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 2010 Intermediate

Video Description

This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a Table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.

Table of Contents

  1. Introduction
    1. Introduction 00:03:08
  2. Understanding Table Relationships
    1. Understanding Table Relationships 00:01:40
    2. The 1 to 1 Relationship 00:02:55
    3. The 1 to Many Relationship 00:01:42
    4. The Many to Many Relationship 00:02:36
    5. Creating a 1 to 1 Relationship 00:03:16
    6. Enforcing Referential Integrity 00:17:41
    7. Creating a 1 to Many Relationship 00:03:48
    8. Creating a Many to Many Relationship 00:07:35
  3. Introducing Advanced Table Design
    1. Reviewing the Field Data Types 00:13:03
    2. Setting the Format Property 00:15:45
    3. Using the Input Mask Property 00:11:24
    4. Setting Default Values and Validation Rules 00:11:01
    5. Using the Required and Indexed Properties 00:10:29
    6. Reviewing the Unicode Compression Property 00:04:04
  4. Using Action Queries with Imported Data
    1. Importing vs. Linking External Data 00:10:52
    2. Using the Delete Query 00:06:59
    3. Using the Update Query 00:08:09
    4. Using the Make Table Query 00:18:29
    5. Using the Append Query 00:30:45
  5. Creating Calculated and Parameter Queries
    1. Calculating Numbers 00:06:20
    2. Calculating Totals and using Group By 00:06:15
    3. Concatenating Text 00:10:59
    4. Creating Parameter Queries 00:08:12
    5. Using Wildcards with your Parameter Entry 00:08:40
  6. Using Advanced Form Features
    1. Reviewing the Invisible Table 00:06:56
    2. Removing a single control from the table 00:01:46
    3. Locking and hiding a control 00:04:02
    4. Modifying the Layout 00:03:31
    5. Adding an Unbound Control 00:04:39
    6. Adding Calculated Controls 00:07:52
    7. Adding a Combo Box Control 00:15:37
    8. Changing a Control Type 00:04:17
  7. Advanced Report Functions
    1. Using the Report Wizard 00:07:14
    2. Reviewing the Report Bands 00:02:37
    3. Manipulating Controls in a Report 00:08:23
    4. Adding Parameters to a Report 00:01:59
    5. Using a Parameter Query with a Report 00:08:50
    6. Using the Group/Sort panel 00:12:08
  8. Conclusion
    1. Conclusion 00:03:29