Creating a table using Data Type Parts

Access includes another 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, you can now add a group of fields to track address information easily using Data Type Parts. You can also save your own custom field or groups ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.