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

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

Determining the Tables You'll Need

Technically, you need only one table, the minimum a database can function with. However, the biggest mistake most people make with Access is putting too much information in one table. Access is a relational database program; unlike simpler database programs, it's meant to handle many tables and create relationships among them. For example, in a database that keeps track of customer orders, you might have the following tables:

CustomersCustomer Types
OrdersShipping Methods
Payment TermsProducts
Salespeople 



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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