Welcome Guest
( Log In | Register )
The time is now 7:36 pm
You last visited January 21, 2017, 6:32 pm
All times shown are
Eastern Time (GMT-5:00)

MS Access for PowerBall

Published:

Ahh the challenges of designing a database.

After much thinking and a quick review of the "Designing a database" book I used to study for my MCDBA, I have come to the realization that my entire suite of excel workbooks can be reduced to 2 tables and a few carefully crafted queries... Added bonuses,

1) new filters can be added as easily as dropping in a new query.

2) once complete, a few minor changes can be made to convert to any game

3) I can backtest by simply selecting certain date ranges

I have to refresh my memory on the use of Access forms to make it feel more like an app than a db. but at least I have a plan now.

look out MUSL ;-)

Entry #126

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.