该符号对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屋!