Adding Sound File and Image to a Database

Digital files such as image and sound files can be inserted into a database.

1. Collect digital sound and image files of each of your friends in your Address database.
2. Open the table that contains the address details.
3. Go into design view.
4. Add two new fields called voice message and photo.
5. Set the data types for each to OLE Object.
6. Go back into form view.
7. In a cell under the new field simply right click and select insert object.
8. Select the Create from file option and then browse to the location of your sound or image file.
9. To view or listen to your files you will need to create a new form that contains the voice message and photo fields.  

The photo contains the image of the person and the sound field contains a piece of sample music. I was successfully able to add a sound file and an image to a database. 

Bits and Bytes

1. Digit: A digit is a single place that can hold numerical values between 0 and 9. Digits are normally combined together in groups to create larger numbers.

2. Base 10: the base-10 number system is known as the decimal number system represents any value with the digits from 0-9.

3. Bit: The word bit orginates from binary digit.

4 Examine the tables below:

 4, 321 would be written as:
(4*1000) + (3*100) + (2*10) + (1*1) = 4000+300+20+1

21: 10101
24: 11100
30: 11110







5: What is a byte?  A group of binary digits or bits (usually eight) operated on as a unit.

6: How many bytes in a kilo, mega, giga and tera bytes.

kilobyte- 1,024

megabyte- 1,048,576

gigabyte- 1,073,741,824

terabyte- 1,099,511,627,776

Creating a Form and Adding a Button to a Form

This is the first form that I have created. Also I have added a button, called 'run query' and if you click on it the date of birth will come up all the contacts.