Microsoft Access

How can you define a field so that when entering data for that field it will display instead of actual typed text:

• (A) Input Mask
• (B) Validation Rule
• (C) IME Mode
• (D) Indexed

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command?

• (A) File menu
• (B) View Menufot
• (C) Database Menu
• (D) Tools Menu

Which of the following is not a type of relationship that can be applied in Access database:

• (A) One to One
• (B) One to Many
• (C) Many to Many
• (D) All of above

To create relationship between two tables:

• (A) drag the primary key of a table into foreign key of another table
• (B) drag the foreign key of a table into the primary key of another table
• (C) drag any field from parent table and drop on child table
• (D) Any of above can be done to create relationship