MS Office User


Crystal Access Expert


    My Life with Access by Crystal

My love affair with Access began nearly 20 years ago. Windows was new. Lots of people still preferred DOS, including me. Although I had been writing books with Word for its style sheet capabilities, I was a WordPerfect user for my everyday stuff. Ventura was my pick for desktop publishing.

In the early years, I wrote Lotus 1-2-3 macros to create reports that had previously been done by FORTRAN on a mainframe; had to tweak the code so it ran under the 640K memory barrier. RAM cost about $1 a K back then and there were 9 chips in a bank with parity checking. I got a great deal on a box of chips — $1 each, which made 64K cost $9 — upgraded everyone I knew!

My favorite database was Knowledgeman, although as a consultant, I also did a lot with dBASE, RBase, Clipper, FoxPro, and any other database out there. I remember building an application on the Mac with FileMaker. At the end of the day, I didn’t know how to back up the file because I had never used an Apple before … but the database was done :)

Didn’t really use drawing programs back then, although I wrote a Ping Pong program in Pascal (just because I could) and created lots of graphs :)

When I discovered Access, my life changed. Access is more than a database application, it is the control center for all that happens with Microsoft Office … and any data it can reach. A talented Access developer also knows and leverages Excel, PowerPoint, Word, …


Crystal's Recent Press Releases Crystal's Recent Posts

Creating Primary Keys and Foreign Keys in Microsoft Access

Working with the data in Microsoft Access tables is very important and is often difficult for new users to understand how to properly design tables to store data in the most efficient manner possible. This article has been submitted to discuss the use and creation of Primary Key and Foreign Key fields in Microsoft Access [...]