You can use macros in Access to automate repetitive tasks without writing VBA code. 

When you set a field as a primary key in MS Access, it automatically prevents duplicate values.

A foreign key must match a value in the primary key of the parent table and may not contain a null.

A table in 2NF may still have transitive dependencies.

Normalization follows certain rules for efficiently organizing data in a database. A table is in Boyce-Codd Normal Form (BCNF) when:

You have two tables Employee and Department. An employee belongs to a particular department. You delete a department “Public Relations” from the Department table but all the employees who belong to that department still remain in the Employee table. What database rule have you violated?

Most database problems can be traced back to poor design. Which of the following statements is not correct?