• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 2. Planning your Database > Determining What Tables You'll Need

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint