• 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

    Timetable for project October November December January Feasibility Study An alternative method would be to use a software package. This is going to be effortless to do because we already have a school computer network that we can use. There are programs such as Access, Publisher and Excel.


    B22 is the linkedCell. The linked cell is where the data should be inserted. Last of all I used students as ListFillRange. I named the set of data in the student list sheet as students. This is the screen shot of the properties Macro codes These are the macros I have used on the enter marks sheet.

  1. ICT Coursework (MarcoS)

    by name and date when the work is done, so you can access easily and fast to all the work done, without loosing time. The system will be accessible from anywhere in the world so every employee can check their work, and keep the account updated.

  2. Ict Powerpoint Coursework

    The keyboard is also made from Microsoft, the leading brand in computer technology, this makes this product highly reliable for what its being used for and for the price it's an must have. The desk set bundle is of high quality and has the best features up on the market.

  1. Database coursework

    copied as hard copy and it will be used when the company wants to update the data. This way the company would have necessary data recorded and updated although it's hard and time consuming. In addition to all that the company would need a cabinet/store room to store the papers.This alternative doesn't cover any (few)

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

  1. Design-ICT Modelling CW

    User documentation: When the new spreadsheet system has been implemented, successfully tested and I am sure that it works, I will need to create a user guide that will make it easier for the staff at JJ party planners to use the new system.

  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