If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Starting Database
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 a 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 |
#2
|
|||
|
|||
Starting Database
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 "Bill" wrote in message ... 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 a 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 |
Thread Tools | |
Display Modes | |
|
|