Define Table

Data source

Shows the data source you selected on one of the previous wizard pages.

Table name

Type the name of the new table you want to define.

Name

Type the name of a field (or column heading) you want to add to the new table.

Type

Choose the data type for the database field. The data types you can choose depend on which database program you're linking to.

Length

Type the size in bytes of a variable-length field.

Decimal

Type the number of decimal places supported by the field.

Fields

Lists the fields in the new table you are defining.

Primary key

Select if the field is part of the primary key.

Unique

Select if the field can't have duplicate values.

Required

Select if the field can't have a null value.

Add

Click to add the field specified in Name to the table you are defining.

Remove

Click to remove the selected field from the table you are defining.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×