Microsoft Access Question

Hi, I am new to MS Access but have used other MS products for decades.  I am trying to figure out a solution to this problem.  I have 5 categories (with 1 to many locations associated to a category)...