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

Part I: Tables and Queries > Planning and Designing Your Access Database

Chapter 1. Planning and Designing Your Access Database

Can you imagine building a house without a blueprint or an automobile without a design? Common sense tells us that it won’t happen. Likewise, it only makes good sense to take the time to plan and design your database before building it. It will save time in the long run because you are spared the frustration of fixing the inherent problems of a poorly designed application. This chapter focuses on how to employ sound database principles in your design. Specifically, you learn

  • about obtaining data from outside sources

  • why relational tables are important

  • about database design and normalization

  • why you should avoid duplicate data

  • about normalization fundamentals

  • about the first, second, and third normal forms

  • how to let Access automatically normalize for you


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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