www.trainsignal... Whether you are new to Microsoft Access or relational databases in general, this tutorial will help clarify what it means to have a relationship between database tables and explain some common types of relationships.
Thanks a million! pot it Very clear! but still having a problem as follows, after relating all those tables, & you go back to the spreadsheet you only see id numbers, & in case i got a few hundred costumers or/and items i cant manage with numbers. i would be glad to get a answer or a address/link etc were i can get my answer Thanks in advance
i got confused about m to m , can we make many to many relationships without add a junction table, such like this tblEmployees: Employee#(PK) , Project#(FK) tblBookProjects: Project#(PK) , Employee#(FK)
How do you connect tables in a relational database? Using Primary Key Using Current Date Using Foreign Key Using Patient ID Question 2 (1 point) What is the term for a field that uniquely identifies every row in a table in a relational database? Logic Key field Primary key field Foreign key field Memo field Question 3 (1 point) One parent table can have one children only. True or False Question 4 (1 point) A primary key in a parent table can be a foreign key in a child table. True or False Question 5 (1 point) A foreign key is always a primary key in some other table. True False
Why the hell can't you just show how to do in the software? We don't need to waste time for silly, useless presentations. We need to learn how to navigate the software. Theory comes in practice.