1. Choose File, then click New
2. Click the New button from the Toolbar
3. Type your Database name in the open Filename Dialog Box
4. Click Create button; your Database Name appears on screen which is completely blank at this point.
How to Create a Table Using the Design View
1. In the Database window, click Tables Tab.
2. choose New, then click the Design View option. In the Design View Dialog box, create details of your table.
3. Click OK.
4. In the fieldname column of the Design View, enter the first field name
5. Press the Tab or the Enter Key to move the insertion point to the next column which is Data Type.
6.Click the down arrow button to view the list of data types available for defining a field.
7. Press the Tab key again to move the insertion point to the next column.
8. Define all the fields for your table. Click the Table View button from the Toolbar.
9. Save your new table, the Access display the message:
Save As
Save Table 'Table4' To:
OK
CANCEL
As
10. Click Yes, then type the filename in the Save As Dialog Box
11. Click the Yes Button to create a primary key for your table.
Posts
No comments:
Post a Comment