Jan-2002

<< Click to Display Table of Contents >>

Navigation:  Smart Access 1996-2006 >

Jan-2002

 

Smart Access Article Abstracts

Page

 

 

2002-01

 

---

 

Put XML to Use in Access 2002

Danny J. Lesandrini

1

 

Article

 

You’ve heard that XML is easy to import and export from Access 2002, but you have yet to come up with a good use for it.

 

Danny Lesandrini solves two problems with Access 2002’s XML support: dynamic file linking

 

Tools

Peter Vogel

4

 

Editorial

 

Over the years, I’ve picked up a bunch of skills that I use when creating applications. I also try to keep my toolset as small as possible. So what do I think is the minimum set of skills, tools, and technologies that you need to build applications in the ...

 

 

 

Duplicate Data Entry for Access

Taha Kass-Hout and Garry Robinson

9

 

Article

 

Redundant data is bad, but double data entry can be good. Garry anf Taha show you how and why.

 

 

 

 

 

Article

 

 

 

Temporary Tables, Table Variables, and Table-Valued Functions in SQL

Burton Roberts

12

 

Article

 

Server.

 

In this article, Burton Roberts shows how to use SQL Server’s temporary tables in your Access Data Projects. With that out of the

 

way, he’ll introduce two powerful new features of SQL Server 2000.

 

Working SQL: Ordered Calculations with SQL

Mike Westcott

15

 

Article

 

In this article, Mike Westcott shows how to use SQL to solve problems with counter columns, running sums, and all things

 

ordered by using self-joins. Mike also demonstrates the power and danger of incorporating VBA into your queries.

 

In this article, Mike Westcott shows how to use SQL to solve problems with counter columns, running sums, and all things

 

ordered by using self-joins. Mike also demonstrates the power and danger of incorporating VBA into your queries.

 

I’ll Be Late at the Office Tonight

David Moss

18

 

Article

 

You know how it is-you’ve been in a long-term relationship, your eye starts to wander... David Moss had a one-month stand

 

with Sun’s StarOffice. Microsoft Access has now allowed him home again. If you, your boss, or your clients are thinking about

 

moving

---

 

 

 

---