Question

Which of the following is NOT true when changing the data type in an existing field?

1) You can change the size of a field in Datasheet view and Design view.
2) If you decide that a field length needs to be longer, you can change the field without concern.
3) If you make a field length shorter and there were data that needed the longer length, you may truncate those values.
4) Access will always warn you that data may be lost if you change the length to a smaller size.

Answer 1

When changing the data type in an existing field, you can change the field length to make it longer, but not shorter. Data may be truncated if you make a field length shorter and there is existing data that needs the longer length. Access will only warn you about potential data loss if there is a risk.

Step-by-step explanation:

When changing the data type in an existing field, you cannot change the size of a field in Datasheet view and Design view, so statement 1 is NOT true.

If you decide that a field length needs to be longer, you can change the field without concern, so statement 2 is true.

However, if you make a field length shorter and there were data that needed the longer length, you may truncate those values, so statement 3 is NOT true.

Access will not always warn you that data may be lost if you change the length to a smaller size. It will only prompt a warning if there is potential for data loss, so statement 4 is NOT true.