Avoid These Mistakes When Creating Relationships in Access

This is a Microsoft Access database tutorial covering, how to create relationships. The tutor starts off by explaining how to add two tables together by creating a one to many relationships. The tutor explains how enforce referential integrity works, along with join types. The tutor then creates a query based on the relationship and then adds a report. The tutor then adds a third table to the relationship window and creates a second query followed by a second report to demonstrate how data is exported from three related tables. How to create relationships in a Microsoft Access database. Access tutorial. Relational database. MS Access tutoring
#msaccess #relationships #database
Join this channel to get access to perks:
/ @itseasytraining1st
Most popular video at the moment:
If you want to support me, check this out: / itseasy
Online training courses:
itseasytrainin...
www.udemy.com/...
Playlists for this channel:
Access: • Unleash the POWER of S...
Excel: • Link web based data in...
Word: • How to use Microsoft W...
Visio: • How to create a basic ...
Project: • How to use Baselines a...
PowerPoint: • Zoom feature in Micros...
Publisher: • How to set or create B...
OneNote: • OneNote Overview, link...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at www.itseasy.co...
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytrainin...
Udemy Courses www.udemy.com/...
Training Guide Books
Excel for New Managers
www.amazon.co....
Microsoft Project Overview www.amazon.co....
Microsoft Visio Basic www.amazon.co....
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv

[@ITsEasyTraining1st]

How to create a relationship in Microsoft Access. Check out courses at www.itseasy.co.uk or online at: www.udemy.com/course/mymicrosoft-access/?referralCode=38E973A16F0D008AE0C3

[@steveoffice365]

Thanks for this so easy

[@ITsEasyTraining1st]

You're welcome 😊

[@EasyMSProject]

Thanks for this

[@ITsEasyTraining1st]

No problem

[@EasyMSAccess]

A good start

[@ITsEasyTraining1st]

Thanks

[@grannysaxton9568]

A good intro

[@ITsEasyTraining1st]

thanks

[@Albertbullterrier]

Useful

[@ITsEasyTraining1st]

Glad you think so!

[@Peter-cc8sm]

Hi thanks for this video , but the second table "project" with the consultid field with no primary key, how do you get that data from first table "consultant"/consultID to the field in the "project table" consultid field ?

[@ITsEasyTraining1st]

Your create a lookup in the Consulid field in the projetc table that looks at the Consultant table first 4 columns

[@Peter-cc8sm]

@@ITsEasyTraining1st Thanks for the answer, is there any where in your videos where you show this "lookup" function so a newbee like me in access can see how its being done :)

[@libreofficetutorials9499]

One to many, many to many and one to one

[@ITsEasyTraining1st]

exactly