• 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.

    "0" is not known as a number in the world of databases. Finally, primary key is used in the table design to uniquely identify each record in the table. So for this situation, the member number will be a primary key in the table as it gives every member a unique number to be identified by.

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

    24/03/2007 30/03/2007 9 Mention the timing of the restaurant. 02/04/2007 06/04/2007 10 Mention that there is free delivery and that there are vacancies available 08/04/2007 12/04/2007 11 Mention the phone number of the restaurant and the address. 15/04/2007 21/04/2007 12 mention that the restaurant takes checks, cards &cash.

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

    So by using all this details Mr. Hussaini can easily maintain the business of the shop. Data manipulation: The tables required in the system will be Customer, Video and Issue and return. The individual field in each table will be as follows: * Customer [sl- no., name, phone no., address, date of entry, advance which needs to

  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. Evaluating a relational database solution

    These made my output results clearer and contain only the information that I was searching for. It was easy to see what the table looked like by simply clicking on the datasheet view in the top left of the screen.

  2. What is a database?

    What about if Miss Alexanderson-Smith were to get married to a Mr Featherstonehaugh and she wanted to keep her own name - 18 characters isn't enough for Mrs Alexanderson-Smith-Featherstonehaugh. This may be a little exaggerated but it does help to show a point, when you set up a field you

  1. Opening the database

    This ensures that the user does not enter the same record twice because they can easily view the others. * By selecting the arrowhead the user can scroll through all the records that have been entered into the database. They can keep clicking on this until they reach a record

  2. A Program for a Cinema Manager

    The spreadsheet program automatically updating figures does this. I will be using will make using and updating the figure easy and fast. I will lay out the income, expenditure and other aspects in different clear worksheets. I will receive the data from the cinema owner, when I have finished I hope to have made a fully working spreadsheet

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