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

    No Video_Category The Category Thriller,horrer,Romantic Text 20 Yes Video_Cert The certificate U,12A,PG,15,18 Text 20 Yes Video_Rental_Price The Price to rent out per night Currency �00.00 No Video_Date_Out The date rented Date __/__/__ No Video_Date_Returned The date returned Date __/__/__ No Video_Copies The number of copies.

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

    * I found the instructions quite easy to use besides the fact that he wanted screenshots/images. * The instructions were in bullet points so that I could follow them step by step. Negative * I wanted screenshots/images in the user guide. * Some of the parts were a bit complicated.

  1. Travel Agent Database - Effects of New System The new system will affect ...

    Customers will not need to worry if they forget anything, for example, ID number. All the details of a customer are stored in a database. 3. By introducing ICT the travel agent will have access to the internet. Via internet they will be able to advertise their business.

  2. Features of a sports club database. The system has at least 1 table and ...

    The fields of the record, they are linked (related) to the fields in the 'Form View' layout, reduces duplication 6. Clicking on the name of the player would take you to the that player's record using the script 'Navigation - Go Related record' 7.

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

    voice conversation Digital Camera Used to take images John can take pictures on his camera, and send it to his computer USB Used to store folders, programs and files. John can backup his work on to the USB and ensures that he has more than one copy of his work

  2. GCSE Database Project ICT

    Of Birth Date Other Details Text Searches The searches needed for this will be the search for patients who have not booked within the designated time so a query will be needed to enable the search I will need to search upon the appointments table, under the appointment date and

  1. I suppose that without the help from the above technologies and other technologies, Mr ...

    A disadvantage of this device is that it is an ideal item that is of interest to many muggers in the world today putting you in danger due to being in possession of this device. Personal Digital Assistant - Personal Use Mr Potts is always on the move, around the city and very often he travels abroad for job purposes.

  2. Design Section

    * Mention any automated functions which will be needed - Microsoft Excel would allow me to make the Time & Date automated by typing in a formula then formatting the cells. * State what will make a good solution - Microsoft Excel will allow me to complete the solution to

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