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
|
|||
|
|||
New to Access & DB's
Hi All!
I'm a brand-spanking-new Access user, especially am new to the Microsoft Office 2007 version. I have the need to make a hobby-related database which contains data from 10-15 years of published data containing a small number of related fields. I tried to learn Assembly, like the type used in Microsoft Macro Assembler (MASM), but got stuck. I also would like someone's help setting it up, or at least providing me with a step-by-step guide. I have Microsoft Office 2007 Professional. I'm the type of person that needs some sort of a visual and/or written step by step process of doing things, especially when I'm learning.. or it will take me much longer to "get it". Initially the data will be for my own use. After a while, I may publish it to the web, or make it available as a download, or on some disk like a CD or DVD, or a combination thereof. The data comes from volumes of this book, from 1986-2009: http://www.amazon.com/Passport-World...39465&sr= 8-1 The data will be in the format: Frequency in the format xxxx.x (where x = a integer value of 0 through 9) Some form of showing that this frequency may be "variable" as shown in the text. Some form of showing whether this is a new and/or changed schedule. Country of Origin: i.e. U.S.A. Station ID: i.e. Voice Of America World time in GMT or UTC: ie 0 through 24h (23h,59m,59s) UTC. Transmitter or Antenna location, ie a town, state,city, province, etc. Transmitter power, in kW. ie 100kW Mode of Transmission, ie AM. Alternative Frequency, i.e. 7995kHz Season, ie Summer, Spring, Fall/Autumn, Winter Language of Transmission: ie, Farsi, English,Spanish Some form if indication that the transmission is "Jammmed" Transmission aimed at: i.e. S. Africa, E. North America, etc. And a comment about which volume year and/or years this entry appears. Some other misc. comments. Theres others but this would be a starting point in development... Oh yea I also downloaded the DVD iso at: http://www.microsoft.com/express/ Now I understand that my form tables should look like: Frequency - Number with 1 decimal place format (not an integer) Variable - Yes/No New/Changed - TWO check boxes if the item can be both new and changed indicated by "and/or" in you post. Country of Origin - look up to a table with country names Station ID: Text field World time in GMT or UTC: This could be an option group with auto populated combo boxes based on whether you choose one time or the other. Transmitter or Antenna location - combo box? Transmitter power - number Mode of Transmission - option group or combo box Alternative Frequency - number field Season - option group Language of Transmission - probably a multi-select list box? look up to Language table "Jammmed" - Yes/No Transmission aimed at - combo box look up to continent table Volume Look Up to volume table, which will contain the year the volume was published. Comments - memo field. Thanks, Greg |
#2
|
|||
|
|||
New to Access & DB's
regardless of the version of Access you're using, you'll want to forget
about forms for the time being, and start at the beginning: creating the tables/relationships structures, which form the foundation of your database. a common correlation is building a house - you build the foundation before you build walls and paint, add furniture, and put flowers in the vase on the dining room table. for help getting started, see http://home.att.net/~california.db/tips.html, focusing first on the first two tips, and then moving on to the next seven when you're ready to begin building your tables. hth "gbowne1" .(donotspam) wrote in message ... Hi All! I'm a brand-spanking-new Access user, especially am new to the Microsoft Office 2007 version. I have the need to make a hobby-related database which contains data from 10-15 years of published data containing a small number of related fields. I tried to learn Assembly, like the type used in Microsoft Macro Assembler (MASM), but got stuck. I also would like someone's help setting it up, or at least providing me with a step-by-step guide. I have Microsoft Office 2007 Professional. I'm the type of person that needs some sort of a visual and/or written step by step process of doing things, especially when I'm learning.. or it will take me much longer to "get it". Initially the data will be for my own use. After a while, I may publish it to the web, or make it available as a download, or on some disk like a CD or DVD, or a combination thereof. The data comes from volumes of this book, from 1986-2009: http://www.amazon.com/Passport-World...39465&sr= 8-1 The data will be in the format: Frequency in the format xxxx.x (where x = a integer value of 0 through 9) Some form of showing that this frequency may be "variable" as shown in the text. Some form of showing whether this is a new and/or changed schedule. Country of Origin: i.e. U.S.A. Station ID: i.e. Voice Of America World time in GMT or UTC: ie 0 through 24h (23h,59m,59s) UTC. Transmitter or Antenna location, ie a town, state,city, province, etc. Transmitter power, in kW. ie 100kW Mode of Transmission, ie AM. Alternative Frequency, i.e. 7995kHz Season, ie Summer, Spring, Fall/Autumn, Winter Language of Transmission: ie, Farsi, English,Spanish Some form if indication that the transmission is "Jammmed" Transmission aimed at: i.e. S. Africa, E. North America, etc. And a comment about which volume year and/or years this entry appears. Some other misc. comments. Theres others but this would be a starting point in development... Oh yea I also downloaded the DVD iso at: http://www.microsoft.com/express/ Now I understand that my form tables should look like: Frequency - Number with 1 decimal place format (not an integer) Variable - Yes/No New/Changed - TWO check boxes if the item can be both new and changed indicated by "and/or" in you post. Country of Origin - look up to a table with country names Station ID: Text field World time in GMT or UTC: This could be an option group with auto populated combo boxes based on whether you choose one time or the other. Transmitter or Antenna location - combo box? Transmitter power - number Mode of Transmission - option group or combo box Alternative Frequency - number field Season - option group Language of Transmission - probably a multi-select list box? look up to Language table "Jammmed" - Yes/No Transmission aimed at - combo box look up to continent table Volume Look Up to volume table, which will contain the year the volume was published. Comments - memo field. Thanks, Greg |
Thread Tools | |
Display Modes | |
|
|