Input and Output Report Essay Example for Free

Input and Output Report Essay 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) Postal_Code Email Address (the email address of the customer) Email _Address Holiday Reference(the holiday reference number is given to those customers that are travelling) Holiday _ Ref Destination (the arrival airport of the customer, it will be given as a three letter code) Arrival_ Airport Hotel (the hotel the customer is staying at) Hotel Payment Made (this field will be added in Excel) N/A Total Amount (this field will be added in Excel) 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) 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) Postal_Code Email Address (the email address of the customer) Email _Address Holiday Reference(the holiday reference number is given to those customers that are travelling) Holiday _ Ref Departure Airport (the departure airport of the customer, it will be given as a three letter code) Departure _ Airport Arrival Airport (the arrival airport of the customer, it will be given as a three letter code) 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)