Take this
course

Office Productivity / Microsoft

Access 2010 Intermediate

Take your Access 2010 skills to the next level. Learn how to design tables, use action queries, and more.

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.


Instructor: Timothy Miles

Full details

Curriculum

  • Introduction
    Introduction
    3:08
    Course Exercise Files
  • Understanding Table Relationships
    Understanding Table Relationships
    1:40
    The 1 to 1 Relationship
    2:56
    The 1 to Many Relationship
    1:43
    The Many to Many Relationship
    2:36
    Creating a 1 to 1 Relationship
    3:17
    Enforcing Referential Integrity
    17:42
    Creating a 1 to Many Relationship
    3:49
    Creating a Many to Many Relationship
    7:36
  • Introducing Advanced Table Design
    Reviewing the Field Data Types
    13:03
    Setting the Format Property
    15:45
    Using the Input Mask Property
    11:25
    Setting Default Values and Validation Rules
    11:02
    Using the Required and Indexed Properties
    10:30
    Reviewing the Unicode Compression
    4:05
  • Using Action Queries with Imported Data
    Importing vs. Linking External Data
    10:52
    Using the Delete Query
    6:59
    Using the Update Query
    8:10
    Using the Make Table Query
    18:30
    Using the Append Query
    30:46
  • Creating Calculated and Parameter Queries
    Calculating Numbers
    6:20
    Calculating Totals and Using Group By
    6:16
    Concatenating Text
    11:00
    Creating Parameter Queries
    8:12
    Using Wildcards with Your Parameter Entry
    8:40
  • Using Advanced Form Features
    Reviewing the Invisible Table
    6:56
    Removing a Single Control from the Table
    1:47
    Locking and Hiding a Control
    4:03
    Modifying the Layout
    3:32
    Adding an Unbound Control
    4:40
    Adding Calculated Controls
    7:53
    Adding a Combo Box Control
    15:38
    Changing a Control Type
    4:18
  • Advanced Report Functions
    Using the Report Wizard
    7:14
    Reviewing the Report Bands
    2:38
    Manipulating Controls in a Report
    8:23
    Adding Parameters to a Report
    2:00
    Using a Parameter Query with a Report
    8:51
    Using the Group/Sort Panel
    12:08
  • Conclusion
    Course Recap
    3:30

Skills

  • Microsoft Access

Similar Courses

More Courses by this Instructor