The field size property is the field property that allows us to set the maximum size for data stored in a field.The default field size of a text field is 50 characters.
The captain field property is the field property that allows us to assign a descriptive name for a field name.The maximum number of character that can be used in a caption is 2048 characters long.
Field property is the pane where it displays a list of properties associated with each field data type.Captain is associated worth all the data types.
The table design view that is used to create and organize the structure of database objects like tables, queries, forms and reports.Its panes are: - Field grid pane. - Field properties pane.
A foreign key is a field in the child table that refers the primary key of a master table that allows us to store duplicate data but does not allows us to leave the field blank (null).Foreign key is used for: - Avoiding the field to be let null.
The importance of the primary key in the table are: - It helps to ensure that fields not remained null. - It helps to identity unique data entered. - It helps to set relationship between tables. - It helps stop duplication of the record in a table.
The primary key is a field or group of field that has a unique value in each records. The primary key ensures that unique data is entered for a field and the field is not left blank (null).
Followers
