By Cooper Temple
Overview
If you have a table in a Microsoft Access database that would prove useful in another database, it is often easier to copy it rather than to recreate it. Tables can be copied into their original database or into a different one. Depending on the circumstances, some tables can become unnecessary or obsolete and be deleted. Following a few simple steps, tables can easily be copied or deleted from Microsoft Access databases.
Step 1
Launch Microsoft Access.
Step 2
Locate and open the database file (.mdb) that contains the table you want to copy. If you plan to copy a table into a separate database, make certain you open that database, as well.
Step 3
Click once on the table you want to copy.
-
Step 4
Right click once on the table and select "Copy." Click once on the table, once on the "Edit" drop-down menu and select "Copy."
-
Step 5
Right click once in an open area of the database you want to paste a copy of and select "Paste." You can also click once in an open area of the database, once on the "Edit" drop-down menu and select "Paste."
-
Step 6
Type the name of the new table into the "Table Name" field of the Paste Table As pop-up window. You can select how you want to paste the table by clicking "Paste Options" in the pop-up window. Usually, the Structure and Data option will be used, which pastes an exact duplicate of the copied table (data included). The Structure Only option pastes only the field titles and formats of the copied table (no data). The Append Data to Existing Table option combines the copied table with another table. The name of the other table will need to be typed into the "Table Name" field.
-
Step 7
Click "OK" on the Paste Table As window.
Step 8
View and open the new table in the database.
-
Step 1
Launch Microsoft Access.
-
Step 2
Locate and open the database file (mdb) that contains the table you want to delete.
Step 3
Click once on the table you want to delete.
-
Step 4
Right click once on the table and select "Delete." You can also click once on the table, once on the "Edit" drop-down menu and select "Delete."
-
Step 5
Click "Yes" on the pop-up window, when asked if you are certain you want to delete the table.
-
Step 6
Review the database to make certain the table was deleted.
-
How to Delete or Copy a Table in Microsoft Access by electronics-forum.net