该符号对Microsoft Access中的表意味着什么? [英] What does the sign means to a table in the Microsoft Access?

问题描述

我只想知道记录开始处的符号/声明是什么意思.

表1的屏幕截图:它带有"*"和(新)"字样.那是什么意思? https://drive.google.com/file/d/0B1ZF1oqH0s9hemtYX0NpLviewHxLWs ?usp =分享 表2的屏幕快照:该表仅带有'*'符号.那是什么意思? https://drive.google.com/file/d/0B1ZF1oqH0s9hd3dKdUhkQXR3 ?usp =分享

说我想使表2变得像表1一样，怎么办?

解决方案

(New)写在将自动生成值的字段中.如果输入表的DesignView，则可以更改该表中字段的数据类型.如果将类型设置为AutoNumber，则在创建新条目时将显示一个占位符.

将导致这样的显示:

将其设置为不同于自动编号"的方式:

导致

前面的*已在注释中正确解释:它是新行条目的指示符.

要使table2像table1一样，您必须将字段类型更改为AutoNumber-不幸的是，据我所知，这是不可能的，因为您已经输入了数据:

在表中输入数据后，即使尚未向该字段添加数据，也无法将任何字段的数据类型更改为自动编号".

唯一的方法是使用正确的架构创建一个新表，然后在不指定AutoNumber值的情况下将数据移到那里.

I just want to know what is meant by the sign/statement at the beginning of the record.

Screenshot of Table 1 : it has the '*' and the '(new)' word. What is meant by that? https://drive.google.com/file/d/0B1ZF1oqH0s9hemtYX0NpLWhqLWs/view?usp=sharing

Screenshot of Table 2 : this table only has the '*' sign. What is meant by that? https://drive.google.com/file/d/0B1ZF1oqH0s9hd3dKdUhkQXR3VzA/view?usp=sharing

Say I want to make Table 2 become like Table 1, what should I do?

解决方案

The (New) is written in the fields where the value will be auto generated. If you enter the DesignView of a table you can change the data type of the fields in that table. If you set the type to AutoNumber there will be a placeholder displayed when creating new entries.

will result in a display like this:

as opposed to setting it to something different than AutoNumber:

resulting in

The leading * has already been explained in the comments properly: it is an indicator for a new row entry.

To make table2 like table1 you would have to change the field type to AutoNumber - unfortunately that is not possible as far as I can tell since you already have entered data:

Once you enter data in a table, you can't change the data type of any field to AutoNumber, even if you haven't yet added data to that field.

The only way would be to a create a new table with the correct schema and move the data there without specifying the AutoNumber value.

这篇关于该符号对Microsoft Access中的表意味着什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！