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

D. Obtaining or Creating the Sample Data... > D.4. Creating the PUBLISHERS Table

Creating the PUBLISHERS Table

Once again, follow the same basic steps listed in Section D.2 to create the PUBLISHERS table. Field definitions for the PUBLISHERS table are shown in Table D-7.

Table D-7. Fields of the PUBLISHERS table

Field Name

Data Type

PubID

Text

PubName

Text

PubPhone

Text

Once again, there is only a single property that you need to set, as shown in Table D-8.

Table D-8. Single property to set for the PUBLISHERS table

Field Name:

PubID

Property:

Indexed

Value:

Yes (No Duplicates)

Designate PubID as the primary key, and save the table as PUBLISHERS.

Once you’ve finished creating the PUBLISHERS table, you can enter data into it. The PUBLISHERS table contains records for only three publishers; these are shown in Table D-9.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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