• 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. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    This may disrupt the creation of the solution as it may not be accurate or relevant to their problems. Also with a observation I may not record key aspects of issues they may be having, this will affect the solution creation process as I may miss out on something which

  2. transmission of care values

    from being received properly as the service user may not be able to hear any or all of what is being said. Similarly, poor lighting and proximity may affect non-verbal messages from being correctly interpreted, especially if the service user has poor sight.

  1. A2 ICT CouseWork

    or not met the client requirements and also instead of taking a screenshot we shall use a photo of someone using our website. Validation and Verification Testing- The validation and verification testing, is the testing of how we have incorporated validation and verification into our forms and to test if our validation works or not.

  2. Using ICT to communicate

    large title in the centre of the page, withy a smaller title below and the date, at the bottom of the page there is a small section of text stating "Written in plain English". Page two has a blue text box of information at the top of the page, below

  1. ict as level coursework

    Also any data that is saved on the hard drive should be backed up via a reliable medium like re-writable CDs. Data that has been backed up should be on the premises in a safe and another copy at another location.

  2. 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.

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

    Update the information, archive the information or securely delete the information if it goes out of date. If you keep the information you have too long, this could have an adverse effect on the company, for instance, if you used the old information by mistake.

  2. ICT revision notes - IT project management

    âWhere there is pressure for the immediate implementation of something – so that the users can use part of the project early on. âWhere project team members are experienced – so that they can use their own experience to cut out steps which take time.

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