I'm studying IS in college and I recently received a project, requiring the development of an online music store using Java and Microsoft Access (the store is to be similar to Amazon, rather than iTunes Music Store).
Basically my problem is that I would like the site to feature several different product types, e.g. Music, DVDs, Games, Books and MP3 Players, as most online music stores would. I just can't figure out how to specialize from a Products table to Music, DVDs, Games, Books and MP3 Players tables using Microsoft Access.
Gah, now that I actually look at those tables, that's a little frightening... I've done this by referencing a product_type_id, then based on that id I will tell the front end where to look for the detailed information.