|
DESIGN
Reason For Choosing Excel As My Software
I have decided to use Microsoft Excel a spreadsheet software package, in order to create my new system for the ‘Orange Mobile’ company. ...
Customer Tel Eleven digits Number 02085657898
Item code 1-3 digits Acts as a unique identifier 1,10,100
Price Digit code Acts as a unique identifier £65
Customer ID 1-3 digits Acts as a unique identifier 1,10,100
Date Digits/text Date 25/5/2
Unit Code 1-3 digits Acts as a unique identifier 1,10,100
Item Description Text Acts as a unique I identifier Nokia 8250
DESIGN PLAN
DETAILED TABLE DEFINITION
These column headings come from all my sheets.
DESIGN
INPUT, PROCESSING & OUTPUT
INPUT
Customer (ID number, Name, Address and Telephone)
Mobile (Item code, Model, Price, and availability)
Invoices (Customer ID, Date, Invoice No, To, Address, Item code, Description, Cost, quantity, total, Net, gross, and VAT. ...
DESIGN
SECURITY
Certain cells in my ‘invoices’ sheet will be protected.
Approximate Word count = 2178
Approximate Pages = 8.7
(250 words per page double spaced)
|
|
