Microsoft Office Access Lesson #16 - How to create Relationships
28,945 views (484 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
450 Site Views
Microsoft Access Database Lesson #2 - Creating Form and Adding records to it
3,311 views
432 Site Views
Microsoft Access Database Lesson #3 - Formating our Form with a style for look and appearance
2,081 views
477 Site Views
Microsoft Access Database Lesson #4 - Add Header to our Form
9,978 views
434 Site Views
Microsoft Access Database Lesson #5 - Change Form Layout
6,561 views
455 Site Views
Microsoft Access Database Lesson #6 - Adding Navigation Buttons to our Form
6,481 views
461 Site Views
Microsoft Access Database Lesson #7 - Adding Save, Delete, and Add New Button to our Access Form
56,071 views
515 Site Views
Microsoft Access Database Lesson #8 - Adding subform to enter data into another table
18,195 views
523 Site Views
Microsoft Access Database lesson #9 - Making the form look better inside of a Tab Control
7,724 views
464 Site Views
Microsoft Office Access Lesson #10 - Export Tables To New Database
530 views
495 Site Views
Microsoft Office Access Lesson #11 Database Queries and Relationships
1,571 views
475 Site Views
Microsoft Office Access Lesson #12 Convert accdb to mdb
45,004 views
506 Site Views
Microsoft Office Access Lesson #13 Relationship to connect multiple tables together
54,536 views
504 Site Views
Microsoft Office Access Lesson #14 - Multiple Databases with linked tables
26,073 views
433 Site Views
Microsoft Office Access Lesson #15 - .mdb database to the new .accdb data format
26,747 views
473 Site Views
Microsoft Office Access Lesson #16 - How to create Relationships
28,945 views
484 Site Views
Microsoft Office Access Lesson #17 - Form Button Wizard Does not appear
670 views
447 Site Views
@Microsoft @Office - We Can't Install The 64 bit Version Of Office Because Of 32 bit Office
17,057 views
459 Site Views