Programs: AA EXP 1.6 M, Hilton Gold, Hertz 5*, AARP Sophomore, 14-time Croix de Candlestick
The Motown Review Store is located in the airside portion of the McNamara Terminal.
I haven't been to DTW since the opening of the North Terminall however, if your connection is wholly within McNamara, you will have no issues with access. If you need to move between the two terminals, you will need to re-clear security (I think).
This list will tell you which terminal (NcNamara or North) each airline uses: