Creating a Table in the Datasheet View

After you feel comfortable creating new tables in the Design view, you might want to dive right in and create tables in the Datasheet view. Creating tables this way immediately creates a table with 20 field columns and 30 record rows. This method still requires, however, that you enter the Table Design view to specify the key field, the field data types, field descriptions, and any field property changes.

Creating tables in the Datasheet view is really useful only if you feel the need to quickly enter some data into the table before setting up the table's properties. To create a table in the Datasheet view, follow these steps:

  1. In the database window (with the Table icon selected), double-click Create Table by Entering Data . A new table in Datasheet view appears in the Access workspace (see Figure 4.4).

    Figure 4.4. Tables can be created in the Datasheet view.


  2. To enter the field names , double-click any field column heading (Field1, Field2, and so on). Then, type in the field name .

  3. After you have placed the field names, you can begin entering data.

Creating a table in the Datasheet view might be fine for quickly entering data, but you will still probably need to switch to the Table Design view at some point and set up the various field data types and properties.

graphics/datasheetview.gif You can switch to the Design view from the Datasheet view by clicking the View icon on the Table Datasheet toolbar. Remember to save any changes to the table's design that you make in the Design view.


Use Copy and Paste to Build Tables You can copy fields from a table in the Design view and paste these fields into another table that you have open in the Design view. This is an easy way to " borrow " fields from a table and quickly create the structure for a new table. Copy and paste can also be used to copy records and field data from one open table to another (when in the Datasheet view).

Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: