954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Seeking rudamentary advice

Folks,

Many years ago I worked as a dBase III programmer. In my early 30's I left the field of IT to persue another career. Today I am required to develop databases for a variety of stand-alone (PC) applications. I have Access to construct the database but I need advice on if and how I can write routines to add records, update, select based on criteria, etc.

I am hoping to use a simple tool with either pseudo-english commands (as with dBase), wysiwig or some other relatively simple method. And no, I cannot contract the work to a professional ;). Wouldn't I be so lucky.

Those of you who are familiar with dBase will hopefully be able to steer me in the right direction.

Thank you and kind regards,
Doonie

"Remember, 100 years from now...all new people"

Doonie
Newbie Poster
1 post since Sep 2007
Reputation Points: 10
Solved Threads: 0
 

dbase! me too. long time ago.

dr. cod's rules for normal databases still apply...
however, depending on what you want to do, access eventually stops being easy.
there is lots you can do without learning visual basic, although learning that is extremely helpful.

google "mvp access" for some good tips from microsoft mvp's.

simple forms are easy to create to add or update records.
record selection... you need to learn sql; but access has its "query" writer that allows you to do simple selection by column.

simple tool? not aware of any for any database... it all gets "interesting" when you want to build apps that users can use (and not break).

ps, look at the northwind database included with access, it does a lot.

Temmu
Junior Poster in Training
86 posts since Sep 2007
Reputation Points: 20
Solved Threads: 6
 

Give this tool a lookover, it may be what you're looking for:

ASPRunner: http://www.xlinesoft.com/asprunner/

CertGuard
Light Poster
48 posts since Jul 2007
Reputation Points: 10
Solved Threads: 3
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: