For some field types like date and time this option is not available. Select a reasonable length for the number of characters you think might be stored in this field. You can also choose whether or not a field should be indexed. Indexes speed up searches but if you index too many fields you can really slow Access down because every time you create a new record all the indexes must be updated. The input mask is another important part of this table creation screen.
Input masks are automatic formatters for data entry.
Access can automatically format your text so that you don't have slow data entry or introduce further errors by entering symbols. If you require a date that extends beyond 2038 use a four-digit date format. Now click on V iew and then D atasheet We can now display the table in datasheet view and practice entering some data. In order to move from one field to another you can either use the Enter key or the TAB key. You will only be restricted by the format you chose for the field and the field size you gave the field.