In this Microsoft Access video tutorial, you will learn how to create composite keys, which are table keys based on multiple fields: COMPOSITE KEYS

Access Tip Composite Keys Upload Images   Link  Jim O  4 years ago Having a problem setting up a composite key for names where some of the fields are blank. I can set it up for FirstName and LastName, but if I try to add a Middle Name (that may be blank) I can't get it to work. Read More... Jim O Reply from Alex Hedley: How would that work if there was a null, the point is to create no duplicates among two or more fields. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Composite Keys Upload Images   Link  Kathy  8 years ago I want to be able to use two fields in combination to uniquely identify a record. For example, I want to have an Item Number and a Production Line in combination (i.e. Item Number "4060" and Production Line "Line 1" is a record; and Item Number "4060" and Production Line "Line 2" is a record. Is this possible? Read More... Reply from Richard Rost: Yep. That's what composite keys are for. More importantly, composite keys ensure that that COMBINATION of data is unique. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Composite Keys Upload Images   Link  seda bulut  8 years ago this site is superb. thanks fo your tips Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

store calculated values Upload Images   Link  Jerry P  8 years ago Composite Keys : When or should you store calculated values in a database? Reply from Richard Rost: The ONLY time I recommend storing calculated values is when SPEED is an issue. If you have a complex calculation and you need to spit out long reports FAST, then it may make sense to store the calculated result, especially if it doesn't need to be recalculated frequently. Read More... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.