<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >



Smart Access Article Abstracts






Access Interfaces: Handling Price Ranges

Rebecca Riordan





This month Rebecca Riordan looks at implementing a common business rule. In fact, she provides two methods for handling the


common case of multiple prices for a given product, depending on the quantity ordered the customer pays $1.79 each for


buying up to


Forgive Me, I Have Sinned

Peter Vogel





The following story may serve as an object lesson to you about the perils of poor database design.


Do More for Less : Leveraging Your DBMS

Andrew Wrigley





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, or


the M


Decomposing a Badly Designed Table

Frank Kegley





Many users have decided that they don’t need the full power of an RDBMS and that Excel is the right choice for storing data. It’s


not a bad choice, until the application grows to the point that they do need a “real database.” Frank Kegley shows you how to












Making the Grade

Doug Steele



Access Answers


This month, Doug Steele looks at a common problem in database design: converting from one data classification schema to


another. He then moves on to a related question: ensuring that there are no overlapping records in a list of ranges (for example,




First page of this magazine