• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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.

Extracts from this document...

Introduction

Band On Tour 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. This Word document will give the manager of Band On Tour a small insight into his new database. Firstly I opened a new access file: Then I am asked to save the document, which I saved in my own personal user area. Doing this then brings up a screen, which gives me plenty of options what I want to do: The highlighted option is the one you should double click on, which will give you: Once you have filled in the table it should ...read more.

Middle

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. ...read more.

Conclusion

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 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Documentation of a database for a sports centre.

    This makes up background details and important information on the member. I have chosen to use data types as it will validate information that has been inputted. In this case, for contact number the data type is text as numbers include "0".

  2. Database Review of Document

    place to ensure no accidental deletion and make sure there are up to date backups to make sure there are no losses of data. VI) There is no nice easy way to get round the navigation system and no way to get round the reports.

  1. bookings database

    changed to required as if these details were not filled in, it would be difficult to either find/modify guest details or to contact a guest. 5. Easy to save the data-there is the command button that is called 'Save record'.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Each fold now contains different sections. Process: Now I am going to state how I am going to achieve each one of the quantitative objectives: 1. In order to prepare ONE menu of Total 2 sheets containing 3 sides each I am going to use the Microsoft publisher publication.

  1. Database analysis of 'a video lending library'.

    tables can be used in one data base in order to fit all the info in one database, which can make Mr. Hessian's life much easier. 4. Use of 'Microsoft excel': this is also a much easier way of storing the information, this method does not occupy much space, as

  2. Analyse - Database

    Choice of Software: In order for the system to be suitable for Mr Browne to use an appropriate software package will need to be selected. In the identify section it was distinguished a database would be suitable system to store the data concerning the bookshop.

  1. Project 1b; Film Database

    I will use the database for 15 films. 10 of these films are identified by the example data the teacher gave me and the other five records will be based on the data I have about five films taken from its DVD-Sleeves and from the website 'www.imdb.com'.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    of personal files, but on the contrary, I want a 1-file program that will calculate data. The word processors are used for typing out information in a standard or modelling kind of way, and do not help my cause either.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work