Input and Output Report Essay Example for Free

Input and Output Report EssayField NamesCustomer ID (the preposterous reference number given to every customer that has traveled with First Travel)Customer_ IDTitle (the title of the customer e.g. Mr, Mrs etc. I have done this in a drop down menu so that no other text evict be given)TitleCustomer First Name (the initiative name of the customer)First_ NameCustomer Last Name (the brook name of the customer)Last_ NameBilling portion out (the house number and street of the customer)Addressmetropolis (the city/town in which the customer lives)City agency 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_CodeEmail Address (the email address of the customer)Email _AddressHoliday Reference(the holiday reference number is given to those customers that atomic number 18 travelling)Holiday _ RefDestination (the arrival airport of the customer, it forget be given as a three letter co de)Arrival_ airdromeHotel (the hotel the customer is staying at)HotelPayment Made (this field will be added in Excel)N/ATotal Amount (this field will be added in Excel)N/AOutstanding Payment(this field will be added in Excel)N/ADesign and creation of Database Spreadsheet3.1 Data Capture Form for Invoice3.2 Data Capture Form for E-TicketData CapturedField NamesCustomer ID (the unique reference number given to any customer that has travelled with First Travel)Customer_ IDTitle (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)TitleCustomer First Name (the first name of the customer)First_ NameCustomer Last Name (the last name of the customer)Last_ NameBilling Address (the house number and street of the customer)AddressCity (the city/town in which the customer lives)CityPost 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 lett ers)Postal_CodeEmail Address (the email address of the customer)Email _AddressHoliday Reference(the holiday reference number is given to those customers that are travelling)Holiday _ RefDeparture Airport (the departure airport of the customer, it will be given as a three letter code)Departure _ AirportArrival Airport (the arrival airport of the customer, it will be given as a three letter code)Arrival_ AirportFlight Time (Outbound) foreign terrorist organizationFlight Time (Inbound)FTIHotel (the hotel the customer is staying at)Hotel3.3 Unique Excel AdditionsUnique Excel AdditionsDescriptionsFormulaMINThe MIN function finds the minimum value in any range. I my case it finds the holiday with lowest price.=MIN(RANGE)MAXThe MAX function finds the maximum value in any range. I my case it finds the holiday with highest price.=MAX(RANGE) intermediateThe AVERAGE function finds the average value in any range. I my case it finds the average price of a holiday.=AVERAGE(RANGE)ABOSOLUTE CELL R EFRENCING (ABR)ABR uses a fixed stall 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)