what do you understand by the entry required values for a field
Answers
Answered by
1
Require a value in a fieldApplies To: Access 2007There are two basic ways that you can require a value in a field:Set the field's Required property to Yes You can do this by opening the table in Design view. This method is easy and a good choice if you only want to change one field one time.Use a data-definition query that creates a non-null index on the field You can do this by using SQL view. This method is not as easy as using Design view, but has an advantage: you can save the data-definition query and use it again later. This is useful if you periodically delete and re-create tables and want to require values for some of the field
Answered by
1
There are two basic ways that you can require a value in a field:
Set the field's Required property to Yes You can do this by opening the table in Design view. This method is easy and a good choice if you only want to change one field one time.
Use a data-definition query that creates a non-null index on the field You can do this by using SQL view. This method is not as easy as using Design view, but has an advantage: you can save the data-definition query and use it again later. This is useful if you periodically delete and re-create tables and want to require values for some of the fields.
Set the field's Required property to Yes You can do this by opening the table in Design view. This method is easy and a good choice if you only want to change one field one time.
Use a data-definition query that creates a non-null index on the field You can do this by using SQL view. This method is not as easy as using Design view, but has an advantage: you can save the data-definition query and use it again later. This is useful if you periodically delete and re-create tables and want to require values for some of the fields.
Similar questions