表格設計

In the Table Design window you define new tables or edit the structure of an existing table.

此視窗有自己的功能表列。且包含下列新指令：索引設計

表格定義區域

此區域為定義表格結構的區域。

欄位名稱

Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.

欄位指令類型

Specifies the field type. The available field types are limited by the database engine being used.

描述

Specifies an optional description for each field.

列標包含下列右鍵功能表指令：

剪下

剪下所選列至剪貼簿中。

複製

將選取的列複製到剪貼簿中。

貼上

貼上剪貼簿的內容

刪除

刪除選取的列。

插入列

Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.

主關鍵字

If this command has a check mark, the data field is defined as a primary key. By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys.

欄位屬性

定義目前所選欄位的欄位屬性。

長度

Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters.

小數點位數

輸入數字欄位或小數點欄位的小數點位數的數目。

預設值

指定新資料記錄中的預設數值。

格式示範

Displays the format code to assign to the field value that you can select with the ... button.

...

此按鈕開啟 [欄位格式] 對話方塊。

說明區域

Displays a help string or hint defined by the database designer for the given field.