We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Input and Output Report Essay

Custom Student Mr. Teacher ENG 1001-04 28 September 2017

Input and Output Report

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)

Free Input and Output Report Essay Sample

A+

  • Subject:

  • University/College: University of California

  • Type of paper: Thesis/Dissertation Chapter

  • Date: 28 September 2017

  • Words:

  • Pages:

Let us write you a custom essay sample on Input and Output Report

for only $16.38 $13.9/page

By clicking "Order now", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.

your testimonials

Our customer support team is available Monday-Friday 9am-5pm EST. If you contact us after hours, we'll get back to you in 24 hours or less.

By clicking "Send Message", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
No results found for “ image
Try Our service