• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3679

Planning my tables and the complete database for the new system.

Extracts from this document...

Introduction

In this section I will be planning my tables and the complete database for the new system. This will include my designs for queries, forms, sub-forms, linked-forms, relationships and macros. Once I have finished this I will be using a test plan to make sure that my system will work the way that I expect it to work. This test plan will ensure that my system is accurate and has accomplished many of the goals. TABLES I will create the tables in DESIGN mode as this will allow my to make more customised changes. In DESIGN mode I can enter the field name, the data type and any extra comments, which would not be possible in the WIZARD mode. Also, I can add validation rules and input masks in the field properties section. These are the tables I plan to create: ITEMS This table will hold the details of the item and its stock information. This is the record structure of this table: FIELD NAME DATA TYPE EXAMPLE ICODE NUMBER 10304 NAME TEXT WEGA T40 SCODE NUMBER 3100 SUPPLIER TEXT Sony ITEM TYPE TEXT TV PIC OLE Object (a picture file) PRESENT NUMBER 310 MIN LEVEL NUMBER 200 MAX LEVEL NUMBER 330 STATUS TEXT OK COST PRICE NUMBER Dhs. 500 SELL PRICE NUMBER Dhs. 725 To increase the level of integrity of the data entered, I will be using some simple validation rules to accompany the table. If any of these rules are violated, then an error message is displayed. The error message displays what is entered in VALIDATION TEXT. These are the validation rules and validation texts that I have inserted: FIELD NAME VALIDATION RULE VALIDATION TEXT NAME Is Not Null Please enter the item name PRESENT Is Not Null Enter present level MIN Is Not Null Enter minimum level MAX Is Not Null Enter maximum level SELL PRICE Is Not Null Enter selling price Sometimes data is required in a certain format. ...read more.

Middle

[Enter date] COLLECT, ID, LNAME, NAME, ITEMTYPE, TECHNICIAN, COST REP TECH N SUB TECHNICIAN = [Enter tech's name], SUBMIT = [Enter submission date] ID, LNAME, ICODE, NAME, SUPPLIER, ITEMTYPE, TECHNICIAN, SUBMIT REPANDY TECHNICIAN = "Andy" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPARVINDA TECHNICIAN = "Arvinda" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPBARRY TECHNICIAN = "Barry" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST REPICODE ICODE = [Enter ICODE] ID, FNAME, LNAME, ICODE, NAME, SCODE, SUPPLIER, TECHNICIAN, COST REPJOSE TECHNICIAN = "Jose" ID, LNAME, ICODE, SCODE, ITEMTYPE, TECHNICIAN, COLLECT, COST RESTOCK STATUS = "Restock" ICODE, NAME, SCODE, SUPPLIER, PRESENT, SELL PRICE, STATUS FORMS Forms are also important in my system. This will make the system more user friendly as I can customise the fields to be in different positions. This enables me to group specific fields together so that the database is easier to understand. The next few sheets will display my designs of my forms. I will create the forms using the WIZARD. Here I will choose the required fields, the type of view (columnar), the colour scheme and name of the form. After I make the form in the wizard I will tamper around with the design of the form in design mode. My forms will be in the COLUMNAR format as it looks more professional and user friendly. These are the designs of my forms: In the MAX field, I will insert the following code in the CODE BUILDER: Private Sub MAX_LostFocus() 'also MAX_onChange() and MAX_AfterUpdate() 01 Dim maxz 02 Dim minz 03 Dim pres 04 Dim subtr 05 Dim subtr2 06 Dim perc 07 maxz = MAX.Value 08 minz = MIN.Value 09 pres = PRESENT. Value 10 subtr = pres - minz 11 subtr2 = maxz - minz 12 perc = Int((subtr / subtr2) * 100) 13 If (perc <= 2) Then 14 MsgBox "WARNING! STOCK VERY LOW!!!" ...read more.

Conclusion

684 5841 ACCEPTED 40 TELEPHONE SUPPLIERS - REJECTED : Enter telephone number USER FEEDBACK Now my design plans are complete. Before I began my practical work, I decided to have the manager evaluate my progress, so that I would not make a mistake and regret it later. A few days later I went to the manager and asked his opinion after showing him all the designs that I proposed for the system. The manager said it was "well done" but one important thing was missing - the mail merge feature. Also, the manager wanted me to change the structure of the PURCHASE form so that it would look like a receipt with details. So then I started working on the problems. To send letters to the suppliers I need information from both the SUPPLIERS table and the ITEM PROPERTIES TABLE. At first I thought of making a table but after some time it struck me that I could create a query that would link the two tables together. So now I plan to create the query in the following way: QUERY NAME: MAILMERGE CRITERIA: (none) FIELDS SELECTED: ICODE, NAME, ITEM TYPE, MAX, STATUS, SUPPLIER (ITEMS table), SCODE, ADDRESS, STATE, COUNTRY, P/ZCODE, SUPPLIER (SUPPLIERS table). Then this will be my format for my standard letter: To: The manager, <<POBOX>> Dear Sir, Elektronikz has reached its stocking date and is now currently restocking all goods from various countries. In order to replenish our stock levels, we require the normal level (<<MAX>>) of <<NAME>> which is supplied by your company, hopefully reached to us latest by the 7th of April 2003. Please ensure that the goods delivered are in good condition and payment will be made on the 10th of April personally by the manager. Thank you, Mr. Nathan Fernandes, GENERAL MANAGER OF ELEKTRONIX Now that the mail merge has been handled, I will create the new design of the PURCHASE form. The following is my new planning, and as shown, it looks like a receipt: Now that my designs have completely been prepared, I will start implementing the new system. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Database design.

    After completing the last window this window will appear which asks you to give your report a name as you can see I have named mine rprtReport. Your report will look like this when you have finished and as in the form you can change the design by click the design view key.

  2. Benefits of using my IT system in the Travel Agents.

    After that I will click on header and footer and I am going to add the details I want. The letterhead was created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes.

  1. a level ict project

    query switchboard Customer sort query opens in design view Design view of customer query appears T33 Verify the open amount charged query macro runs appropriately Amount charged query opens in design view Design view of the query appears T34 Verify the open commission calculator query macro works correctly Commission calculator

  2. I am investigating into Price

    This is very easy to do in Microsoft Excel. I simply had to highlight my prices and click a symbol like this: A Z After I had sorted them using this, I looked at number 35 which is the middle value and this

  1. Creating a computer system.

    > The company name and address. > A text box for customer details (name, address, telephone number). > A box at the top right hand side of the page, with the invoice number, date and customer ID. > There will also need to click on buttons related to font sizes, styles and colour themes.

  2. The aim for this coursework is to design a new system for an estate ...

    He wishes to place a suitable solution to help him to organise his work alphabetically therefore he is able to use the filing cabinet to put the files and papers, and very important documents inside it to keep everything secure and tidy.

  1. Designing an IT system for an A level Student.

    It is the 'brain' of the computer and is one of the smallest components of a computer, yet is the most important component for a computer to work This is able to suit all of John's computer needs. John will not be able to do work without this crucial hardware component 160GB SATA hard drive (7200rpm)

  2. Design Section

    as Macro's, List boxed, combo boxes, Option buttons, Sliders, Scroll bars, Indexes, Check boxes, and Pivot tables. * List user requirements - Microsoft will allow me to meet the user requirements because I can use Comment boxes + Input and output message and error alerts.

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