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

Sorry, but copying text is forbidden on this website!

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)

We will write a custom sample essay on Input and Output Report specifically for you
for only $16.38 $13.90/page

Order now

<<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)

How to cite this page

Choose cite format:

Input and Output Report. (2017, Sep 28). Retrieved from https://studymoose.com/input-and-output-report-essay

We will write a custom sample essay onInput and Output Reportspecifically for you

for only $16.38 $13.90/page
Order now

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
online

Hi, I am Sara from Studymoose

Hi there, would you like to get such a paper? How about receiving a customized one? Click to learn more https://goo.gl/CYf83b

online

Hi, I am Sara from Studymoose

Hi there, would you like to get such a paper? How about receiving a customized one? Click to learn more https://goo.gl/CYf83b

image

Your Answer is very helpful for Us
Thank you a lot!