How To Creating a Table by Entering Data in Access 2003
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 can 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
In the Database window, click Tables on the Objects bar.
Double-click the Create Table By Entering Data icon.
Enter the data.Press Tab to move from field to field or click in a cell.
To change a field name, double-click the field name, type the new name, and then press Enter.
Click the Save button on the toolbar.
Type a table name, and then click OK.
To have Access set the primary key, click Yes.
Close the Table window.
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
selectors.
|
