Navigation:  Articles >

Dec-2004

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2004-12

 

---

 

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

 

SageKey MSI Wizard

Peter Vogel

14

 

Review

 

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

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,

 

a lis

---

Purchase Smart AccessFirst page of this magazine

 

Find all the PDFs and Downloads

http://www.vb123.com/smart/

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software