I have been asked by the manager of the pop group Band On Tour to create a database for him, you see he used to have a shabby old filing cabinet, well all is about to change when I have finished this database for him.

The highlighted option is the one you should double click on, which will give you:

   

Once you have filled in the table it should look something like this:

By pressing this button, located in the top left hand corner, this will automatically save your table and move on to:

These two tables above should be as one but did not fit on the page so I halved them. Now you can enter in information.

By pressing this button in the top left hand corner, this will change the screen back to table 1.

Now, if you go back to the main menu, click on ‘Queries’, and then double click on ‘Create query in Design view’, this will bring up the next menu. The idea of a query is to search for a file in speed, for instance if you wanted to know how many people are going to a certain gig, then you would put the information into the query and it would come out with the files that you wanted rather than scrolling through for hours trying to find the file you want.

Now you click add, and a small box will appear in the top left hand corner of the screen. This box will be named as Table1. Double click on the star sign ‘*’.                                                         

The arrow points to the star which you should have double

clicked on.

This arrow points to the field, which will now allow you to search for individual files.

Now you enter the information, for instance under venue, you would put the name of the venue, and then to find out who is going to venue; you need to click on the box in the top left hand corner:

Now you can see that the venue has come up, with all the necessary details.

Now you need to go back and choose some more details to find, if you need them, to do that you need to click the button in the top left hand corner:

This will bring you back to the menu you were just on. Now you can find one OR more things.

Now you can do most things on access there is just one more thing, creating a form, which will present the work with style.

Double click on Create form by using wizard.

This is what you should have as the finished product:

Now you can browse and change files, with an interesting background!

Now you have finished your database and created a letter to send off, you now need to merge the letters.

1. In your letter in Word, go to tools> mail merge

2. Go create > form letters> active window> get data 

3. Open data source> look for ms access database> choose your video club database>ok