What does the sign means to a table in the Microsoft Access?

1
votes

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?

1
ms-accessms-access-2013
The * and (new) just means that this is the place where you can add a new row to the table. – Tom
You posted the same image twice. – RedX
Robin to @RedX : "Opps, I'll edit that." – mshahrim
The (New) indicates that a new ID will be generated in that field as it is an Autonumber. The star indicates a new record that has not yet been added to the database. – citizenkong

1 Answers

1
votes

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.

enter image description here

will result in a display like this:

enter image description here

as opposed to setting it to something different than AutoNumber:

enter image description here

resulting in

enter image description here

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:

enter image description here

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.