• 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
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50

Creating a database - Mr Parkes wishes to have a computerised order processing system.

Extracts from this document...

Introduction

TABLE OF CONTENTS STATEMENT OF THE PROBLEM 3 Introduction 3 User Requirements 3 ANALYSIS 3 Initial Investigation 3 Payments 3 Supplier orders and payments 3 Integration with existing system 3 Hardware and software 4 User's skill level 4 Data flow diagram 4 Objectives of the new system 5 Performance Indicators 5 DESIGN 6 Consideration of solutions 6 Manual system 6 Spreadsheet system 6 A purposely designed system 6 Existing system 6 Access database 6 Final choice software 6 Database design 7 Entity-relationship diagram 7 Table design 7 Form Design 8 Query design 9 Macro design 10 Menu design 11 Security 11 Test Strategy 11 Test plan 12 User testing 15 IMPLEMENTATION AND TESTING 15 Test results 15 Test 1 15 Test 2 17 Test 3 17 Test 4 18 Test 5 20 Test 6 22 Test 7 24 Test 8 26 Test 9 28 Test 10 29 Test 11 32 Test 12 33 EVALUATION 34 Performance criteria 34 USER MANUAL 34 Introduction 34 Starting the system 34 Security and passwords 34 The main menu 35 The Invoice Form 36 The Backup Form 37 The Product Query 38 The Payment Form 39 The Customer Form 40 Invoice Form 41 Calculate and print invoices 41 Payment Form 42 Payments 42 Quit Application 42 Backups 42 TECHNICAL MANUAL 43 Macros 43 Queries 47 STATEMENT OF THE PROBLEM Introduction RS Supplies in London is a small business which specialises in the import and export of specialist medical equipment for hospitals as well as for other independent businesses. At the moment all orders have to be processed manually including invoices as there is no order processing system. However, the clientele is growing and Mr Parkes wishes to have a computerised order processing system. He has a computer which is used for typing up and storing invoices, but feels that a computerised system for processing orders and producing invoices is needed. ...read more.

Middle

This displays the total amount of the order. 4. CUSTOMER QUERY This query uses the same expression as that for Payment Query to display the contact details of a specific customer. Report design Reports are used to produce the invoice as they can be customised by the user. Query1 This report is used to create the invoice. It is made from the query of the same name. The invoice structure consists of the records for each product a customer Macro design Macros are used for opening and closing forms, queries and reports, as well as 'importing' data from one form to another, backup of tables, message boxes and record navigation. QTYmacro This is a macro which imports the Customer name and ID from the Customer Order Form to the Payment Form. (This is run when the user clicks on "IMPORT CUSTOMER DETAILS" on the Payment Form, but only runs when the Customer Order Form is open and minimised) MSG11 This macro displays two dialogue boxes when certain conditions in the design of the macro are satisfied. This macro is attached to the "Total" field on the Payment Form. (This macro is run when the user enters an amount in the "Total" field, which is less than �10,000 or greater than �10,000 and then clicks on "CHECK PAYMENT") BACKUP INVOICE TABLEmacro This macro is used to backup data from the Invoice table to a database on a floppy disk. (This macro is run when the user clicks on "BACKUP INVOICE TABLE" on the Backup Form. There are three more macros like this which copy the tables in Table design - above - to the floppy disk) Menu design The menu will be created manually. Below are the notes on the implementation of the menu: There will be six buttons on the main menu which open the following forms: * ProductQuery * INVOICE FORM * BACKUP FORM * PAYMENT FORM * ADD/EDIT CUSTOMERS * CLOSE The main menu will appear automatically when the database is opened, and the main database window will be hidden. ...read more.

Conclusion

menu; * Click on IMPORT CUSTOMER DETAILS to 'import' the customer name and ID from the Invoice form (the invoice form must be open for this operation to work); * Enter the total amount of the order in the TOTAL field; * Click on CHECK PAYMENT to determine whether or not a payment has been made for that order. Quit Application This is done by clicking on CLOSE on the main menu. However, this doesn't close Access. Backups You should backup the database to a floppy disk at regular intervals, and store the disk in a safe place. TECHNICAL MANUAL This manual is for more experienced users of Access as this allows the user to maintain or enhance the system. Macros The screenshot of the macro MSG11 gives an overview of the message box macro: This macro is attached to the On Click event property of the "CHECK PAYMENT" button on the Payment form The above two screenshots show the macro MSG11 in design view. There are two different conditions which display two different messages. The screenshot of the macro QTYmcr gives an overview of the SetValue macro: This is a SetValue macro which 'imports' data from the Invoice form to the Payment form. This screenshot of the BACKUP INVOICE TABLEmacro gives an overview of the copy object macro: This macro is used to copy the INVOICE TABLE from the database RS Supplies.mdb to the database BACKUP.mdb on the floppy disk. The NEW NAME field in the arguments section of the macro window (shown above0 is left blank as this allows the object being copied to have the same name when it is copied or restored. Queries The following query, Query1 is used to calculate invoices: The following query, ProductQuery is used to search for a particular product: The following query, PAYMENT QUERY is used to search for the payment details of a particular customer: The following query, CUSTOMER QUERY is used to search for the details of a particular customer. (3,746 words) 1 ...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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    The net payroll processing for MSI employees is out sourced to ADP. Using the standard SAP - ADP link the gross payroll results shall be uploaded to ADP for the final processing. The SAP US Payroll allows MSI to process payroll for employees in the United States, using data from

  2. What is transaction processing?

    A spreadsheet is often used for budgeting, financial planning, expenses, sales forecasting, predictions and charts. In some cases in Industry when a large number of worksheets are involved in producing re-calculations, the program is enabled to manually calculate at given period in time.

  1. Smart Card System

    Therefore, we studying JCE 1.2.1 and make use of its cryptographic strengths. Chapter 3: Smart Card Technology 3.1. About The Java Card Technology In the Java Card specifications enable JavaTM technology to run on smart cards and other devices with limited memory.

  2. System I designed in order to produce a promotion package for her newly formed ...

    We found out that both companies are potential users of mail order and both agree that it is very reliable to store and process their data by using the system and agree that the system is not completely perfect as some errors do occur once in a while.

  1. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    Schedule feasibility: The schedule feasibility looks at setting out a time frame for the completion of the proposed system. The deadline given is for a fully functioning system ready for implementation by Easter 2003 including an in depth high quality write up.

  2. This report aimed to replicate Stroop's (1935) experiment. Using the repeated measures design and ...

    other set will the times to complete test B (explained in the procedure on the next page). A standard set of instructions can be found on the first page of the web site. The independent variable will be the colour interference and the dependant variable will be the time it takes for the participant to verbally respond.

  1. The Global Positioning System

    The data from all monitor stations is relayed back to Schriever AFB, where it is analysed. It is then decided if any corrections need to be made to any satellites. If any corrections are needed, the data is uploaded to the satellite.

  2. Small Office Network Implementation - hardware and security.

    For example, some buildings might have restrictions on installing cabling or requirements to use existing cabling. Other locations might restrict the use of wireless network devices due to electrical shielding or interference. * Security for the Internet connection- The Internet connection, the physical method of connecting one or more of

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