Microsoft Access Multi Value Fields
In Microsoft Access 2007 and later versions, there is a little-known feature called "Multi-Value Fields", which allows a field to have more than one value. For example, one person can have more than one hobby. Warning: this feature is a violation of database Normalization rules, which probably explains why it is rarely used. The proper procedure is to use a pointer table, which I have explained in previous videos. However, you should be aware that this "Multi-Value Field" feature exists, because you may encounter it. Also, there might be a question on the Microsoft Certification exams.