Other Topics > Smart Access 1996-2006 > Dec-2004

Dec-2004

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

Dec-2004

 

Smart Access Article Abstracts

Page

 

 

---

 

Access Interfaces: Handling Price Ranges

Rebecca Riordan

1

 

Article

 

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

2

 

Editorial

 

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

7

 

Article

 

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

11

 

Article

 

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

15

 

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

 

 

 

---