Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?



Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?..

Answer / Tarun Rohiley

In MS Access, the primary key of one table cannot be used as the primary key in multiple tables. However, if two or more tables share common attributes that can uniquely identify records and are defined as the primary key in each table, those attributes are referred to as a Composite Primary Key.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Access Interview Questions

Is access a good database?

1 Answers  


What is a lookup table in access?

1 Answers  


What do you mean by queries?

1 Answers  


can we call primary key a 'address'????

1 Answers  


How do I get microsoft access 2016?

1 Answers  


Is ms access better than excel?

1 Answers  


List different query types in microsoft access database

1 Answers  


What are the important data types in ms access?

1 Answers  


What is the maximum size of a database that can be opened in Microsoft Access?

1 Answers  


What is microsoft access?

1 Answers  


What are the components of ms access?

1 Answers  


Is access faster than excel?

1 Answers  


Categories