O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required