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

Lesson 2. Working in Access > Planning a Database

Planning a Database

Access is a special kind of database called a relational database. A relational database divides information into discrete subsets. Each subset groups information by a particular theme, such as customer information, sales orders, or product information. In Access, these subsets of data reside in individual tables like the one described previously.

Access enables you to build relationships between tables. These relationships are based on a field that is common to two tables. Each table must have a field called the primary key (you learn how to specify a field as the primary key in Lessons 4 and 5). The primary key must uniquely identify each record in the table. So, the primary key field is typically a field that assigns a unique number (no duplicates within that table) to each record.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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