Access 2013 04 – Relationships




About this tutorial:

Video duration: 11:4
File available here:
Please select: Access2013_DB_04

Topics Covered:

One-To-Many Relationships
Many-To-Many Relationships

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “Access 2013 04 – Relationships

    Joshua Jarvis

    (October 23, 2018 - 4:32 am)

    Your a life saver.

    Alex Cramp

    (October 23, 2018 - 4:32 am)

    Iv made a table with firstname and lastname. if i create another table that also uses firstname and last name. how do i set the relationship up to the first table?

    Anna B

    (October 23, 2018 - 4:32 am)

    This video helped me understand SO much! Thank you!

    Just a question (if you're still active?):
    Since the table junction is just referencing number fields, and we're looking at the second column as being the song (for example). How do you get your combo boxes to sort alphabetically by song name? Rather than the Number/ID?

    Betty Conklin

    (October 23, 2018 - 4:32 am)

    I've been going through several different Access Tutorial videos including Microsoft's, and this is by far the best. The hands-on examples are essential, and yours are superb. Also, you cover more advanced concepts early on, such as multiple primary keys and indexes, and do it in such a way that it is understandable. Thanks so much!

    Meg Megi

    (October 23, 2018 - 4:32 am)

    This video really helped me but i have one question. In the Booking database, in the table  bookings details you can do 2 bookings from the same guest and for the same room, How can i solve this

    PatrickAllenNL

    (October 23, 2018 - 4:32 am)

    THANK YOU this fixed a riddle for me!

    Kevin Meyer

    (October 23, 2018 - 4:32 am)

    thisis all going very fast.

    Nyle Khan

    (October 23, 2018 - 4:32 am)

    Thank you so much. This helped a lot.

    Tyler hansen

    (October 23, 2018 - 4:32 am)

    "In this video I'm gonna be talking you through relationships, uhm the computer kind of course" Love this opening statement

    Access All In One

    (October 23, 2018 - 4:32 am)

    Putting data back together after normalising it is creating a database in a nutshell.

    Access All In One

    (October 23, 2018 - 4:32 am)

    Oops, my bad. I didn't realise this was the 2013 video series. In that case I do believe that I actually show this (go back to video 3) without look ups but explain that I am using look ups to explain what I am trying to do in a more clear and concise manner.

    Access All In One

    (October 23, 2018 - 4:32 am)

    I have another series on 2013. If you check out the first 6 or 7 videos you will find Normalisation without look up fields. I have put a link to video 3 in the description of this video.

Leave a Reply

Your email address will not be published. Required fields are marked *