• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27

Implementation of ict project

Extracts from this document...

Introduction

This is the main screen of my database; from this screen the user can access all the pages from this menu. I have assigned a macro to each button to take the system to the correct place. I will be accessing the order sheet from the main menu screen below. As you can see I have accessed the order sheet from the main menu screen. This is a screen shot of my stock sheet data it shows items which I have in stock, shown above. The sheet includes a macro which allows the user to return to the main menu. This was the current weekly sales made sheet, there are few errors on the sheet. For example the sheet is not named also there is not a price column, without this the total sales cannot be worked out. Also there are no macro buttons, or drop down lists. This is the new weekly sales made sheet and is all up to data. The sheet above includes three macros, these are print screen. This allows the user to print out the weekly sales sheet. So he can keep it as a transaction of what he has brought. Another macro added on the sheet is save sheet, this allows the user to save the sheet so he can view it later. This is an improvement to the system as it wasn't in the User requirements. ...read more.

Middle

In the screen above my supplier database, I have used format cells text. This allows all phone numbers entered to have a zero in front, otherwise only numbers will be shown as above. The screen shot shows that formatting numbers with text allows the zero to be in front. So the user can understand what county code belongs to which number. I am using a validation so that I can only enter a maximum of 11 digits. The validation means if the user enters more than 11 digits, this will be incorrect thus Showing an error message. Indicating more than 11 digits have been entered. The screen above shows the validation in process, I have entered more than 11 digits and tried entering it. A message is being shown indicating that the number is invalid, and I will have to re enter. The sheet above called weekly sales sheet shows the total amount of items the user has sold during a period of a week. It does this by using a sum function, by multiplying the price by the quantity. Then a total price is shown, also on the sheet is a print screen macro this allows the user to print off a record of transactions customers have made during the week. Another macro includes a save function which allows the user to save the sheet and view it later. The information from the weekly sales is used to compare weekly sales trend. Other macro buttons on the sheet include main menu. ...read more.

Conclusion

Transpose:=False Sheets("Add new stock").Select Range("D4").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "" Range("D7").Select ActiveCell.FormulaR1C1 = "" Range("G7").Select ActiveCell.FormulaR1C1 = "" Range("K7").Select ActiveCell.FormulaR1C1 = "" Range("D10").Select ActiveCell.FormulaR1C1 = "" Range("H11").Select End Sub Delete Stock Macro: Sub delete () ' 'Delete Macro 'Macro recorded 30/01/2008 by Tarif ' ' Sheets ("Stock sheet (database)").Select Rows ("4:4").Select Selection. Delete Shift: =xlUp End Sub Save Sheet Macro: Sub save() ' ' save Macro ' Macro recorded 30/01/2008 by Tarif ' ' ActiveWorkbook.save End Sub Main Menu Macro: Add new Supplier Macro: Sub ss() ' ' ss Macro ' Macro recorded 29/01/2008 by default user ' ' Sheets("My suppliers sheet").Select Rows("4:4").Select Selection.Insert Shift:=xlDown Sheets("Add new supplier").Select Range("C4").Select Selection.Copy Sheets("My suppliers sheet").Select Range("B4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("C4").Select Sheets("Add new supplier").Select Range("C6").Select Application.CutCopyMode = False Selection.Copy Sheets("My suppliers sheet").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Range("D4").Select Sheets("Add new supplier").Select Range("C8").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Application.CutCopyMode = False Selection.Copy Sheets("My suppliers sheet").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("D15").Select Sheets("Add new supplier").Select Range("C4:C13").Select Range("C13").Activate Application.CutCopyMode = False Selection.ClearContents Range("D16").Select ActiveSheet.Shapes("Button 1").Select Selection.OnAction = "ss" End Sub Main Menu Macro: Sub ga() ' ' ga Macro ' Macro recorded 29/01/2008 by default user ' ' Sheets("Add new supplier").Select End Sub Sub mian() ' ' mian Macro ' Macro recorded 29/01/2008 by default user ' Sheets ("Elite main menu").Select End Sub Print Screen Macro: Sub pprin() ' ' pprin Macro ' Macro recorded 30/01/2008 by Tarif ' ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub ?? ?? ?? ?? Tarif Talukdhar ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Information Systems and Communication essays

  1. communication and values

    And getting answer from them saying yes. In my one to one interaction at the end I got expression of new idea from the client by designing the card in other ways and to make different words in my group interaction.

  2. User Guide to my minibus hire database.

    report you will first need to navigate yourself to the hiring form and then click the "preview receipt" button on the record you want to print the receipt for: Once you have clicked this button, the receipt will then load in the report view, once you have this report open

  1. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    that has been entered the prices and the names of the product. Every time you want to sell the product to the customer on the screen once you scan the product it will tell you the price of the product because it has been entered by a employee which is

  2. From the e-commerce strategy you gave me earlier I understand that by having a ...

    The browser cannot see server side code because when your browser sends a request to the server, the server processes the request and sends the request back as an HTML file. When programming in client side code, you are programming what the browser would do, so the user can change,

  1. A2 ICT CouseWork

    * Client-"As customer's are going to be using our service's there should really know what our company stands for and perhaps the history of the business" - This page will be known as the "about us"page it will display mostly text about the business and images of who works at our organisation.

  2. Wjec alevel ict creating a website

    This shows the hotspot that appears when you hover over the picture of the NEC on the Warley Builders webpage. Page Transition To apply page transition to a website in dreamweaver I used the following code to do it: <META HTTP-EQUIV="Page-Enter" CONTENT="revealTrans(Duration=**,Transition=?)"> The code is inserted into the webpage using the split tab on the dreamweaver toolbar.

  1. Free essay

    ICT organisation project

    Regular items such as "Life Lines", the beginning page with letters from residents and "Whats on" containing details of events taking place in the Borough. Borders are consistently used throughout the magazine, with a 1cm border regularly used to frame the article.

  2. ICT revision notes - IT project management

    Disadvantages âReal projects do not lend themselves to the sequential approach as you often have to go back to a previous stage and make changes. âAt the beginning of most projects there is often a great deal of uncertainty about requirements and goals, and it is therefore difficult for customers to identify these criteria on a detailed level.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work