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

Input and Output Report

Extracts from this document...

Introduction

Data Captured Field Names Customer ID (the unique reference number given to any customer that has travelled with First Travel) <<Customer_ ID>> Title (the title of the customer e.g. Mr, Mrs etc. I have done this in a drop down menu so that no other text can be given) <<Title>> Customer First Name (the first name of the customer) <<First_ Name>> Customer Last Name (the last name of the customer) <<Last_ Name>> Billing Address (the house number and street of the customer) <<Address>> City (the city/town in which the customer lives) <<City>> Post Code (the post code of the customer-I have inserted an input mask which ,means only six characters can be entered in with 3 digits and three letters) ...read more.

Middle

N/A Outstanding Payment(this field will be added in Excel) N/A Design and creation of Database & Spreadsheet 3.1 Data Capture Form for Invoice 3.2 Data Capture Form for E-Ticket Data Captured Field Names Customer ID (the unique reference number given to any customer that has travelled with First Travel) <<Customer_ ID>> Title (the title of the customer e.g. Mr, Mrs etc. I have done this in a drop down menu so that no other text can be given) <<Title>> Customer First Name (the first name of the customer) <<First_ Name>> Customer Last Name (the last name of the customer) <<Last_ Name>> Billing Address (the house number and street of the customer) ...read more.

Conclusion

<<Arrival_ Airport>> Flight Time (Outbound) << FTO>> Flight Time (Inbound) <<FTI>> Hotel (the hotel the customer is staying at) <<Hotel>> 3.3 Unique Excel Additions Unique Excel Additions Descriptions Formula MIN The MIN function finds the minimum value in any range. I my case it finds the holiday with lowest price. =MIN(RANGE) MAX The MAX function finds the maximum value in any range. I my case it finds the holiday with highest price. =MAX(RANGE) AVERAGE The AVERAGE function finds the average value in any range. I my case it finds the average price of a holiday. =AVERAGE(RANGE) ABOSOLUTE CELL REFRENCING (ABR) ABR uses a fixed cell to link to, so the formula can be replicated over a range. In my case I used it to find the insurance and VAT prices. =(CELL)*$(letter of cell)$(number of cell) 3.4 Using Access and Excel ?? ?? ?? ?? ...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 Hardware 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 Hardware essays

  1. ICT Report 2b: ICT in Organisations

    Also, several miles of these cables are cheaper than an equivalent length of copper wires. Therefore, for Boots it is a cheaper, albeit much better quality method for transmitting data between its stores. Finally, fibre optic cables are much less susceptible to interference.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    Sainsbury is currently looking at developing a better system to get round these problems. In the standard method, Sainsbury selling cookers etc, keeps it stock in a shop and in an attached warehouse. When stock in the Sainsbury is runs low it is replenished from the warehouse.

  1. Manchester airport

    An alarm is sounded if the computer proves that there is something that could be identified as dangerous in the bag Level 3 The third level of security is the first time when a person is actually involved. The Airport Security Manger intervenes and comes out with a hand held scanner.

  2. System administration report

    - Are records kept for software and hardware? Backup Procedures - How do you know which data should be backed up and which shouldn't? - How is data backed up? - What processes are performed? Social and Moral Issues - How are user desks laid out to reduce eyestrain and RSI?

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