O'Reilly logo

QuickBase: The Missing Manual by Nancy Conner

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

Working with Tables

The heart and soul of any database are the tables that hold its information; this is true of both Access and QuickBase. As you create and work with tables, however, you'll see that QuickBase does things a little differently than what you may be used to with Access. This section gets you up to speed with using QuickBase tables.

Creating a Table

As you work with an application, you may need to add a new table. For example, say you've been collecting classical music recordings on vinyl for years, and you have a table where you catalog all your LPs. Recently, you've decided to join the digital age and collect CDs as well, but you want to keep the two collections separate in your database. In that case, you’ll want to add a new table devoted to CDs.

As someone who works with Access, you’re used to creating a new table in one of these views:

  • Datasheet view. This view lets you shape the table by adding records for a build-as-you-go approach.

  • Design view. In this view, you define the table—field names, data types, and so on—before you create the table. (You can’t add data while in Design view.)

Most database power users prefer the second approach: design your table first and then, after it has a good structure, start entering data. QuickBase takes this approach, too.

In QuickBase, all you need to create a new table is a name for it and an idea of the kinds of records it will hold. For example, in your Music Collection application you'd probably name both your new table and ...

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