Microsoft Office Access Lesson #16 - How to create Relationships
28,945 views (518 Site Views) ~ Last Updated on June 03, 2011

Inside of Access Database, this video will show exactly how to create a relationship between to or more tables.
This is a very simple procedure to do, and does not take a brain surgen to do it, as certain people in the field
May want to imply.

Just remember, that when you create a relationship between the tables, you must have an ID that connects the table to the next table and so on.
And that the ID of the first table, must be an AutoNumber.

Download the sample database from here
http://www.cffcs.com/Main.asp?Entry=15

Thank You
Wayne Barron
Carrz-Fox-Fire Promotions
http://www.enterview.org/Carrz-Fox-Fire_Promotions
Dark Effects TV
http://www.enterview.org/Dark_Effects_Production

Tags
access database,database,access,create relationship in access,create relationship,microsoft Access,Microsoft Access 2010
Microsoft Access Database Lesson #1 - Create Tables, Relationships, and Add Data
2,745 views
483 Site Views
Microsoft Access Database Lesson #2 - Creating Form and Adding records to it
3,311 views
461 Site Views
Microsoft Access Database Lesson #3 - Formating our Form with a style for look and appearance
2,081 views
508 Site Views
Microsoft Access Database Lesson #4 - Add Header to our Form
9,978 views
470 Site Views
Microsoft Access Database Lesson #5 - Change Form Layout
6,561 views
489 Site Views
Microsoft Access Database Lesson #6 - Adding Navigation Buttons to our Form
6,481 views
504 Site Views
Microsoft Access Database Lesson #7 - Adding Save, Delete, and Add New Button to our Access Form
56,071 views
551 Site Views
Microsoft Access Database Lesson #8 - Adding subform to enter data into another table
18,195 views
564 Site Views
Microsoft Access Database lesson #9 - Making the form look better inside of a Tab Control
7,724 views
498 Site Views
Microsoft Office Access Lesson #10 - Export Tables To New Database
530 views
526 Site Views
Microsoft Office Access Lesson #11 Database Queries and Relationships
1,571 views
502 Site Views
Microsoft Office Access Lesson #12 Convert accdb to mdb
45,004 views
537 Site Views
Microsoft Office Access Lesson #13 Relationship to connect multiple tables together
54,536 views
543 Site Views
Microsoft Office Access Lesson #14 - Multiple Databases with linked tables
26,073 views
467 Site Views
Microsoft Office Access Lesson #15 - .mdb database to the new .accdb data format
26,747 views
505 Site Views
Microsoft Office Access Lesson #16 - How to create Relationships
28,945 views
518 Site Views
Microsoft Office Access Lesson #17 - Form Button Wizard Does not appear
670 views
480 Site Views
@Microsoft @Office - We Can't Install The 64 bit Version Of Office Because Of 32 bit Office
17,057 views
491 Site Views