Microsoft Access 2010 Bible

Chapter 1: An Introduction to Database Development

13

FIGURE 1.4

The five-step design flowchart. This design methodology is particularly well-suited for Access databases.

Overall System Design

Report Design (Output)

Basic Data Design

Table Design

User Interface Design

These five design steps, along with the database system illustrated by the examples in this book,

teach a great deal about Access and provide a great foundation for creating database applications —

including tables, queries, forms, reports, macros, and simple VBA modules.

The time you spend on each step depends entirely on the circumstances of the database you’re

building. For example, sometimes users give you an example of a report they want printed from

their Access database, and the sources of data on the report are so obvious that designing the

report takes a few minutes. Other times, particularly when the users’ requirements are complex, or

the business processes supported by the application require a great deal of research, you may

spend many days on Step 1.

As you read through each step of the design process, always look at the design in terms of outputs

and inputs. Although you see actual components of the system (products, customers, and transac-

tions), remember that the focus of this chapter is how to move through each step. As you watch

the Collectible Mini Cars database being designed, pay particular attention to the design process,

not the actual system.

Step 1: The overall design — from concept to reality

All software developers face similar problems, the first of which is determining how to meet the

needs of the end user. It’s important to understand the overall user requirements before zeroing in

on the details.