Access 2016 - Relationships - How To Create One To Many Relationship in Database Between Two Tables
ฝัง
- เผยแพร่เมื่อ 16 พ.ย. 2017
- This tutorial shows you how to create a one to many relationship between two or more tables. Creating relationships and enforcing referential integrity, and enabling cascade options are all covered in this video.
Here is a full list of tutorial videos available on my channel:
Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App
Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions
Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment
Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office
Outlook 2016
Basic Tutorial
Office 2016:
Identify the Components of the Microsoft Office Ribbon
Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems
Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites
Prepare For Your Interview
Negotiating Your Salary
7 Steps of Goal Setting
Resume Writing - Final Draft
The Importance of Networking
Video Requests:
Download GMetrix Test Preparation Software
Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you'd like to learn in our class. So, I encourage you to make a request. I also TH-cam Live Stream once a week to answer your questions!
Instructor A Morgan
Thank you so much... Access has been giving me headaches
😅😅😅😂
The thing looks challenging.
Thank you so much! Very clear, concise and to the point. Better explained than my teacher
This is like the 10th tutorial on relationships, and the first one presented in a way I can understand. THANK YOU!
Could not understand what my textbook was trying to say. Thank you so much for making this simple and easy to understand. Total lightbulb moment!
Great to hear! I appreciate you watching, Javachix.
Thanks a lot for the help. I was getting increasingly frustrated figuring out how to properly link two tables in a one to many relationship. It was easy to follow along with you here!
I'm glad this video was helpful for you, Alfrendo! Thank you for watching and good luck with your database.
Thank you so much for your tutorials! My class went online recently and your lessons are a tremendous help!
Glad I could help!
excellent tutorial. had to watch this to do my assignment because my lecturer made this seem so complicated. Thank you!
Thank you ! I have my AS IT exam in a few days and this really helped
thank you so much! I am new to Microsoft access and I needed to complete an assignment for my business class. This was extremely helpful!
I can’t express how much I appreciate you bro!
Thanks for such a clear and concise explanation! It really clarified the concept for me.
Dude. You helped me solve a problem I have been trying to figure out for days! Thanks for the easy to follow instructions!
Hey I'm glad this helped you out nowmaria. Thanks for watching and for the comment. Have a nice day!
currently studying for my access midterm and this is amazing!! you’re a true legend
Good luck!!
lol...same here
Thank you so much. Watching your tutorial help me so much, better than the current instructor I have now.
WISH I FOUND YOUR CHANNEL EARLIER. Haha I'm studying last minute for my exam and been going through videos all day, yours really have everything i need! Thank you so much!!
Hey I'm glad my videos are helping you out for your exam, Maryam. Thank you for watching and best of luck with your exam!
Man u saved my tomorrow's IGCSE exam, thanks a lot
love love love your no nonsense - lets get it done approach - you saved my life with this one lol
Hey thanks Julie, I'm glad you like the video. Glad it was helpful, let me know if you have any questions. Have a nice day!
Thank you so much. It sure has helped my gradual understanding of the relationship between tables in ACCESS.
U just saved me from alot of headaches. My trouble was not putting the field as a primary key and then I noticed one of your fields as a primary key, Got it!
That's a very common mistake C L. I am glad my video was able to help clear it up for you, thanks for watching!
Thank you for your video. I'm dating myself but I used to make DB's with DBase III as well DB Programs with Clipper. I am trying to get up to speed on this new format that MS uses and your tutorial really helped. Concepts are basically the same its just a new approach to getting things rolling. THANK YOU.
Hey Gary,,
Thanks for watching, I am glad you're learning how to use Access and that my tutorial helped you out. Have a nice day!
IN A FEW MIN, I LEARNED MORE FROM YOU THAN FROM MY PROFESSOR
I'm happy you learned a lot, Timea. Thank you for watching!
You did a good job. I’m completely spasticated with computers, and this helped. Thanks.
Very helpful! I am new to Access and trying to learn on my own. This really helped make it clear.
I'm glad this Access video was helpful for you Laura. Feel free to check out my Access playlist if you're learning more on your own. Have a nice day!
th-cam.com/video/psLJJyNlRXY/w-d-xo.html
Thank you so much!! I HV an exam on access in less than 2 hrs and this is def going to save me..
Broooo Thank you so much I'm a IT Major and one of my classes is computer applications and we have a Microsoft access assignment where we had to do all this bull and you helped 🎉🎉🎉🎉 you rock dude
Thank you so much for, quick, precise, to-the-point info. In under 8 minutes. A lot of the videos I click on for tutorials are hours long. That's just not practical and a lot of the times they mention things that I don't need to know, therefore making the video longer than it needs to be imho.
Glad it helped! I always try to keep my videos short and to the point. Thanks for watching, Michelle!
I was having a hard time with access, this tutorial helped me a lot, thanks
THANK YOU VERY MUCH I needed so much help other youtube chnnels were very complicated
IVE BEEN TRYNA FIGURE THIS OUT FOR MY CLASS THANKKK YOUUUU
You are a very good teacher. Cheers!
Very well explained ! Simplified a complex activity
This helps a lot bro this video was explained well, i have an exam this Monday so my knowldege has improved thanks a lot, i couldn't get access on mac so luckily i'm using my Dad's work laptop that has access on it to practise man i was so stressed thank god for this Channel and this video.
best and simpleste explanation ever made
thank you so much this helped me a lot, i kept forgetting how to make the infinity sign and the 1 appaired on the relationship, but now i understand how to do it. thank you very much sir.
Yoo thank you so much for this vid! Just helped me with a final step in my database exam!
Great video bro. I have a certification exam for Microsoft Access tomorrow and your videos are extremely helpful.
Hey thanks Sebastian. So the Access exam is one of the tougher MOS tests. Definitely learn about subforms and layout and design changes on reports. Not a bad idea to learn about database options in the File Tab too. Glad you like the videos, best of luck with your test. Let me know how you do!
Very helpful. Gracias!
No problem!
Ive got a finals exam in 2 hours this was really useful🙏🙏
OMG, could you be my professor you have helped me out from a teacher that does not teach at all and uses youtube as his teaching method. Your explanation got me an a on my report.
Fantastic explanation, mate
I’m lying in bed watching this at 6am and now I have the insatiable urge to migrate all the data from my expense logs and client spreadsheet into Access
yep I’m that kind of weird
Thank you soooo much! I wish I found your channel 7 weeks ago when my course began! I am having trouble getting my short-text survey responses, imported from Excel, to translate into additional tables in Access. All of your videos have helped me tremendously, especially query writing and relationships! THANK YOU!
Hi Sarah,
No problem, I am happy to help in your course, even if it's the end of the semester! I'm glad my Access playlist was helpful for you. Best of luck with your course and the end of the semester! Have a nice day.
@@ProfessorAdamMorgan Also, I would love to see how to update and delete data in queries (while preserving the original table and creating a new one, if possible), and how to join data from multiple tables in a query. Thanks again!!
Hi Sarah,
Sure, I will add those to my list of video requests. Right now, I am pretty far behind on video requests and have to catch up with some videos for my students. As soon as I am done with that, I will get to adding different types of queries to this playlist.
Hi Prof Morgan! Yes! Of course!! Thanks again, all of this is truly helpful. :-)
No problem Sarah, I appreciate that. Let me know if you have any other questions.
Thank you so much for making this video, it helped me a lot for my bpc 110 class.
No problem Starr, I'm glad it helped you out for your class. Have a nice day!
Terrific explanation. Thank you!
Thank you TigerLily, I appreciate you watching. Have a nice day!
Thanks man! This was really helpful
Excellent explanation.
Nicely done! Thank you.
this helped a lot professor thank you, I just subscribed
Great overview. The thing that would make this perfect is to discuss the primary key.
a giant thanks for explaining this mystery!
Very clear explanation, help me a lot. Thank you.
Very helpful for someone That is Learning all of this but is also wanting to do it better so I can be successful with my Results
Video was very helpful. Thank you
Legend and saviour, your channel is gonna help me ace my course
Good luck in your course, Callan. Thank you for watching!
Thanks alot, this session really helps
This video was awesome! Thank you so much!
Thanks! Very help full
This video was so helpful in order to submit an assignment on time. Five stars from me *****.
Thank you The way you explain it very good
thank you so much.....this helped me and cleared all the confusion i had thank you so much may god bless you
Very good tutorial , much thanks
Thanks Adam, I'm confident I'll ace my exams now, Subscribing!
this super helpful even today
You're beyond awesome! So grateful for your page.
I'm glad to hear that this video was helpful for you, theoriginalsafinette! Thank you for watching, have a great day!
you made it so simple thank you so much!!!
No problem YasminMProductions, thank you for watching!
Thank you...keep up the good work.
Thank you straight and to the point with valid information
No problem Philip, thanks for watching!
Awesome videos! Thanks!
Thanks for watching!
Thank you! This helped alot.
excellent Explanation , thanks a lot please continue to provide more lesions
I’m not even an English speaker but this video has really helped me! Thanks a lot
Hey I'm glad this was able to help you, Nadeen! Thank you for watching!
Help full , thank you
Nicely done! Your presentation is very clear. Thanks
Glad you enjoyed it! Thanks for watching, Peter!
Thank you, very easy to understand, I was flying at first, then got unstuck with the primary key but your videos and playlists are helping loads. Really appreciated.
Glad it helped! Good luck with Primary Keys, thanks for watching, Steven.
SO HELPFUL I ALREADY LOVE YOU
I'm glad it helped you out Mae, thank you for watching!
Thank you very much! ❤️
Excellent tutorial, thanks
Thank you, Luis. I appreciate you watching this video.
Thanks a lot professor Adam, I have my 8th grade computer practical exam tomorrow and it helped me a lot. Thanks
Sameee i was struggling with the enforce referencial integrity part it kept giving me an error but now ill try
@@Wufyiofkes oh nice! I literally didnt even have Access 2016 and literally memorized everything.
Fantastic vide + explanation. Tx
OMG. You are amazing . Thanks
Excellent Explanation, I love you.
I'm glad it worked for you Dun Raksmey, thanks for watching! Have a nice day!
Thanks great video!!
Glad you liked it! Thanks for watching!
You're the man 🙌
Thanks for this. I passed my long test because of this video.🎉
Thank you for keeping the instruction to-the-point. I tried watching videos by another TH-camr (Kirt Kershaw), and despite his thorough instruction, I found his videos to be intolerable because he tends to drag things out more than necessary.
No problem, Phoenix I am glad you enjoyed the video. I am happy my videos are working for you, thank you for watching!
Thank you for this. You saved my life. Tomorrow I am appearing for my computer exam. Thank you
I'm glad this helped you Himanshi, thank you for watching and best of luck with your exam!
Great video. I'm taking an Access class for school, and I was a little lost. Your video really helped.
Hey I'm glad it was helpful and I hope it cleared some things up for you, John. Thank you for watching and have a nice day!
@@ProfessorAdamMorgan , thank you again. Guaranteed I'll be watching more!!!
I'm glad to hear that John, thank you.
I...I think I love you lol. Thank you soooo much for this video!!
Ha thanks Kisha! I appreciate you watching and I'm glad the video helped you out, have a nice day!
Tq Prof, brief and clear explaination
thank you!!! This was very helpful!
Glad it was helpful!
Sir, Your teaching is amazing and very understandable! You are Amazing and I just subscribed and looking forward to your videos.
thanks for the help (from ÉTS, MTL, Canada)
Good stuff right plain and simple, straight to the point cheers!
Thank you very much
Very good video. Helped me a lot!
That's great to know, Anna. Thank you for watching and let me know if you have any other questions. Have a nice day.
Awesome video. Thank you.
Glad it worked for you James. Have a nice day!
helped alot. ty
Good video, very helpful and well executed.
Thank you Jim, I appreciate that. Have a nice day.
Thank you, thank you, thank you!!!
No problem Virginia, thank you for watching. Let me know if you have any questions and I'll try to help!
Thank you bro.
Fantastic thanks so much
You are very welcome
thank you, really helpfull
thanks for the video, very helpful
No problem ThusIsBrad, thank you for watching and for the comment. Have a nice day.