Incorporating Images into a database

Placing images into a database is often times necessary. There are many different image formats but the most common are JPEG, GIF, TIFF, and Bitmap. Specifically, Microsoft applications tend to work with Bitmaps relatively seamlessly while most of the information on the Web is stored as either a JPEG or GIF.

Search for 'Background' at images.google.com to find images that can be used for backgrounds on Web pages or as desktop backgrounds. I would like you to create a database of images and place the first three images from the Web site into your Access DB. Each database entry is to contain the following fields:

ID (use the AutoID option) - this is the primary key

Name (e.g. bgimage85t) - this is the file name of the image

URL ( e.g. http://www.012guestbook.com/backgroundimages/bgimage85.JPG) - this URL takes you to the large image

Photo - this is the small copy of the image sometimes referred to as a thumbnail.

Here is an example Form for displaying the database information. The picture below is a Bitmap image. I converted the JPEG image to a Bitmap image using Paint. To save the thumbnail image, simply right click on the image and then select Save As. Use the default name provided as the image name.

 

More Access Information

Here is another useful Access link loaded with examples of how to do various things.

http://www.ucb-access.org/