Building Access Database  «Prev  Next»
Lesson 5 How data is stored
Objective Describe how an Access database stores data in a table.

How Data is stored in a Database

Storing data in Access

In an Access database raw data is stored in tables. Tables are the most basic of the Access database objects, every Access database must have at least one, otherwise you would have no data to work with. Tables are structured with rows and columns; in “database-speak” the rows are called records and the columns are called fields. Here is an example:

Data stored in a table
Data stored in a table

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

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.