How to Add a New Table to a Split Database in MS Access 2007
In the Microsoft Access 2007 program, which is part of the Microsoft Office 2007 software suite, you can design databases that can be shared by multiple users. The easiest way to share a database among users is to create a split database, where data is stored in both a front-end and a back-end file. After splitting a database in Access 2007, you can still add new tables, provided they are linked to both parts of the split file.
Other People Are Reading
Instructions
-
-
1
Open the split Access database where you want to add a new table.
-
2
Go to the "Create" tab at the top of the window and choose the "Table" option.
-
-
3
Enter any desired fields that you want to add to your new table.
-
4
Right-click on the new table's icon and choose "Rename" to give the table a custom name.
-
5
Go to the "Database Tools" tab at the top of the window.
-
6
Click on the "Relationships" button in the toolbar, and then hit the "Edit Relationships" option.
-
7
Select the "Create New" option.
-
8
Select one of the old tables from the split database as the "Left Table Name" and select the new table as the "Right Table Name."
-
9
Hit "OK" to save the relationship and link the two tables within the split database.
-
1
References
- Photo Credit laptop with database record on 15.4" wide screen image by .shock from Fotolia.com
