Access 2010: Modifying Tables
http://www.gcflearnfree.org/access2010Whenever you're adding a new field to a table, there are three important things that you'll need to think about: data types, character limits, and validation rules. The data type determines whether the field will contain text, numbers, currency, dates, or a checkbox for simple yes or no answers. A character limit is the maximum number of characters that can be typed in a field. A validation rule allows you to limit the types of data with even more specificity. Generally, you will make these decisions when you first create a field, although it is possible to change them even if the field already contains data.If you are interested in learning more about this topic, please visit our site to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.