Data Types

The data type is a characteristic you designate for an Access field when you create it. It determines what kind of data can be entered into the field. Data types are determined primarily by the nature of the data and the amount of data that can be stored in a particular field.

The selection of data types and how the different types are variously used will make more sense when you start building tables. All data types receive much more treatment in Chapter 5, “Building Tables.” But I introduce them now because it gives you an excellent idea of the kinds of data you can enter and manipulate in Access.

Let's say you're a big fan of the Beatles. You want to create a database of their music, personnel, and activities, as well as the CDs, ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.