Microsoft Office Tutorials and References
In Depth Information
Invoice No.
Hamm Oice Supply
AB-1234
INVOICE
Customer
Misc
Name
Date
Address
Order No.
City
State
ZIP
Rep
Phone
FOB
Qty
Description
Unit Price TOTAL
SubTotal
Shipping
Payment
Select One…
Tax Rate(s)
Comments
TOTAL
Name
CC #
Expires
Office Use Only
Exhibit 2.1 Generic invoice
Office Supply, Inc. Note the amount of data that this generic invoice (an MS Office
Template) contains is quite substantial: approximately 20 fields. Of course, some of
the data are only of marginal value, such as our address—we know that the invoice
was intended for our firm and we know where we are located. Yet, it is verification
that the Hamm invoice is in fact intended for our firm. Notice that each line item
in the invoice will require multiple item entries—qty (quantity), description, unit
price, and total. Given the potential for large quantities of data, it would be wise to
consider a relational database , such as MS Access, to optimize data entry effort.
Of course, even if the data are stored in a relational database, that does not restrict
us from using Excel to analyze the data by downloading data from Access to Excel;
in fact, this is a wonderful advantage of the Office suite.
Search JabSto ::




Custom Search