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

    Failing this I may need to offer some level of literature which can educate them with the blog aspect of the website. As EVDOP Live would like a database for their company booking system, it can be said that there will be some level of training required with the software which will be sued: Microsoft Access.

  2. Free essay

    ICT organisation project

    subscript New Publication Purpose, Ethos and Target Audience The purpose of the new publication will be to inform people of the council's work in the Borough and how the council payer's money is being spent to improve the quality of life for others.

  1. A2 ICT CouseWork

    can contact us via email and allows Workload to add news to their website on a daily basis, without this interactivity Workloads website would be pointless as these are the reasons for creating this website. As I have explained above how important processes testing is, so it is very important

  2. transmission of care values

    Non-verbal and verbal messages are interpreted by different cultures in different ways, and this can create barriers to communication. Physical Barriers Deafness, blindness, speech defects and learning difficulties can cause barriers in communication because if a person has one of these disabilities they may not be able to understand fully,

  1. User Guide to my minibus hire database.

    The subform to the right does not need to be filled out as the data from this form is dependant on the customer ID chosen. Adding minibus records: - Beside the "Hiring ID" label there will be a data entry box, this box does not need to be filled in

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

    before like 10 years ago they didn't have this huge big company as now because of the economy and they didn't use to have the same manager and before they didn't have regular customers with advanced budget and the electricity stuff they have now is like 10x what they used to have back in time.

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

    Data should be "adequate, relevant and not excessive" [1]. This means that:- I. You should sufficient data the intended purpose you collected in the information for. II. With no more than necessary to carry out the job in hand. When collecting information you only collect what is relevant to fulfill

  2. ICT revision notes - IT project management

    The phases may be the same but they are not linear. Developers can go back at a later stage and improve earlier stages. âIteration can lead to constant redesign and implementation of the system. This can be tie consuming and it is important to set timescales to ensure that this doesn’t happen.

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