How do I structure or restructure my Tables in Access 2007? Restructuring Tables basically means you want to take elements of one Table i.e. data or structure, or both and combine that into another table; thereby, filtering out what you don't want, or as a way to build another Table with a copied structure from another table. Once of the uses is to be able to restructure two tables that have a many-to-many relationships. By taking the elements, or the Primary keys of both tables and their data you can copy that into a third table (copy the structure and data) in an easy way than singly recreating the table elements and copying the data over one record at a time.

Purchase the training video and you can see this in action for yourself!