Using A parameter query

A parameter query enable you to reuse the same query but with different criteria each time. Every time a parameter query is run it prompts the user for the search criteria. This feature allows inexperienced users to query to database without having to actually create the query.

1. Create a query using the Design View.
2. In query Design view, drag the fields from the field list to the query design grid.

3.      In the Criteria cell for each field you want to use as a parameter, type an expression with a prompt enclosed in square brackets. To prompt the user for one or more characters to search for, and then find records that begin with or contain the characters the user specifies, create a parameter query that uses the LIKE operator and the wildcard symbol (*).

For example, the following statement searches for words that begin with a specified letter:

LIKE [Enter the first character to search by: ] & "*"

The phrase inside the square brackets is the prompt that the user will see.

The following  statement searches for words that contain the specified character: 

END RESULTS:::::

LIKE "*" & [Enter any character to search by: ] & "*"

Adding button to a form

1. Create a form (use the “create” tab then select the form wizard).
2. Once the form is created, ensure you are in design view then click the design tab.

1. Click the Button tool.
2. Click on the form where you want the button to appear.
3. The window shown below will appear. Select “Miscellaneous” and “Run Query” as shown. Click next.
4. Select the appropriate query (you have to have made a query before hand). Click next.
5. Label the button by selecting the text option. Click next.
6. Name the button command then click finish.
7. While still in design view create labels for your form using the Aa tool.
8. You can colour the background by simply right clicking on it and choosing Fill/Back Colour.
9. Resize and position the queries as required then click save to have them permanently appear in that position each time the button is clicked.

Adding digital files to a database

Inserting digital files
1. Make sure you have a collection of all your digital sound demos and cover alburn ( image files ) of each of the artist and there track.

2. Open the table the contains all the track details. As Seen in Figure. --->

3. Go into design view.

4. Add 2 new fields called 'Demo' and 'Track Cover' making sure that you set the data type to OLE object

5. go back to form view. In the cell under the new heading right click and click 'insert Object'.

6. Locate the 'cover alburn' and 'Demo of the track'.

REMINDER: to listen to the music you must create a form!

3. End Look

Inserting sound and photo files

<-- In this photo i have saved all my music demo in a folder named 'ist' and all i have is put it on the same screen as my data base and drag the music i want into the correct place. This is the simple way to upload music into your data form. To insert a photo it is the exact same procedure.

This photo is the end result. As you can see there is a alburn cover and a demo track saved as a form

Assessment report 1

If  i had more time for my assessment i would make my data base with a better design.
when the peson clicks on the " title of track" botton and they type the track name it is links to a form, which is very blank and blaned. If i had more time i would link the botton to a report.