Navigation:  Articles >


Previous pageReturn to chapter overviewNext page


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


SageKey MSI Wizard

Peter Vogel





One of the major challenges facing Access developers is distributing their applications. SageKey, long a provider of components


for Access installation solutions, steps in with a complete solution. Editor Peter Vogel takes it for a test drive.


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,


a lis


Purchase Smart AccessFirst page of this magazine


Find all the PDFs and Downloads



Product Links



Workbench for Access

Access To SQL Upsizer

FMS Software