What are the Table's field properties in Access 2007? The Table field properties are used to control the properties of a specified field. For example, you can set the properties up for say the First Name field to always turn lowercase letters into uppercase. You can control the amount of characters a user can enter into a field say five for a zip code. Another popular property control is requiring data before a record can be saved. Like the Name field, a user can't save the record and will receive an error explaining why the record can't be saved. That is until the user types in the client's name in the Name field. Also, you can color code text based upon specified criteria!

Purchase the training video and you can see this in action for yourself!