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

User Manual

Extracts from this document...


User Guide Contents Introduction 1 Opening the database 1 Adding a new customer 2 Adding a new DVD 3 Adding a new rental 3 Introduction This database has been created for Ickenham Video Shop, and is designed to manage the shop's members', DVDs', and rentals' details so that they can be rented out by customers and returned efficiently. The database can be used to: * Add new members to the company's system * Add a new DVD to the company's stock * Make a new rental and log the details of the booking * Use queries to create reports for the company about members, DVDs, rentals, or a mixture of all three. ...read more.


Click 'open' to continue. The switchboard will then appear which means the database has been opened correctly. Adding a new customer Once the switchboard is on screen, you can now add a new customer to the database by using a simple form. On the main menu page of the switchboard, click on 'Data Entry Menu'. Then click on 'Add New Member'. The 'new 'member' form will then appear with text boxes where you should type in the member's details. You do not need to type anything into the field 'Member ID', this will be done automatically. Type the surname and forename in each box, using only letters. ...read more.


When typing in the certification, is must either be a 'U', 'PG', '12A', '12', '15', or '18' or 'Other'. An error box will appear if an incorrect certification has been inputted. When typing in the 'Star' field, it must be a rating of 1-5. 0 or 6 will count as incorrect and an error box will appear. Adding a New Rental To add a new rental, go to the main menu on the switchboard, then click 'Data Entry Menu', then click 'Add New Rental'. The new rental form will appear on screen. The dates must be in the form of 00 (day) / 00 (month) / 0000 (year). You must type in the member ID and DVD ID to make a rental. You do not need to type in the rental ID. ...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. Database design for a games shop.

    Walcott's letter. Blockgamester main problem was losing data about the game due to the fact he wrote on paper, now Mr. Walcott can easily input data in to the system in a more organized way. Furthermore he can now reply to customers quickly with the customer detail search, with regards to their game overdue.

  2. AQA GCSE ICT Specification B

    For instance, a credit card number can only have 16 characters. If a user added an extra character by mistake, the system would recognise this as a 17th character and not allow it. Format Check Applies To Email Address Postcode Evidence of Implementation Justification A format check ensures that the

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

    find suitable pictures using 'Google images' here I can easily search for different menu logos as well. I will insure that they are not copyrighted and so I will get permission. 3. Text will be taken form Mr. Hussaini as he has the recipe for different dishes and then I am going to key in manually.

  2. Database analysis of 'a video lending library'.

    Calculations can be done as well, formulae can be entered, different font sizes and fonts can also be used. But tables that have to be made usually takes time and as use of the tables is one of the user requirements I think the solution of access is better.

  1. Spreadsheet for a basketball company

    Restrict users from entering any anonymous value in the seating area 6. Calculate the company's income and expenditure for every match and based on these results, calculate the total profit for that specific match 7. Automate graphs relative to the company's income, expenditure and both of them in opposition to each other automatically 8.

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

    400 computers) My specification of problem is the amount of files needed to work out the exact amount of items sold without getting papers lost. That's why, my spreadsheet will not only be easy to use but will store all the necessary information of a complete month in one piece of paper.

  1. Produce a spreadsheet for a successful and potential company

    Ability to work a cash register 3. Good customer service University Degree Full-time Sales Assistant 1. Pleasant telephone manner 2. Ability to work a cash register 3. Good customer service University Degree Full-time The manager of Belle Du Jour is Josh brown. I need to conduct the following research from the manager: * How much money is spent purchasing the stock?

  2. My database is on a video rental shop.

    Describe the tables and relationships you plan to use? How many tables? I planed to create 3 tables. They will be called, table renting, table customer and table video. Table 1 - table renting Field Name Description 1 Customer ID Text, font 50, required 2 Video ID Number, integer, required 3 Date in Date/time, short date, required 4 Date

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