Tables are used to store and organise information; the organisation includes allowing to organise the list into alphabetical order whether it's from A-Z or Z-A. Tables also place information into their categories as shown in the image above. The information in the image is organised into 'Song title', 'Artist', 'Genre' and it also has two colums that contain the images shown in forms - this will be explained later on in the post.
However, information in tables have different 'data types' to which they can be entered in. Data types are the different kinds of information that can be stored (words, images etc). The data types I used in my tables are 'Text' - words, 'OLE Object' - used for images, 'Date/Time' - used for dates shown in the format: dd/mm/yy.

Queries

Queries are used to find certain information within the table it was set up to find information from. The queries used in my assignment are used to find 'Song Titles' 'Genres' and 'Artists'.


This image shows the entering of information into a query section. In the query of song titles I entered 'Your Guardian Angel', which is one of the songs featured in the music database.


In this image in the query section of song genres I enter 'J-pop' and these are the results that came up.

Forms

Forms are used to show the information stored within a table. The form featured in the image above is formed from the main table which I used to show; Song title, Artist, Genre, Song sample and Album cover.

Tables create the bases of the entire assignment, it is where one stores information they wish to display. Queries are used to search for information within the specified areas whether it be; Song title, Artist of Genre. Forms are where infromation from tables can be presented and shown to all in a presentable manner!

---

Question three complete~

All you want here

♥ Jess.Bee
♥ Alison
♥ Old blog -- lost pw
♥ Sharleen
♥ Amy
♥ Aakriti
♥ Friend


March 2008 April 2008

Msn,Other blog here

Leave that alone!Thanks
=] everything belongs to it's owners