G
gbowne1
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-Worl...bs_sr_1?ie=UTF8&s=books&qid=1227139465&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
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-Worl...bs_sr_1?ie=UTF8&s=books&qid=1227139465&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