In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

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.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Tips Create a new table in design view by clicking the "Create" tab on the ribbon and clicking "Table Design" in the "Tables" section.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the 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.

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.

I'm trying to create a linked table in Access from an Outlook shared contact list folder. This is easy to do with my own contact list because there is a wizard that can do it for you.