
(Relating to Mail Merging a Database to Create and Print Form Letters- Part 2 of Mail Merge Recipients)

(Relating to Mail Merging a Database to Create and Print Form Letters- Part 1 Of Mail Merge Recipients)

(Relating to Mail Merging a Database to Create and Print Form Letters- The letter used)

(Relating to inserting sound and image files into database- The Address Book Form)

(relating to inserting sound and image files into database- The Address Book Table)

( Relating to sound recording activity- Sample rate and Maximum frequency)

(Relating to sound recording activity- Recording sound)

(Relating to sound recording activity- Properties, choosing which quality)

(relating to bits and bytes activity)

(relating to Bits and Bytes activity).

(Relating to Data Types activity- Table)
Please Click to see clearly!
The current term 1 activities will be uploaded:
-Data types (4)
-Bits and Bytes (6)
-Sound Recording/ Practical Activity (7)
-Inserting Sound and image files into a database (8)
-Mail Merging a Database to Create and Print Form Letters (14)
Data Types
 This activity was simply understanding what each field means. In order to this, I had to go to the help section of Micrsoft Access and type in "Data types available in Access" and all the information was there. In my table i had three fields, the data type, the description of that DT and the storage size of each. I then summarized the information. Done!
Bits and Bytes
 This activity is useful in understanding about what and how bits and bytes work.
1. DIGIT
 A Digit is a "single space" which is able to hold numerical number which are between 0 to 9. In order for larger numbers to be formed, digits are combined together in a pack. As learnt in Maths, each digit in a whole number has its own place where it stands in terms of the 1's,  tens, hundreds,thousands, ten thousands, hundredths, thousandths etc....So to further understand, E.G. 4,325
5- 1
2- 10
3- 100
4- 1000
And so further space it out it could be written like this
(4+1000)+ (3+100)+ (2+10)+ (5+1)= 4000+300+20+5= 4,325
Four Thousand, three hundred and twenty five, simple!!
2. BASE 10
 Base 10 or also referred to as denary, is a  decimal, numeral system ( Base 10 system) which has 10 as its base. With ten being the base, there is a little number on the top, which is commonly referred to 10 to " the power of (insert number)." So for example:
10 to the power of 2 (10 squared)Or....
10 to the power of 3 (10 cubed) ETC..In the following table the base 10 system can be seen.
 -The Base 2 System, also known as the 'binary system". Computers operate using this system.
- There are a number of "base- anything systems"
3. WHERE DOES THE WORK BIT ORIGINATE FROM?
 The word bit is short from for: Binary Digit. It takes a "logical value" of either 1 or 0. Binary digits are units of information storage as well as communication in "digital computing" and "digital information theory"(branch of maths and engineering).
 The bit is also a unit of measurement, its simply the information capacity of one binary digit. To identify it the symbol is: bit or b!
 This word was first used by Claude e. Shannon in his 1948 paper: The Mathematical Theory of Communication.
4. Examine this table:
a) You can write 4,321 as
(4*1000)+(3*100)+(2*10)+(1*1)= 4000+300+20+1
5. Examine this table:
Binary Base (2)
a)21
(1*16)+(1*4)+(1*1)= 21(base 2)
b)24
 (1*16)+(1*4)+(1*4)= 24(base 2)
c)30
 (1*16)+(1*4)+(1*4)+(1*4)+(1*2)= 30(base 2)
6. WHAT IS A BYTE?
- Bits form bytes.
Since a bit is never alone in a computer, it is a sequence of 8 bits which are processed as one unit of information.
7. HOW MANY BYTES IN A KILO, MEGA, GIGA AND TERA BYTES?
Kilo- 1024 bytes (2*10).
Mega- 1,048,576 bytes (2*20).
Giga-1,073,741,824 bytes (2*30).
Tera- 1,099,511,627,776 bytes (2*40).
Sound Recording, Practical Activity
 In this activity, I used the sound recording tool in programs>accessories& entertainment. With my microphone, I recorded my voice three times. The first time ( by going to properties and convert now option) I picked the telephone quality, recorded and saved. I did the same for the radio and CD quality.
Here is the sampling rate and bit size for each:
Telephone-11.025kHz, 16bit
Radio-22.050kHz, 16bit
CD-44.100kHz, 16bit
Definitions
Sampling Rate-It determines the sound frequency(corresponding to pitch),which is able to be represented in the digital waveform.
Sample size- The sample size of of a statistical sample is the number of observations that constitutes it. Denoted by: n(+number).In short its just the size of the sample.
 How does the sampling rate(kHz) and the sample size(bits) affect the quality of the recording?
 The sample rate affects the quality of the recording by: 
To remember:- Different sample rates determine different frequencies
 So for the lowest sample rate (11kHZ- telephone)-gives out very poor sound quality. Next the Radio sample rate of 22 kHz, the quality is 'significantly' affected. (The higher frequency information missing).
For the CD sample rate of 44kHz, there is not that much quality loss.
So overall the higher the sample rate the better quality you get of that recording.
 The sample size affects the quality of the recording by:  8 bit can be good for recording low and medium quality but not high quality.
16, 24 and 32 bit gives out high quality of audio.
So once again the higher the bit the higher quality, but the a lot more work of recording( E.G. 32 bit takes more work recording as compared to 16bits.)
Inserting Sound and image files into a database
 My address book that I had made before, I now have a field called voice message and photos. So recorded 10 voice messages for each person( using the sound recorder), just saying their name and there are 12 pictures for each person as well as. Then I made a form, which shows the picture as well as the the other details, including a little icon for the voice message.
*A problem which occurred while I was putting inserting the picture in the field, was that it wouldn't load, so what I did was went to paint, opened the saved picture, saved it as a 24bitmap image and it luckily worked!
Mail Merging a Database to Create and Print Form Letters
 In this activity, using the Mail merging step by step wizard in Microsoft Word 2007, I successfully mail merged a letter. The recipients which I used were from my address book(database). Just the company name, email address and work phone I had to make up!