Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

Access doesn’t directly support a many-to-many relationship, so you must create a third table: an “associate table.” It contains a primary key and a foreign key to each of the data tables.

Access's design view helps minimize confusion when editing tables, as it displays every field and property in a single view, allowing you to see the structure of the entire table.

Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.