Microsoft Office Tutorials and References
In Depth Information
Creating a Table by Importing an Existing Table Structure
3. Press the Ctrl+Home keys to scroll to the top of the datasheet. Notice that
the table now contains a total of 176 records—four records you entered plus
172 records imported from the Invoices worksheet. The records are displayed in
primary key order by the values in the Invoice Num column. See Figure 2-25.
Invoice table after importing data from Excel
When you resize a column
to its best fit, only the
visible field values are
affected. You must scroll
down the datasheet to
make sure all field values
for the entire column are
fully displayed, resizing as
you scroll, if necessary.
order by the
values in the
total of 176
4. Save and close the Invoice table, and then close the Navigation Pane.
Two of the tables—Contract and Invoice—are now complete. According to Oren’s
plan for the Belmont database, you need to create a third table, named “Customer,” to
track data about Belmont Landscapes’ residential and commercial customers. You’ll use a
different method to create this table.
Creating a Table by Importing an Existing Table
If another Access database contains a table—or even just the design, or structure, of a
table—that you want to include in your database, you can easily import the table and
any records it contains or import only the table structure into your database.
Oren documented the design for the new Customer table by listing each ﬁ eld’s name;
data type; and size, description, and caption (if applicable), as shown in Figure 2-26.
Note that each ﬁ eld in the Customer table will be a Text ﬁ eld, and the CustomerID ﬁ eld
will be the table’s primary key.