• 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

Visual Basic project

Extracts from this document...

Introduction

Menu design The menu structure is as follows: Module design Visual Basic modules will be used to automate many aspects of data entry and updating of customer records. Complete listings of the code for all buttons, events, etc. in two data entry forms will be given in the hard copy of solution Entering an order for a new or existing customer (The design is expressed in the pseudocode.) Security and Integrity of Data Integrity Errors in entering the data are reduced by the use of the validation checks on the system, and also by visual verification on the part of the operator before entering the order. The application will be tested to ensure that errors in the system do not threaten the integrity of the data. Security The database file will be password protected to stop an unauthorised user from opening it and making changes. It is expected that the computer system used to enter the data will be in a physically secure location, and that it may run a secure operating system such as Windows XP which requires a user to log on and which can be used to set access permissions to the database file. ...read more.

Middle

8850 4175 11 Miss Horn E 50 Orchand Av Belvedere Greenwich SE5 8UK (01708) 862371 12 Mr Johnson A 106 Marston Av Dageham Greenwich SE9 6GH (01708) 868929 13 Mr Bashkevits A 125 Broohill Rd Woolwich Greenwich SE18 6UU (020) 331 0999 14 Mr Wait A 35 Parker House Woolwich Greenwich SE18 6PP (020) 661 7653 OrderNo OrderDate RequiredWeight(kg) Cancelled 102 04/11/2005 7.5 No 103 04/11/2005 8.5 No 104 02/11/2005 5.0 No 105 04/11/2005 7.5 No 106 11/11/2005 8.5 No 107 08/12/2005 9.5 No 108 13/11/2005 5.5 No 109 22/11/2005 6.5 No 110 05/11/2005 7.0 No 111 09/11/2005 6.0 No 112 10/11/2005 7.5 No 113 09/12/2005 6.5 No 114 25/11/2005 8.5 No 115 25/11/2005 8.5 No 116 26/11/2005 8.5 No 117 15/11/2005 7.5 No 118 16/11/2005 7.5 No 119 16/11/2005 7.5 No 120 16/11/2005 7.5 No 121 17/11/2005 5.0 No 122 15/12/2005 8.0 No 123 01/11/2005 5.0 No 124 02/11/2005 5.0 No 125 12/12/2005 6.0 No 126 13/12/2005 6.0 No 127 15/11/2005 9.0 No 128 15/11/2005 10.0 No 129 15/11/2005 10.0 No 130 20/11/2005 6.0 No 131 20/11/2005 6.0 No 132 20/11/2005 7.0 No 133 12/12/2005 7.5 No 134 12/12/2005 7.5 No 135 12/12/2005 8.5 No 136 11/11/2005 6.5 No 137 11/11/2005 6.5 No 138 22/11/2005 7.5 No 139 22/11/2005 7.5 No 140 22/11/2005 5.0 No 141 22/11/2005 7.0 No TurkeyID TurkeyWeight(kg) ...read more.

Conclusion

Customer form remains open. 9 Press Add Customer, enter customer name,then press Add Order button FrmOrderSheet opens with customer name displayed. Order can be entered 10 Press 'Return to Customer Details' Customer form opens showing the same customer and in the subform, the order that was just added 11 For customer 13 (Bashkevits) Add Order 142 Order added 12 Attempt to add another order 142 Error message comes up 13 In frmCustomer form locate a customer (B. Chapman) and highlight and delete OrderNo 126 Order deleted 14 Double-click OrerNo 136 in frmCustomer form with Customer 13 (A. Bashkevits) on screen FrmOrderSheet form opens with details on screen 15 Print report of all customers All customers appear on the report 16 Print rptBill, entering the CustomerID 13 Customer details, order details, and payment details appear on the report. 17 Test Reports Menu option, then each submenu option Reports correctly displayed in preview mode 18 Select Quit option Access closes down 19 Test 'recovery' after power failure Only current changes lost 20 Test Cancel Order menu button Order cancelled successfully 21 Test "Available Turkeys" button, when no turkeys are left Caption changes to "No more turkeys", and when you tab out of the button, the caption changes back to "Availble Turkeys" Test Results ?? ?? ?? ?? Terry's Turkeys 16 ...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 Computer Science 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 Computer Science essays

  1. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    Limitations of the Waterfall Life Cycle Model The waterfall model assumes that the requirements of a system can be frozen (i.e. basedline) before the design begins. This is possible for systems designed to automate an existing manual system. But for absolutely new system, determining the requirements is difficult, as the user himself does not know the requirements.

  2. Visual basic

    due to its object oriented - event driven design. VB is Event-Driven * In event-driven programs the user dictates the order of program execution. * For example, in the Move Ball Program by clicking on a button with the mouse (the event), user chooses how the ball will move.

  1. Computing Project

    The system must be able to assign rented DVD's to people who have borrowed them * The system must also print out a receipt for the customer * The system must also be able gather a list of all loans which are overdue and be able to print this list

  2. I have been given the task to design a database for a company called ...

    Finding price from weight and total dimensions To run this query in my database the user has to fill out the weight field in the 'Parcel form' and then the Order form using that customer's parcel ID, customer ID and destination ID.

  1. Video Club Database Project

    Unique primary key Title Text (50) Actor Text (50) Actress Text (50) Type Text (20) Number of copies Numeric (2) Duration Text (6) Attribute Name Data type and length Validation Code Text (4) Unique primary key Name Text (20) Other Names Text (20) Date Of Birth Text (8)

  2. Spare Parts Database Project

    The database should hold information on item and customer. 3. It should be possible to update the stock automatically and inform the suppliers when the re - order level has been reached. 4. Customer should be informed on new products by selecting criteria and mail merging.

  1. Computing Project

    Will you be the only user? Yes I will be the only user to access the details and your software, it would be necessary to have it password protected for data protection purposes. Can you use software such as access to input and view data? Yes I have had training on this, this is what they

  2. Smart Card System

    Even though the majority of the analysis tools support the common log file format, but the information about each server transaction is fixed. In many cases, it is desirable to record more information. Sites sensitive to personal data issues may wish to omit the recording of certain data.

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