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

    I believe all in all, all of the user requirements were achieve with success. Unfortunately I believe after reading his letter, the database was not created to my highest standard. I should have used common sense in some of the situations such as: Mr.

  2. AQA GCSE ICT Specification B

    Sales Summary The list on the left was created by the Microsoft Report Wizard. It contains all the necessary information, but does not carry the company logo. It is not clearly laid out or properly labelled. It is also carried onto three pages.

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

    The colour full graphics will be inserted form the Microsoft publisher application and also photo draw, the use of different texts and fonts will be done in Microsoft publisher application, by using these attractive images the customers will easily be attracted.

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

    So now after finding the above solutions for the problem, I came to decide the best solution, which is to use a computer application which is the 'Microsoft database because this is the fastest and easiest way to store and use the data.

  1. Spreadsheet for a basketball company

    Compute the remaining stocks whenever the items of the income increase. This must be shown in both the expenditure and the income page. 2. Analyse 2.1. Hardware The hardware required is a computer, a mouse, and a keyboard. The operating system used is Windows XP to run the necessary application software for viewing and editing the spreadsheet.

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

    The screen displays the Profit/Loss and adds it to the final sales. Finally a choice is made whether to print the document or not. TASK D: Spreadsheet coursework page 2 Start Customer enters Shop Buys Something Yes Input sale on computer By typing onto spreadsheet Store on disk Spreadsheet calculates amount Of items sold and price due.

  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