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

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