If not, don’t worry, you probably won’t notice any serious performance problems. In Access, things will run more quickly if they are smaller, so you can use a smaller field size if you want. The default size for number fields is Long Integer. The sizes available are: “Byte,” “Integer,” “Long Integer,” “Single,” “Double,” “Replication ID,” and “Decimal.” Their various sizes and decimal restrictions are illustrated in that following table. Number fields are different from text fields when you set the “Field Size,” in that you set the field size by assigning a type of number that can be stored in the field. Access allows up to 255 characters in a text field, and also assigns that as the default field size. This can be useful in restricting the amount of data that can be entered into the field. You can use the “Field Size” property of a text field to set the number that you type as the maximum allowable number of characters in the selected field.

The help file will appear in a separate window, which you can read and print, if desired. If you need additional help in setting the value of a particular property, you can click into the property field about which you have questions, and then press the “F1” key for additional assistance. You can click into a property box and view information about its function or purpose in the right pane of the “Field Properties” section. The “General” tab contains field properties that allow you to control the size, display, default values, and many other features of the selected field. You only use the “Lookup” tab when you are manually setting properties of “lookup” fields which display values from another table or list. Most of the time, the property that you are trying to set is on the “General” tab. To set a field property, you must first find the specific property of the field that you would like to set on the tabs.

Below that, in the “Field Properties” section, you set the properties of the field that is currently selected in the table design grid on the two tabs labeled “General” and “Lookup.”

When you open tables in design view, you name the fields and assign them a data type using the top half of the screen which is called the table design grid. You can set the properties of the table fields that you create in the design view of the table. Need more Access training? Click here for the complete tutorial! Mac OS Monterey-Mojave Keyboard Shortcuts.

Microsoft access 2013 tutorial 5 case 1