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

    How to delete data Deleting a customer record To delete a customers record simply click the "Delete Record" button as shown in the screenshot above. A warning message will then appear as shown above asking you to confirm the deletion of the record, click yes if you want to delete the record otherwise click no.

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

    5. Comet Organisation Data handling Needs Comet uses ICT to store data about electricity products so that in order to keep tracking the products and check if they run out of an item and that the system would tell them and in this way it keeps it organized.

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

    and keeping portable equipment in your property throughout, i.e. laptops not being lost or stolen. The security of your computer is vital due to most of the information is now stored on digital form on a hard drive. The following things are to be taken account of when designing security.

  1. A2 ICT CouseWork

    In order to complete these tasks as efficiently as possible, our secretary will need certain skills and attributes such as People Skills, Experience and ok ICT Skills. As without these skills there would struggle when doing so. The-Audience The audience are the people who live in Torbay or locally and require our services.

  2. Wjec alevel ict creating a website

    a gallery to demonstrate to all users of the types of work that the company has done in this past. This type of animation was designed to show a professional image of the company and draw people in to use it and hopefully entice people to use the company. 6.

  1. Free essay

    ICT organisation project

    A bright and lively image is used at the bottom of the document with two people climbing a wall, which is one of the activities X Zone offers. Document 4 - "Borough leads the way with healthy fun for all the family" The purpose of this document is to advertise

  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