Adventures in Databasing

Because I have nothing better to do with my time (**cough**write**cough**), I’ve decided to learn how to build databases using Microsoft Access 2010.  I’m using a tutorial I found here.  Thus far, it hasn’t been a fantastic tutorial (read as: a lot of typos and consistency errors), but it’s free and comes with learning resources so I can’t complain too much.  Not to mention, the writer did a fantastic job of making the tutorial as layman as possible, going so far as to assume the reader doesn’t even know how to print a document from her own computer.  In that respect, it is an amazing tutorial.

Right now, I’m taking a break, my brain hurts.  I just got through the first three lessons thinking I’m going to be a diligent student and follow each step to the letter, only to realize it’s covering everything I figured out on my own by just fiddling around with the program.  Oh well, that’s two hours wasted. Time to get drunk.

The first database I plan on making for actual functional purposes in my everyday life is going to be a story-tracker type of thing.  I’ll store projects I’m working on in it by title, include a summary, track them by status and progress, finish date, maybe word count (?), and, dreaming of the (hopefully near) future, even track which publishers I submitted the stories to upon completion and the date it was sent.  It will be glorious!  Just as soon as I figure out some of the programming tidbits…

Building it should occupy my weekend.

The writer’s block I mentioned last post is still there, but it’s crumbling.  I got a chapter written on one story, and half a chapter written on another.  So I think I’m doing good-ish. Oh well. Nothing clears the brain quite like organizing data into single-value categories.

If you do ever feel the need or simply have the desire to learn database making, I do recommend Access.  It’s incredibly user-friendly, and if you have a basic understanding of what a database is and how it should be set-up, you can do fun things with it.  Like, track your stories…or track information in your story, maybe do a chapter database to track which characters are in a chapter, how long it needs to be, setting, tone, etc.  Or you could do a character database if you have a story with an overwhelming number of characters.  Possibilities are endless when you have the knowledge.

Right.  Break is over.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


"Freedom isn't just a word, but a way of life.."


Was I born a masochist or did society make me this way? I demand unconditional love and complete freedom. That is why I am terrible.

Dean J. Baker - Poetry, and prose poems

BOOK PRICES! most at $9.99, up to $13.99 -


Personal blog, interracial relationships, dating, author, BWWM,

Ray Ferrer - Emotion on Canvas

** OFFICIAL Site of Artist Ray Ferrer **


Fiction & Poetry

Limebird Writers

Let Your Creativity Fly

Shannon A Thompson

You need the world, and the world needs good people.

Unbound Boxes Limping Gods

The writer gives life to a story, the reader keeps it alive.

The Consortium of the Curious

For those bemused by the bizarre and engrossed in the esoteric.

dodging commas

dodging (verb) - to change suddenly, to elude or evade // commas (noun) - a mark indicating a pause or separation


Just another site

Pete Denton

Writer of British Crime Fiction

Chris Martin Writes

Sowing seeds for the Kingdom

Interactive Books where YOU are the hero

Survive the Zombie Apocalypse * Solve a Mystery * Gain Superpowers

hic sunt verba

hic sunt verba/here there are words

have cake with it

One man's crusade to write a play and make it happen

A Comfortable Silence

A great site

Smoke Ring Collisions

Flamma fumo est proxima

%d bloggers like this: