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

Youth Club Database Solution

Extracts from this document...


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.


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.


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

    to be displayed, what title I wanted to use and in what format I wanted my output to be in (Tables, records). Buttons and Macros were also easy to design as they also had 'wizards' to help you, and they also let you decide when designing the buttons which macros,

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

    All the member's files should be computerised so that the club can perform regular searches on the data (such as to find all first team members). An enrolment form (data capture form) should be produced for new applicants, so that their information can be stored on hard disk.

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

    * Some information about the famous actors and actress visiting the restaurant. The above information is fully used in designing this project. I am going to manually key in all the above data so as to make a proper menu. The menu will contain 2 sheets each having 3 sides.

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

    A field called Date of Birth should not be used as a Primary Key because more than one person in the table might have the same Date! Usually a Primary Key is a field, which, within its table, contains unique data for each record.

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

    This icon is used to represent formulas; formulas are often very useful as they work out specific calculations which speed up certain tasks which are required in your job for example, an if statement allows you to type in the criteria you want so that it can say a certain

  2. bookings database

    Ideas for improvement would be to add the 'Make a booking' command button so after seeing the details, you can make a booking. Also, there should also be the 'Modify Guest details' command button so after checking whether the details are missing from one form, you can modify this. 3.

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

    HEADINGS OF DATABASE Date Description of item Quantity Price Total/Sub-Total VAT Profit /loss Trade price/retail price Validation check (whether entry is possible) Restock Overflow Stock bought Purchases TASK C: Spreadsheet coursework page 4 WHAT SPREADSHEET WILL CALCULATE Total/Sub-Total VAT Profit /loss Restock Overflow (whether too many unlikely items are sold e.g.

  2. Developing an I.T. system to monitor School Attendance

    To provide a secure storage for student attendance record and student lateness. 5. To provide an efficient way of maintaining student attendance record and monitoring attendance record. 6. To provide up to date information on subject and options of the student.

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