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