Microsoft® Office Access 2003 Inside Out

Chapter 3. Designing Your Database Application

Application Design Fundamentals

An Application Design Strategy

Data Analysis

Database Design Concepts

When to Break the Rules

You could begin building a database in Microsoft Access much as you might begin creating a simple single-sheet solution in a spreadsheet application such as Microsoft Excel—by simply organizing your data into rows and columns and then inserting formulas where you need calculations. If you’ve ever worked extensively with a database or a spreadsheet application, you already know that this unplanned approach works in only the most trivial situations. Solving real problems takes some planning; otherwise, you end up building your application over and over again. One of the beauties of ...