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

Chapter 5. Working with Jet Databases an... > Working with the Northwind Traders S...

Working with the Northwind Traders Sample Database

One fundamental problem with books about database management applications is the usual method of demonstrating how to create a “typical” database. You are asked to type fictitious names, addresses, and telephone numbers into a Customers table. Next, you must create additional tables that relate these fictitious customers to their purchases of various widgets in assorted sizes and quantities. This process is unrewarding for readers and authors, and few readers ever complete the exercises.

Therefore, this book takes a different track. Access includes a comprehensive—but outdated—sample order-entry database, Northwind Traders. Rather than create a new database at this point, you create a new table as an addition to the Northwind Traders database. Adding a new table minimizes the amount of typing required and requires just a few entries to make the table functional. The HRActions table you add later demonstrates many elements of relational database design. Before you proceed to create the HRActions table, try the quick example of adding a new contact-tracking table to the Northwind Traders sample database in the following section.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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