表格设计

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

要访问此命令...

In a database file window, click the Tables icon. Choose Insert - Table Design or Edit - Edit.


数据源摘要

表格设计

窗口有自己的菜单栏。并且其中新增了以下命令:索引设计

表格的定义区域

此区域用来定义表格的结构。

字段名称

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.