• 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. Smarts Leisure Park Database Booking System

    DFD 6 In DFD 6 the receptionist gathers information for the Cancellations query to see which bookings are live. The receptionist then produces a report and gives it to the manager for internal use. Examining my DFD's I know I will need four tables: * Customer Details * Activity Details * Booking Details * Instructor Information Entity Relationship Diagram (ERD)

  1. Creating a computer system.

    > There will be a macro to print, save and clear the invoice, update the stock table and to add the invoice details to the database. When they click on the main menu button the main menu will appear, so the user can view another sheet.

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

    * Then, you should go on Blank Database. * After that, you should click on Create. * Furthermore, you should click on Query Design. Then a window should appear titled (Show Table). Just click Add then close the window. * Then Double click all the fields you want for your query and make sure that the box has been ticked.

  1. I am investigating into Price

    As my data is recorded in Microsoft Excel then I managed to do the calculations quicker. Here are my findings: Petrol mean = �10 970.17 Diesel mean = �10 188.17 Median: In order to work out the median I have to put all my data in order from the lowest price to highest price.

  2. GCSE Database Project ICT

    Data Flow Diagrams showing data sources, processes and destinations Add/Edit Data The User wants to add, edit and manage data to be able to put into the database file. Access will be opened and the database file will be opened.

  1. Creating a travel planning ICT system

    given before and after (this information could be presented in queries or reports). Many people will need to access this record or receive information about the trip so I should be able to send out pieces to teachers e.g. form, lesson etc about which dates will be missed.

  2. Creating a computer system for a mobile phone shop.

    Using computers is much more professional, and shows to Orange that I am taking their request seriously. Specification In order for my solution (the database) to be successful it will have to be able to do a number of things...

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