Category Archives: Design and Tables

Do More for Less – Transferring Logic Through Your App

You’re probably doing too much work–you should be taking advantage of your DBMS’s facilities to get more done in less time. Andrew Wrigley discusses how the principles of declarative design, cascading, and overriding let you have Jet, SQL Server do … Continue reading

Posted in Design and Tables | Tagged | Leave a comment

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

Posted in Design and Tables | Tagged | Leave a comment

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

Posted in Design and Tables | Tagged | Leave a comment

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

Posted in Design and Tables | Tagged | Leave a comment

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

Posted in Design and Tables | Leave a comment