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

    Further reports can be generated using Ad Hoc Query in conjunction with an SAP Payroll Infotype. However bulk of MSI requirements for legal reporting etc shall be met by ADP as the net payroll processing will be in their domain.

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

    This can be very useful when using a formula to calculate a certain equation. * You can name cells, which makes identifying cells easier. * Excel is a multi dimensional spreadsheet, this means that you can have as many sheets as you want, this is also known as a three dimensional spreadsheet.

  1. Video Club Database Project

    List of all customers. 5. The main menu should be displayed automatically when the program is loaded and the whole system should be menu driven 6. Mr. Pascal had some problems initially with data entry, confusing Items and customers, as this aspect works a little differently from the manual system.

  2. Tod's Tyres is a small business that supplies new car tyres to company car ...

    Number of new tyres fitted has also been validated which restricts users to enter a value greater than 5, if a greater value is entered, then an error message is produced. Company details table... Validation used for "companydetailstbl"... Other fields, which have been validated in the company details table, are

  1. Spare Parts Database Project

    The test data that will be added initially is shown in Appendix. Subsequent test will often involve adding new data, which will then be deleted when the test works satisfactorily. FUNCTIONAL TESTING Each menu item will be tested in turn to ensure that no function has been missed out.

  2. What is transaction processing?

    personal reference numbers etc in order to gain money, details or personal information etc. Another disadvantage is that we as a society have become more reliant of this form of transaction and if problems arise, such as mechanical failure we could be find ourselves unable to carry out transaction in

  1. Batch Processing

    How often batches of data are processed will depend upon the application (i.e. the job that is being done). Batch processing is usually only carried out on mainframe computers and when very large volumes of data have to be processed in a database.

  2. Purposes and Features of a Relational Database

    This means that business can keep track of certain aspects for example: Overdue payments, currently loaned books, and when membership expires. If any of these things were to happen, the database can automatically flag this up for the business. This means the business will get any money they are owed

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