O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

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 New Table in Design View

After you draw out your database on paper, you can start creating tables to store your data. One good way to define your table’s structure is to start out in Design view. When you look at a table in Design view, you can define the name of a field, select the type of data to go into that field (numerical values, currency values, text, dates, phone numbers, and so on), and write a description for that field. Field descriptions are one of the most overlooked parts of database design. It’s easy to overlook them or see them as unnecessary, but the reality is that you might forget what sort of data is supposed to go into a field. You could also leave the company and force someone else to figure out what a particular ...

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