How to define composite keys in MS Access?

Question

I am new to MS Access. Could anybody tell me how to define a composite primary key in MS Access 2007.

Answer 1

If memory serves correctly, you can hold SHIFT while selecting the fields in the design view. Once you've selected all of the fields that are to be part of the key, press the primary key button.