Category Archives: Design and Tables
Normalization and Management Advice
In a second article on the normal forms of a relational database, Peter Vogel discusses forms two through four and offers some advice in dealing with management. First part -> Working SQL: The Trouble with Normal One of the reasons … Continue reading
Working SQL: The Trouble with Normal
In the first of two articles, Peter provides the essential background on normalization. In this article, Peter looks at first normal form and provides a different perspective on primary keys. More importantly, here’s why you should care about first normal … Continue reading
An Access Project, Part 3: “Relationship” and “Normal”
Dave Irvine returns with his series on Access development. In this article, David steps back to discuss some of the underlying concepts of database design. David applies a system analyst’s approach to data design that you might find more useful … Continue reading
The ABCs of Requirements Management for Access
While Access itself is a development product, developers need to think about much more than writing code. When working with clients, it’s crucial to understand the requirements for the application before writing code. In this article, Mike looks at some … Continue reading
An Access Project, Part 2: Data Modeling
In this series of articles, David walks through the process of creating a complete Access application. While the application itself is a valuable tool in a developer’s toolkit, David will concentrate in each article on using some feature of Microsoft Access. Start … Continue reading
