• 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. Youth Club Database Solution

    Where you see a � sign, indicating currency, the cells have been formatted as 'Currency'. As a neat finishing touch I have put black outlining borders under the first Row and vertically throughout the accounts section where data is being entered and it is easy to lose track of where you are.

  2. Documentation of a database for a sports centre.

    Name of Form frmMainMenu Data Source (Table/query) n/a (Design of a menu screen) Form layout/design {Annotated drawing/sketch of design required} Object Event Action Activities On click Opens the different types of activities available to customers. Member Information On click Spread sheet on all members appears.

  1. Evaluating a relational database solution

    in, it had many good features which helped me throughout my project and was easy and simple to use after I had learnt the basics. I tried to please the user by putting their thoughts before mine and ultimately it was efficient enough to get the needed tasks done.

  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

  1. DVDVG Database

    There are also no spaces in table names, or field names, this is to save space. Creating tblCustDetails 1.) To start creating the tables select the Create table in Design View option ()

  2. A new IT system in a Dubai Marauders Rugby Football Club

    The input is to actually design the spreadsheet. I have to lay it out so that it is efficient and clear and so that there is enough room for all income and expenditure. Titles will have to be created for each section and formulas must be created for monthly income, monthly expenditure, money brought forward, money carried forward,

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

    * Picture to make it look attractive. * Colors of the menu * Sections on the menu * Types of the dishes classification. Viz Vegi. * Contents of the dishes. * Photographs of the restaurant * Address and phone numbers * Map showing the current position of he restaurant * Some information about the awards won by the restaurant.

  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

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