• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Creating a Table > Creating a Table Using the Table Wizard

Creating a Table Using the Table Wizard

The Table Wizard helps you start a new table and set up its fields. The wizard provides dozens of sample fields that you might find in both business and personal databases.

To create a table using the Table Wizard:

1.
In the Database window, click the Tables tab.

2.
Click the New button on the Database window toolbar.

3.
In the New Table dialog box, choose Table Wizard from the list (Figure 31.16).

Figure 31.16. Select Table Wizard in the New Table dialog box.


4.
Click OK.

5.
In the first page of the Table Wizard, click Business or Personal to choose a database type.

6.
Click a table in the list of Sample Tables, and then double-click a field in the list of sample fields to add the field to your table (Figure 31.17).

Figure 31.17. Add fields to the new table.


7.
Continue adding other fields from the same sample table or other sample tables until you have all the fields you need, and then click Next.

8.
In the next page of the Table Wizard, enter a name for the table and let Microsoft Access set the primary key field or choose to do it yourself, and then click Next (Figure 31.18).

Figure 31.18. Name the new table and select a primary key.


If you decide to set the primary key, you choose it in a separate Table Wizard step, selecting a field from a drop-down list and then specifying how the numbers are added.

9.
In the next page of the Table Wizard, choose one of the existing tables to relate to the new table, and then click Next (Figure 31.19).

Figure 31.19. Select relationships between the new table and other tables.


If you are establishing a new relationship or changing an existing one, click Relationships, and then in the Relationships dialog box, choose one of the three options to define a relationship between the two tables, and then click OK (Figure 31.20).

Figure 31.20. Define or change a relationship.


10.
In the final page of the Table Wizard, choose to modify the design, start entering data, or enter data using a form that the wizard creates, and then click Finish (Figure 31.21).

Figure 31.21. Click Finish to set up the table.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint