Database Design

Part I of Essay
Before you use Microsoft Access to actually build the tables, forms, and other objects that will make up your database, it is important to take time to design your database. A good is the keystone to creating a database that foes what you want it to do effectively, accura ....

Part II of Essay
.... forms you was to use, the questions you want answered – don’t necessarily provide clues about the structure of the tables that produce them. You don’t need to design your tables using Microsoft Access. In fact, it may be better to sketch out and rework your design on paper first. A table should not contain duplicate information, and information should not be duplicated between tables. After you have designed the tables, fields, and relationships you need, it’s time to study the design and detect any flaws that might r ....