Microsoft Office Tutorials and References
In Depth Information
Creating a Table by Importing an Existing Table Structure
Figure 2-26
Design for the Customer table
Field Name
Data Type
Field Size
Description
Caption
CustomerID
Text
5
Primary key
Customer ID
Company
Text
50
Last
Text
25
Contact’s last name
Last Name
First
Text
20
Contact’s first name
First Name
Phone
Text
14
Address
Text
35
City
Text
25
State
Text
2
Zip
Text
10
Email
Text
50
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 fi 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 fi nal table
structure Oren wants.
To create the Customer table by importing the structure of
another table:
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
dialog box.
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.
Search JabSto ::




Custom Search