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 ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
