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

    Combo box Costumer_ID Unique number Number 6 Primary No Customer_First_Name Customers first name. Text 20 >C<????????? No Customer_Surname Customers surname Text 10 >C<????????? No Customer_Street Street they live at. Text 10 >C<??????????????? No Customer_Town Town they live in Text 10 Yes Customer_Post_Code Customers post code Text 8 No Customer_Phone_No Phone

  2. Camelot Restaurant Bookings System - computer system design

    The cells B12, B13, etc are bookings in the table and this formula takes how many people there are for the booking if the booking is between 12:00 and 12:59. The other cells in this data capture table all have slightly different formula because they check cells they check changing,

  1. Creating a computer system.

    When they click the OK button, the product details are copied into the invoice. User > The user will need to enter there customer details or customer ID into the customers form > Entering purchase details (for example choosing the product name and quantity)

  2. Create an IT system for my karate club.

    In a table there always has to be a key field (in this table it is memberID), the key field cannot be simply someone's name as someone else can have the same name and so the field will therefore not be unique.

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

    * Additionally, you can rename the name of your table and by that name it will be saved. * Furthermore, you click on Subscription Start/End. * Finally, you click on Input Mask and type in (00/00/0000;0;). Using input mask (post code etc.) * First, you should go on Microsoft Access.

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

    Storing documents in folders. The method of storing documents in folders is reasonably organised and quite systematic. Thousands of folders will have to be purchased to store thousands of documents. Using folders will take less space than using filing cabinets.

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

    This layout has validation on some of the fields to prevent the user entering invalid data.(A4) This layout has 3 different types of data: Number, Text and Container A1 - Creating a new record and new data being entered A2 & A3 - Amending the data and deleting the

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

    4GB DDR2 memory 4GB of memory or "RAM" (random access memory). The amount will determine the performance of the computer. John needs this if he wishes to have a high performance computer. Keyboard Used to input letters/words into the computer.

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