If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:

Related MCQs

• 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
• What field type is used to store picture in a table?
• To create a new table, in which method you don’t need to specify the field type and size?
• Which field type will you select when creating a new table if you require to enter long text in that field?
• While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• What do you mean by one to many relationship between Student and Class table?
• What do you mean by one to many relationship between student and class table?
• Which field type can store photos?