Access - Relationships Foreign Keys
Loading...
Uploader Comments (HugoPhongPresents)
All Comments (7)
-
If you and your accent were giving the lectures I attend, I would learn so much more...
-
@TheLtbiomed, if a field is chosen as pk in one table and if the values(some or all) of that field are also in another table than this field is called fk, very important concept is that pk cannot be same in two tables, if pk in one table and if its values are present in some other table in relationships language we call it fk, fk field values are always set or subset of pk field values, i hope u understand it.
-
doesn't help sorry
-
Field names should not be reserved words or use reserved characters.
Words like 'Date' or 'Index' have special meanings.
In this case the use of the special character '#' in the field names should be avoided. 'ID' would be much more appropriate.
7:56
Table Relationshipsby thesqlspot5,045 views- 1:42
How to Add Foreign-key Relationship Between Entitiesby schemabank16,892 views
- 8:56
Realita Cinta dan Rock n Roll 9/12by sijeruk99,294,055 views
- 6:47
Romania noastra faze tariby mrsica200913,515,399 views
- 10:12
Access Relational Database - Free Training - School Example Part 14by stuartrogermiles9,914 views
- 14:37
Database Tables, Primary Keys, Foriegn Keys, and Relationshipsby minderchen9,695 views
- 8:49
MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to itby primetubervideos14,487 views
- 10:48
Database Design Introductionby ericksonadam18,521 views
- 7:48
An Introduction to Relational Databasesby EasyPHPWebsites80,808 views
- 4:57
Create two tables with relationships in SQL Server Management Studioby ted6021110,766 views
- 4:34
Creating a Many-to-Many Relationship in an Access Databaseby TrainSignalOffice3,904 views
- 9:16
SQL: Understanding the JOIN clause in the SELECT statementby michaelfudge5,909 views
- 4:18
How to Create a Searchable Database - Step 1 of 3: Importing Databy CaspioInc25,661 views
- 8:05
Entity Relationship Modelingby mghuntan10,726 views
- 2:13
How to create an Invoice?by KeySoftVideoportal6,095 views
- 9:34
What is a database?by powdersoftware23,634 views
- 2:38
Access 2007 relationshipsby alanbweaver15,511 views
- 7:52
Access Relationshipsby argeedb3,190 views
- 1:14
iPad 3 - Next Generationby TheVueit1,667,669 views
- 2:33
Relationships Tutorialby nextdbdotnet11,488 views
Thank you for your comments, I do hope the materials were beneficial to you. Perhaps you could write to my students :-)
HugoPhongPresents 3 months ago
What the diffence between the primary key and foreign key ?? please
satriani005 1 year ago
A primary key is a field of data that connects data in multiple tables. A foreign key is just another key in a main table which connects to a primary key separate table.Essentially the foreign keys enable separate to connect to each other.
HugoPhongPresents 1 year ago