MS Access - Relationships Part 1: Relationships with tables
ฝัง
- เผยแพร่เมื่อ 30 เม.ย. 2021
- The best way to store data in multiple tables is using a relational database where there are relationships between tables to avoid redundant and unnecessary data being repeated or removed. This video demonstrates how to create relationships between tables and what the settings mean.
For more videos on databases in Microsoft Access look at our Database playlist:
• MS Access - What is a ...
#MrLongEducation #Access #Relationships
Thank you so much!
Ja lekker man, maar waar is die braai datagrid link met die kole, pot en braai broodjies!?
hello
Could you please make a tutorial on how to make a Ddelhi Log in screen.
thank you =]
We have a video for that. See link below: th-cam.com/video/5kqUQYiC5Sc/w-d-xo.html
There are other examples of project ideas like Log in features, a register screen, etc, in our IT PAT Tips and Hints playlists in the link below:
th-cam.com/video/5kqUQYiC5Sc/w-d-xo.html
@@MrLongITandCAT Thank you =]
Hi, how would you go about inserting into multiple tables where they all have relationships? I get an access error every time :(
Are you inserting from Access or from Delphi?
@@MrLongITandCAT Inserting from Delphi
@@bottleofwater5413 Have you seen this video? th-cam.com/video/uftBuKj9zS0/w-d-xo.html
@@MrLongITandCAT I will take a look :D
@@MrLongITandCATthe video doesn't match my problem exactly as i don't have a table for selection, I have 3 tables, two of which are connected to my main table, two tables have autonumbers and when I try to insert anything into the tables it gives me an access error, I might be trying to do to much at once though :/
hello sir is this in the CAPS curriculum
It's in the IT curriculum but is not asked in practical exams.
first - thank you so much
second where is 21 - MS Access - Relationships Part 2 & 3 & 4 &...........
Glad you like the video. Do you need more videos for more examples?
@@MrLongITandCAT yes - for more depth
@@ehabhamouda7140 Will see what I can do.