Input and Output Report Essay Example for Free

Input and Output Report EssayField NamesCustomer ID (the bizarre reference number stipulation to both client that has travelled with First Travel)Customer_ IDTitle (the title of the customer e.g. Mr, Mrs etc. I have through this in a drop down menu so that no other text stop be effrontery)TitleCustomer First Name (the first gear name of the customer)First_ NameCustomer termination Name (the last name of the customer)Last_ NameBilling cover (the house number and street of the customer) regale city (the city/town in which the customer lives)CityPost Code (the post label of the customer-I have inserted an input mask which ,means only six characters cigaret be entered in with 3 digits and triple letters)Postal_CodeEmail Address (the email address of the customer)Email _Address pass Reference(the vacation reference number is given to those customers that are travelling)Holiday _ RefDestination (the arrival drome of the customer, it will be given as a three letter code)Arrival _ AirportHotel (the hotel the customer is staying at)Hotel salary Made (this theme 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 suppress 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 merchant ship 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 le tters)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 airdrome 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 clip (Outbound) FTOFlight Time (Inbound)FTIHotel (the hotel the customer is staying at)Hotel3.3 Unique Excel AdditionsUnique Excel AdditionsDescriptionsFormula arcminuteThe MIN function finds the minimum value in any range. I my case it finds the holiday with last(a) 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)AVERAGEThe AVERAGE function finds the middling 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 tubful prices.=(CELL)*$(letter of cell)$(number of cell)