Creating a Table by Entering Data

Access allows you to display many of its objects in multiple viewing modes. Datasheet view displays the data in your tables, queries, forms, and reports . Design view displays options for designing your Access objects. You can create a new table in both views. When you create a table in Datasheet view, you enter data and Access creates the table as you type. Access determines the data type of each field based on the data you enter. When you finish entering data, Access will prompt you for the name of the table you've just created.

Enter Data to Create a Table

graphics/one_icon.jpg

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

graphics/two_icon.jpg

Double-click the Create Table By Entering Data icon.

graphics/three_icon.jpg Enter the data.

Press Tab to move from field to field or click in a cell .

graphics/four_icon.jpg

To change a field name, double-click the field name, type the new name, and then press Enter.

graphics/five_icon.jpg

Click the Save button on the toolbar.

graphics/six_icon.jpg

Type a table name, and then click OK.

graphics/seven_icon.jpg

To have Access set the primary key, click Yes.

graphics/eight_icon.jpg

Close the Table window.

graphics/12inf17.jpg

graphics/12inf18.jpg

Did You Know?

You can select or resize a column or row like in Excel . To select a column or row in a table, click the Column or Row selector. To resize a column or row, drag the border between the Column or Row selector.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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