In a junction table, the _____ field consists of the foreign key from both the linked tables.

Related MCQs

• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
• How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
• In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
• In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
• What type of relationship is created when you select a primary key in both related tables?
• The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
• This type of database contains multiple tables that are connected to produce combined output from all tables.
• Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?