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

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

    Pictures will also be taken some from my own camera which will be copied and pasted on to the menu such as the picture of the restaurant and other pictures will be copied from the internet and then edited on 'photo draw' and 'paint' applications and then again will be

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

    registers in a file rack, which will occupy more space in the shop than that of the space occupied by a computer. Many tables can be inserted in one database that suits the user requirements, and also store allot of data.

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

  2. 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'.

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

    These calculations/rules that the computer strings along by is called a validation check. This validation consists of many variables, and must therefore be very important as, especially in my investigation. This is because if a mistake is done and a too large or small a number will result in many

  2. 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 ()

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