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:

Related MCQs

• 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
• How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
• While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
• After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
• After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
• What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
• When entering field name, how many characters you can type in maximum?
• Which field type will you select when creating a new table if you require to enter long text in that field?