O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

Determining What Tables You'll Need

How many tables will you need? Technically, you will only need one. That's the minimum a database can function with. However, the biggest mistake most people make with Access is to put too much information in one table. Access is a relational database program; unlike more simple database programs, it's meant to handle lots of tables and create relationships among them. Figure 2.1 shows a list of tables in a database that keeps track of the employee hours spent on various projects.

Figure 2.1. Access really shines when you take advantage of its capability to store many tables.

Plan Tables Now!

You should ...

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