A field is a category of information. The table shown above has separate fields for first name, last name, address, city, state, and zip code information.
Each record is a collection of fields, that is, one piece of data for each field. A record holds related data for one entity. In the table shown, each record holds the contact information for one person.
Unlike a spreadsheet, the rows and columns in a database table cannot be reversed, columns are always fields, which contain a category of data, and rows are always records, which contain a number of pieces of related data.
Breaking Data into Fields
It is important to break your data into small, but meaningful, pieces.
Learn what the other Access database objects--queries, forms, and reports are for.
Access 2010 provides the most revolutionary changes to Access, arguably since Access was first released.
Taking a giant step forward, it now offers you the capability to provide Web applications that rely on the Internet browser rather than requiring the user to have Access installed.
These features can be combined with rich client applications to create robust hybrid solutions. Access 2010 is built on the same platform as Access 2007, so you may be familiar with many of the features that provide a user interface that is functional and intuitive. The interactive display of commands and options is based on where you are in the interface, but you still retain control with the capability to resize, hide, and customize the display.
Most of the new features will be discussed in more detail in the chapters that follow, so this chapter will only briefl y introduce those features to provide you with a quick overview.