• 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. AQA GCSE ICT Specification B

    Success (Test 10), (Test 7) Test 8, 7 Test 9, 10, 11 Evaluation Criteria 1 Criteria Details On opening, the main menu should appear, and the navigation panel should not. Evaluation The criterion was met. Evidence Limitations If the user is pressing the shift key when opening the system, the

  2. Database design for a games shop.

    It cuts out the mistakes which will aid blockgamester if they are in a rush or forget to enter something. Data validation Data will be validated before it can be stored in the laptop. Common mistakes like a telephone number which have 11 digits, if by mistake there are not 11 digits an error message will appear.

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

    This sheet will be subdivided into different parts of meals and contain the specific information. By doing this and adding different fonts, pictures, colours I will finish my menu with the help Microsoft publication. Outputs: Different designs of the grid were considered, which are as follows: 1.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Once I had selected the formula icon, a box appeared listing all the different functions you could choose. I selected "VLOOKUP." If the function you are looking for is not in the list provided, then most likely it is not presenting the full list of functions, it is maybe showing "the most recently used."

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

    remaining in the shop, so whenever a customer needs that particular cassette, it is easy to trace the availability of the cassette in the shop by seeing the remaining cards. In this way it's easy to maintain the shop but be careful by not loosing any cards, this might create problems in maintaining the business.

  2. Spreadsheet for a basketball company

    range of formulas for performing intricate calculations * Requires IT skills to set up * Page setup are complex for printing * Complex searches have a limit and must be physically created each time. 1.5. Chosen Method I have chosen a spreadsheet since it is very convenient to use and maintain.

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

    * It makes the company more organised and professional, taking up less space. * Finally the spreadsheet must be as simple to use as possible, incorporating If and VLookup statements, must first be tested and analysed if it is satisfactory and does not affect the simplexes to use factor of

  2. Produce a spreadsheet for a successful and potential company

    The shop has expanded their stocks and sells hair accessories along with the dress and other accessories like the jewellery and shoes. They would like the opportunity to expand the company into a chain business. The company is based around the South west of London, in the south east of England.

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