Microsoft Access Tutorial - How to Create Multiple Tables
1. Design View
One way is to simply use the design view wizard to create multiple tables in your database. This is the easiest and most obvious way to create multiple tables.
2. Import Table
Another way would be to right click on the right pane of the main Access dialog box and click on "Import". Select the Microsoft Access file that has the tables you want to import into this Access database.
3. Drag and Drop
If you have two Microsoft Access databases open in two separate windows, you can drag and drop a table from one database into the other. You do this by making sure there are 2 instances of Microsoft Access open (each database is open in its own Microsoft Access window). Click on "Tables" on the left pane of both windows so that the tables are displayed. Drag and drop a table icon from one window into the right pane of the other one. This will be the equivalent of copying that table (the fields and data) from the original database and pasting it into the new database.
4. Copy and Paste
You can duplicate a table you currently have by simply copying and pasting it on the right pane. Right-click the table icon and click copy (Edit -> Copy) and then right-click anywhere on the right pane where it is blank and click paste (Edit -> Paste).
For this example I will copy and paste the table called People. Right click on the table called People, click on copy. Right click anywhere on the right pane and click paste. It will ask you to give this table a name. Call it anything you want. For this example, I will call it People2. For the paste options you have the chance to select between "structure only", "structure and data", and "append data to this table". For this example I will choose "structure and data".
Once you have made the selection and enter the table name click OK. Now you will see the additional table that you just pasted on the right pane. If you double click and open the People2 table you will see that it is exactly the same as the original People table.
This new table, is a second table and is totally separate than the original one. You can make changes to this People2 table and it will not affect anything in the original People table.
This is probably the easiest and simplest way to create multiple tables very fast in Microsoft Access, but I would not recommend it because it will result in 2 tables with exactly the same fields and data.
Published by Kantus
I love writing short stories and humor articles, but tend to stick with topics that are discoverable by search engines and capable of spreading virally. View profile
- Microsoft Access - 4 Steps to Adding Data to a Database TableStep by Step guide to adding actual data into a Microsoft Access database table.
- RDBMS DatabaseA brief overview of RDBMS databases.
- Microsoft Access Tutorial: How to Query an Access TableThis tutorial shows you how to make one of the simplest queries against a table.
Microsoft Access Tutorial: Executing a SELECT StatementA brief overview of how to use simple SELECT statements with an Access database table.
Microsoft Access Tutorial: Execute INSERT Statement Using Access WizardUsing the built-in wizard, you can execute an INSERT statement. This tutorial shows you how.
- How to Import Microsoft Excel Data Into Microsoft Access
- How to Use Turbo Lister 2 to Create EBay Listings that Sell
- Working with Access VBA
- How to Create a Database Using Microsoft Access
- Three Simple Access Database Administration Tips
- Microsoft Access Tutorial - 4 Steps to Creating a Database
- Microsoft Access Tutorial - 5 Steps to Creating a Database Table