MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Access 2007 Part 2: Tables and Relationships

Course Summary

Part 2 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report dat

  • +

    Course Syllabus

    ● Building Tables
        ◦ Overview of Methods for Building Tables
        ◦ Building Picaroon's Main Employee Table (tblEmployees)
        ◦ Introduction to Table Naming Conventions
        ◦ Overview of Different Data Types
        ◦ Adding Records
        ◦ Navigating in Datasheet View
        ◦ Building tblHRData in Design View
        ◦ Keyboard Shortcuts for Design View
        ◦ Looking at Table Templates
        ◦ What We Covered
    ● Modifying Tables
        ◦ Controlling Data Entry
        ◦ Using Formats
        ◦ Using Input Masks
        ◦ Using Data Validation
        ◦ Using Look-Up Fields
        ◦ Indexing
        ◦ Unicode Compression, IME Mode/IME Sentence Mode
        ◦ Smart Tags
        ◦ Functioning Inside Tables
        ◦ Customizing Tables
        ◦ What We Covered
    ● Building and Modifying Tables: Extra Practice
        ◦ What's the Plan Again?
        ◦ Build Our Customer and Orders Table
        ◦ Build Our Author and Products Table
        ◦ Build the Rest of Our Tables
        ◦ What We Covered
    ● Creating Relationships
        ◦ Relationships Overview
        ◦ Creating a One-To-One Relationship
        ◦ Creating a One-To-Many Relationship
        ◦ Enforcing Referential Integrity
        ◦ Turning on Cascade Update and Cascade Delete
        ◦ Introduction to Subdatasheets
        ◦ What We Covered
    ● Advanced Relationships
        ◦ Data Limits with Previous Relationships
        ◦ The Need for Other Relationships
        ◦ Many-To-Many
        ◦ Example 2 of Many-to-Many Relationship
        ◦ Pass-Through Relationship
        ◦ What We Covered


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top