• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Identify stage of Database Coursework Model Agency records

Extracts from this document...


Amit Singh Bhopal 10B STRiDE models Database Identify Background Details Jenny has recently opened a Modelling Agency. Since there are no other businesses like hers nearby, commerce is booming. Firstly, the modelling agency advertises in the yellow pages. The potential models then ring up and arrange an interview. The interview is arranged and completed and then the model pays a fee for a photo shoot ( �200) the modelling agency then records all of the models details (name, age, height, weight, hair colour, eye colour, nationality and address manually using paper and pen to create a seperate record for each model) and then the model's file is stored in a filing cabinet. The model's details are stored in the cabinet until a client requests a model that matches with a specific set of attributes. The secretary then searches for the models that have the right attributes and makes a list. When the list has been created, the secretary phones up the client with the various models and an agreement is reached over the model(s) that are most appropriate for the shoot. These model(s) are then sent a letter to them by post with details of the location time and date stated. The letter is made using an electric typewriter. If the client decides on a particular model, they are notified of the booking. ...read more.


Jenny provided the model with a list of the bookings in the coming weeks. She also needs to write to models that haven't had a booking in the last 3 months to see if they wish to remain in her agency. Therefore, the modelling agency is a sluggish organisation that can vastly improve earnings if organised better with a better system. Manual Alternative solution To improve the current system the data relating to models, clients and bookings needs to be organised and stored in a more efficient manner allowing quicker searching facilities to identify individual records that match a specific criteria. Jenny needs to be able to find specific model details quickly or models that match a clients requirements. A manual alternative would be to have cards with colour coded stickers grouping together model attributes. This would massively reduce the amount of time it takes to sort through the files. The stickers, for models, would include something like a brown sticker for hair and a blue sticker to show that the model is between 5' 9" and 6'. For clients, it would be that the better if they are stored in alphabetical order. Bookings can be recorded in an appointment book with the client name, model name, data and time entered clearly. Overall, using an I.T solution is quicker, easier and more secure than the paper and pen method. ...read more.


The reports function will be useful to present the clients list of models used in the past. Macros can be used to make sure that things get saved automatically. The simple calculations would normally include things such as simple percentages. However, this would be irrelevant to my project. And finally, the queries would be useful to the user as it could provide an easy way to pin-point the model. Quantitative objectives 1. The user needs to be able to produce a list of specific models for a client (e.g. a blonde who is over 5' 3" for a small newspaper article) 2. Upon the above, the user needs to be able to create a mail merge to send the specific models notices and confirmation slips of where and when the model should be. The address fields also need to be merged to print off the address labels. 3. Needs to allow the user to add or edit a model's file 4. Needs to allow the user to add or edit a client's file 5. The system needs to be able to store at least 15 models records 6. The system needs to be able to store at least 10 clients records 7. It must not take longer than 1 minute to display a list of models with specific attributes and identify a particular model. 8. Print a report listing all current clients in alphabetical order must show contact name and number ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Financial Model to help organise the year eleven prom

    An alternative method would be to use a school computer and the Microsoft package, Excel. This program is designed to deal with working out numbers and problems as long as it has the right information and is given the correct command.


    ' ' mcrGradeBoundary Macro ' Macro recorded 19/02/2007 by 21bor2413j ' 'Select grade boundary sheet Sheets("Grade Boundary").Select Range("A1:C9").Select ActiveSheet.ShowDataForm ' Re-sort table in case user edit column A Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom ActiveWindow.ScrollWorkbookTabs Position:=xlFirst 'Go to Main Menu Sheets("Front End Menu").Select End Sub Mcredit/deletestudent Sub mcreditdeletestudent()

  1. Ict Powerpoint Coursework

    Akram for easy transfers from the main administrator. There is more than enough memory than needed and enough to backup every file needed just incase lost. YES This can effectively be used for back up purposes and for all of the S.A.

  2. Database coursework

    Spreadsheet This alternative is similar to the database but it can be done by a spreadsheet editing program. This alternative requires that the company has a working computer system. And in addition to that a Spreadsheet making program. It will also include that the company purchases a spreadsheet editing program.

  1. I have been assigned a task to help International Dreams Travel Agency to make ...

    Create a letterhead and design letter templates I can create a letterhead by hand but I will not because it doesn't look professional and it also time consuming. I can create a letterhead by notepad but I will not because it I cannot do some things, which are vital for me.

  2. Design-ICT Modelling CW

    The user guide will include instructions on how to program certain cells with formulae for making calculations and how to select items and change them according to a given budget. It will also come with a technical guide to help with troubleshooting in case the users face technical difficulties with the system.

  1. Database Coursework

    What procedures happen when a customer wants to register, or wants to rent a DVD? A) The receptionist helps the customers make a choice on which DVD to choose and tell them basic services the shop offers, such as how long they can rent a DVD for.

  2. Computer Studies Past paper definitions

    pages stored waiting to be printed [2] (e) virtual reality any two points from: 3D world computer simulation needs special input devices to interact - (data) goggles/gloves e.g. design of chemical plants [2] 2008 Explain, using examples where appropriate, the meaning of these computer terms. (a) batch processing (processing)

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