• 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

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    This level of knowledge should be enough to enable them to be taught how to operate the data input forms and reports. I will leave the decision of staff training in the usage of ICT systems up to the manager, though I suspect that it would be sufficient for him to teach them himself.

  2. Marked by a teacher

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

    Observing my clients user will allow me to gain valuable data, observations also have a lot of positives. An example of the positive aspects of observation is that it would allow me to view the user in their normal working environment.

  1. transmission of care values

    Environmental Barriers The word environment can be defined as "the surroundings or conditions in which a person, animal, or plant lives or operates" (AskOxford, 2007). A lot of background noise, or being too far away from a service user due to poor room lay out, can possible stop a message

  2. A2 ICT CouseWork

    My Qualitative testing will share the share the same layout as my Quantitative testing, as it will use near enough the same 4 columns. Except for the "Description" column which will be replaced with the "Client Comment's" which will include feedback from our client on how he thinks we have

  1. ict as level coursework

    Data should be able to be accessed again once saved by user The user simply has to open the system again and all information present when saved should still be there. The system should be able to provide the user with accurate stock levels.

  2. Using ICT to communicate

    Page four and five look very good but it is far too obvious by the size of some of the text that they are struggling to fill the space. Page six is split in to 3 sections of coloured background.

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

    will have around a 4 screen's split in one TV and when you go into that security room you will only be able to see the TV's front of you and there is usually 2 people who sits there and watch the TV's.

  2. ICT revision notes - IT project management

    Iterative Development âThe idea here is to develop all aspects of the design simultaneously, making a little bit of progress at a time. Iterative Methods âIteration means repeating something over and over until you get the solution. âIterative methodologies have been developed to improve the waterfall model.

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