May-2003

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

May-2003

 

Smart Access Article Abstracts

Page

 

 

2003-05

 

---

 

Access: The .NET Report Writer

Danny J. Lesandrini

1

 

Article

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Processing E-mail Orders Using Outlook and Access

Scott McManus & Garry Robinson

7

 

Article

 

Garry Robinson and Scott McManus show how they accepted orders placed for their company’s software through an online

 

ordering system. With some Access code that links to Outlook, they process those orders automatically.

 

 

 

 

 

 

 

 

 

 

 

Excel: Data Entry for Access?

Scott McManus

10

 

Article

 

For your users who feel more comfortable inputting data in a spreadsheet environment, Scott McManus shows you how to

 

take an Excel spreadsheet and turn it into a data entry form for Access complete with data verification and error checking. By

 

combining Automation, Excel templates, and Excel’s data validation option, you can have the same control over users’ input as you would in Access using lookup tables, relationships, and rules.

 

Calculating the Median

Peter Vogel

16

 

Access Answers

 

In this column Peter Vogel answers just one query-but it’s a good one. Along the way, he demonstrates how to 'think in SQL.'

---

 

 

 

---