Microsoft® Access® 2010 Inside Out

Creating a Table Using Data Type Parts

Access 2010 includes another new feature, called Data Type Parts, to assist you with creating tables and fields. Application Parts, as you just learned, help you build complete tables and other database objects, but Data Type Parts help you create individual fields or groups of fields. As you design more databases, you might find yourself needing to create similar field structures in your tables. For example, you’ll probably find yourself needing to have fields in at least one table that tracks address information such as street address, city, state, and ZIP code. With Access 2010, you can now add a group of fields to track address information easily using Data Type Parts. You can also save your own custom ...