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

  1. Evaluating a relational database solution

    The results were automatically put into the main section. In the design view I could easily move these around and co ordinate the page as I liked because it was just like moving graphics around a normal page. I could also delete some fields and change the order of them.

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

    I will see if the totals are automatically calculated and then I will test the results by use of calculator. Microsoft Access could also be used, but this is less efficient than Excel. This is because only simple calculations can be performed, not the complicated formulas that will be used for the accounts.

  1. Description of a database and it's features!

    The database that I have produced is all about football. It is based on the premier league teams, and it consists of various kinds of information such as the team names, the team grounds alongside with additional information about the ground such as the capacity of the ground, and where about the ground is located.

  2. A Program for a Cinema Manager

    =Sum (C3:G3)-Adds up the content of cells C3 to E3. * The "what if" function. With a series of formulae, it is possible to make changes to figures and see what happens to expenditure and income. The spreadsheet program automatically updating figures does this.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    right clicking any worksheet tab already situated at the bottom of the screen, and selected "insert." Once the insert box appeared displaying all the different options I clicked "new worksheet." During the process of creating my report card, I decided I wanted to include a drop down menu, a VLOOKUP system and an If statement.

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

    Input: This rough information is refined later in the following bullet points. * How many sheets should be there on the menu? * How many dishes should be there on the menu? * Prices for the dishes. * Picture to make it look attractive.

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