Page 47 - Database-En-V3

Table components:

A table contains a large amount of data organized in the form of columns,
rows, and entries
• First column:
• Access recognizes any entry based on the name of the column in
the table, and a name is placed at the column header. We must
name each column in the table with a correct, understandable, and
visible name, as in the following figure (such as the date the work
began and...). Each column has one type of data (Text, number, ....).
To ensure ease of dealing with these columns, two columns cannot
have the same name, i.e., not duplicate.

Field names must be specified:
Enter field names in the Field name field.
The field name requires that:
Its symbol length is no more than 64.
It does not start with an empty space.
It does not contain any of (or !or [ ]).

And also specify the data types within the table:

It is the process of setting the column type as it is in the form to
give it the authority that the data is correct “correct data entry”.

Data types:

40 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024