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

    This is because the body when you are putting the bogy parts on is blue and all the writing is also blue, but a different shade of blue. There is also a use of grey in the section where there is writing in the Multimedia Presentation, and finally there is

  2. bookings database

    Screen easy and clear to read- the main menu has five command buttons which provides the user with an easy and clear form which is easy to read.

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

    Use of a folded a4 menu, that can have three folds, this will make it easier for the customer to look at and is also not very confusing. Hence I decided to have a landscape A4 folded menu. This menu has got three folds, so that it's easy to hold and look at.

  2. Project 1b; Film Database

    I made some mistakes in my database that I which to correct now. I will mark these mistakes on the following paper with these ovals: I made three mistakes, which I will need to correct. The screen print on the following page shows the corrected table.

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

    later we would instantly store it on disk, to ensure it safety and its existence in our files and that we have a second hard copy. Once the description of item has been keyed in, due to the computers high level of intelligence, it will automatically calculate the amount due, and the heaviness of the VAT.

  2. Database Section

    * A list of all customers created by a report * A list of all DVDs created by a report * A list (report), which displays customers with DVDs that are overdue, this will be created by a query.

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

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

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