[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

stuff



PureBytes Links

Trading Reference Links

Thanks for your emails

Learning Access has really helped me re-think a lot of my programming in
Excel.

If you look at the two user interfaces, you can see the immediate difference
between them. In Excel, you have this "big nothing" which you create stuff
in. Whereas in Access, you are presented with a dialog box with six tabs:
Tables (database info), Queries, Forms, Reports, Macros and (Code) Modules.

This "up front" organization is really helpful to me. In Excel you have to
remember all of these possibilities. It always ends up when developing an
app, that I mutter to myself, "oh ... I should have used a form", etc. In
Access it right there "in your face".

The following links "Handy Page" is very comprehensive

  http://www.home.earthlink.net/~jmhla/handypag.htm

I found it difficult to locate sample databases to learn ideas from. The
Northwind sample and solver provided with Access are very good. However, the
following 35 databases demonstrate many techniques, with of course, easy
access to the code and forms etc.

http://www.home.earthlink.net/~jmhla/RogerLib.EXE

    "The file contains 33 databases, each of which
     demonstrates a possible solution to a single problem. The examples
range from
     Beginner to Expert in difficulty. Also included in the file is a Table
Of Contents
     which describes each of the samples. The purpose of the samples is to
     demonstrate a possible solution, not to present the user with a robust
     utility.

I hope that the next version of Excel incorporates the Access dialog box
because it sure makes app development much easier. However, one of the
traders mentioned that the big push in Office 2002 or whatever it is to be
called, will be voice recognition.

Best regards

Walter