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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×