• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  • Level: GCSE
  • Subject: ICT
  • Word count: 1655

Youth Club Database Solution

Extracts from this document...

Introduction

Youth Club Database Solution I have now created a system, using Microsoft Excel that can be used as a computerised system for the Christ Church Youth Club. Using Excel I have created a system that combines a Database and Accounts and so has two separate uses and is compact for the User. This section provides detailed information of how my solution works, with the use of screen dumps and callouts. The Database This is just simply a database of all members and their details that have been typed in, and will have to be typed in by the User. Every record is numbered and this number is in Column A. For the Front End to work, these numbers must be in numerical order, and this will be covered later. In this first section up to and including Column J, there are a few features and tools that have been used. Filtering In Excel there is a tool that lets you query the database without using other dialogue boxes. If you go to Data, Filter, AutoFilter, a series of small arrows appear on the top row: If you click on these arrows, a drop down menu appears with a list of options (this example is from the 'Gender' Field), and an option can be chosen. ...read more.

Middle

It is counting all the dates that are in the second Row. The "$" signs before each part of the cell reference means an absolute reference, so wherever you copy the cell to, the cell references will stay the same. If you don't put a "$" sign around the references, they will change depending on where you copy it to. For example, if you copy a formula containing the cell reference O2 down one row, it will become O3, down two cells it will become O4 and so on; if you copy it across one Field, the same reference will become P2, across two Fields it will become Q2 and so on. The next formula is in Column L, and is another COUNTIF formula: =COUNTIF(O#:IV#,"1") This is very similar to the previous formula, and is used to count all the times a member attends the Youth Club. A one is entered into the 'Attd' Field for each week, and this formula will count all the "1's" appearing in the cell range O# to IV#. So at the end of the term or year, the User can see how many times each member has attended the Youth Club. I have used # symbols to signify that the formula is different for every member, as in this case, the formula will count everybody's personal attendance records. ...read more.

Conclusion

This is the final result, a very professional looking Front End: Macros These are very simple to create and very easy to use. I have put four simple macros in the Front End for the User to use, and the User Guide explains for the User how to create new ones. The first step is to select a button from the forms toolbar: A dialog box then automatically appears giving you the chance to assign a macro or create a new one. To record a new one, click on the record button: From there you can rename the macro, as long as the name contains no spaces, or assign a shortcut key, with Ctrl + (another key). From there you click 'OK', and you are ready to start recording. The computer will then record anything you do, so for example you could sort or search the database and then create a graph. Once you have finished, you click the stop button, and anything you have done will be stored in the memory in the button. You can rename the button by right-clicking on it and selecting the text and the macro is ready to use. PHILIP HARFORD 10O MAJOR ASESSMENT - DATA HANDLING ...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. Reviewing different multimedia presentations.

    Then there is you teenagers in the age range of 13-18 who would use it to learn about the body in detail and then use it as a fun revision tool as it has all the information. Screen shot How does the text/image relate to the aim(s) of the product?

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

    There I am going to create a new sheet by taking brouchers then menu as my option and here I will automatically have 2 sheets with 3 sides each. 2. To surf the net and collect Pictures and see samples of logos, I will directly go on the net and

  1. Project 1b; Film Database

    In this screen print I will show the validation rule I set up to validate typed in data for the data field certificate: In the following two screen prints I will demonstrate how the data I type in is validated by typing in unsuitable data.

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

    This becomes useful when there is a lot of data that requires to be saved, but will not fit on a single disk but on numerous floppy disks. The good thing about the backup drive is that it is not too expensive, as the disks usually cost around �5 and the backup disk drive around �100.

  1. Database Section

    The printer needs to be fast, cheap and economical. The quality of the printouts is not really important, as the standard of them does not need to be that high. The customers are not going to see them. c) Output I will need to produce at least 5 printouts from my database that's will be needed in the day-to-day operation of the system.

  2. Evaluating a relational database solution

    In Microsoft Access it was easy to do queries because all of the fields I needed to search for information in were laid out into a neat table and I could easily tell where to type the information I was looking for.

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

    The field chosen as the Primary Key must contain unique data for each record in the table. Examples:- A field called Surname should not be used as a Primary Key because two people in the table might have the same surname!

  2. The project that I have decided to make will be a Final Fantasy Fan ...

    Also with an internet website the owner of the web page would have to e-mail all members, rather than do this I would like to use a database system to send proper letters to the members which are more informative than an e-mail.

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