Working with a Table in Design View

graphics/microsoft74_1.gif

Most Access objects are displayed in Design view, which allows you to work with the underlying structure of your tables, queries, forms, and reports . To create a new table in Design view, you can define the fields that will comprise the table before you enter any data. In Design view for tables, each row corresponds to a field. You can edit, insert, and delete fields in your database tables in Design view. You can insert a field by adding a row, while you delete a field by removing a row. You can also change field order by dragging a row selector to a new position.

Create or Modify a Table in Design View

graphics/1_icon.jpg

In the Database window, click Tables on the Objects bar.

graphics/2_icon.jpg

Double-click the Create Table In Design View icon, or click the table you want to modify, and then click the Design button.

graphics/3_icon.jpg

Click in a Field Name cell , and then type a modified field name.

graphics/4_icon.jpg

Click in a Data Type cell, click the Data Type list arrow, and then click a data type.

graphics/5_icon.jpg

Click in a Description cell, and then type a description. If the Property Update Options button appears, if necessary, select an option.

graphics/6_icon.jpg

To insert a field, click the row selector below where you want the field, and then click the Insert Rows button on the Table Design toolbar.

graphics/7_icon.jpg

To delete a field, click the row selector for the field you want to delete, and then click the Delete Rows button on the Table Design toolbar.

graphics/8_icon.jpg

Click the Save button on the toolbar, and then if necessary, enter a table name and click OK.

graphics/9_icon.jpg

When you're done, click the Close button in the Table window.

graphics/03inf09.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net