Starting Database

[Bill]

Can someone help me out in creating my database? I am very new to working in
Access and am trying to learn as I go. The following is what I am hoping to
make.

I want to create a Pick3 Lottery Database. The fields that I need are:
Date (date of drawing),
Weekday (day of the week)
Drawing (midday or evening or bonus)
1st Number (first number drawn)
2nd Number (second number drawn)
3rd Number (third number drawn)

Now my question is how I can set up my table or tables. Would it be better
to have a separate table for each field or just one table? Also is there any
special formatting I need to do, so my Tables are set up correctly.
Some Queries I will have when Tables are finished:
1st Number drawn on any Thursday for Midday drawing
All three numbers drawn on certain date
How many times a number was drawn in specified time frame

There are many other relationships and queries I have, but this should give
you an idea of what I am attempting to do. I looked for something similar in
structure of what I am trying to do, but could not find anything. If anyone
knows of tables or forms I can look at would also help me.
Thanks,
Bill

 

[Jeff Boyce]

Bill

What you're asking for in this volunteer-staffed newsgroup may be more than
folks can afford or care to provide. These newsgroups work great for
posting specific issues and getting specific suggestions, but your request
seems much broader.

Before you go further, you might want to spend some time working your way up
the learning curves that accompany working with a relational database like
Access. For starters, deciding on tables and relationships means
understanding the rudiments of relational database design and normalization.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP