your one source for IT & AV

About Us | Careers | Contact Us | Locations  
Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Access Bits & Bytes: Relationships

SS Course: 1000175

Course Overview


During this one-hour live webinar session, our top-rated instructor will demonstrate how to create formal relationships between tables. Students are encouraged to ask questions in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files required.


Scheduled Classes


What You'll Learn


During this live demonstration you will learn to:

  • Set relationships
  • Use referential integrity
  • Use cascade update & cascade delete


Viewing outline for:
  • Setting relationships
    • In a query
    • Relationship window
      • Adding tables & relationships
    • Parent tables & Child tables
  • Using referential integrity
    • What is referential integrity?
    • Orphan records
    • Setting referential integrity on relationships
  • Using cascade update & cascade delete
    • Setting cascade update and delete
    • Modifying records using cascade update and delete



    Who Should Attend


    Students looking for a more efficient way of using relationships for queries and tools to modify data so that the data has more integrity.

    Next Step Courses


    Other Bits & Bytes sessions and Microsoft Office courses.