- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
Importing Data into Tables
You can create new tables from other Access databases by importing and linking tables. When you import a table, you copy data from a table in one Access database and place it in a new table in your database. When you link a table, the data stays in its original location, but you can display and access that data from within your database. If data in the original database changes, the changes will appear in your linked database, too. You can also import data from other programs.
Import a Table from a Database
- Click the External Data tab.
- Click the Import Access Database button.
- Click Browse, locate and select the database file that contains the data you want to import, and then click Open.
- Click the import option you want.
- Click OK.
- Click the tables you want to import. To deselect a table, click the table again.
- Click OK.
- To save import steps, select the Save import steps check box, enter a name and description, and then click Save Import.
Otherwise, click Close.