Microsoft Office Tutorials and References
In Depth Information
Creating a Table by Importing an Existing Table Structure
Design for the Customer table
Contact’s last name
Contact’s first name
Sarah already created an Access database containing a Customer table design. She
never entered any records into the table because she wasn’t sure if the table design was
complete or correct. After reviewing the table design, both Sarah and Oren agree that it
contains some of the ﬁ elds Oren wants to track, but that some changes are needed. So,
you can import the table structure in Sarah’s database to create the Customer table in the
Belmont database, and then modify the imported table to produce the ﬁ nal table
structure Oren wants.
To create the Customer table by importing the structure of
1. Make sure the External Data tab is the active tab on the Ribbon.
2. In the Import & Link group, click the Access button. The Get External Data -
Access Database dialog box opens. This dialog box is similar to the one you used
earlier when importing the Excel spreadsheet.
3. Click the Browse button. The File Open dialog box opens. The Access database
file from which you need to import the table structure is named “Sarah” and is
located in the Access1\Tutorial folder provided with your Data Files.
4. Navigate to the Access1\Tutorial folder, where your starting Data Files
are stored, and then double-click the Sarah database file. You return to the
5. Make sure the Import tables, queries, forms, reports, macros, and modules
into the current database option button is selected, and then click the OK
button. The Import Objects dialog box opens. The dialog box contains tabs for
importing all the different types of Access database objects—tables, queries,
forms, and so on. The Tables tab is the current tab.
6. Click the Options button in the dialog box to see all the options for importing
tables. See Figure 2-27.