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

D. Obtaining or Creating the Sample Database > D.3. Creating the AUTHORS Table

Creating the AUTHORS Table

To create the AUTHORS table, follow the same basic steps listed in Section D.2. The field definitions for the AUTHORS table are shown in Table D-4.

Table D-4. Fields of the AUTHORS table

Field Name

Data Type

AuID

Text

AuName

Text

AuPhone

Text

There is only a single property that you need to set, as shown in Table D-5.

Table D-5. Single property to be set in the AUTHORS table

Field Name:

AuID

Property:

Indexed

Value:

Yes (No Duplicates)

When you’ve finished creating the fields and assigning their attributes, define AuID as the table’s primary key. Then save the table, assigning it the name AUTHORS.

Next, enter the author data into the table; it is shown in Table D-6.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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