• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  • Level: GCSE
  • Subject: ICT
  • Word count: 1401

In this section I will display the work I have done and the outputs produced by the system. This section is basically evidence to my work as I intend to prove my work that I had planned in the Design section.

Extracts from this document...


In this section I will display the work I have done and the outputs produced by the system. This section is basically evidence to my work as I intend to prove my work that I had planned in the DESIGN section. PROTECTION AT THE BEGINNING The first thing presented to the user when he opens the file is the password dialog box. I added this to protect the data from being accessed by the wrong people. The following screen dump shows the password dialog box: After entering the correct password the main switchboard opens up. MENUS (SWITCHBOARDS) As mentioned in DESIGN, I created a menu so that the user can easily access the various parts of the database. To make things simple and easy, I made the menus using the Switchboard Manager. This creates switchboards which work like navigational menus. The Switchboard Manager can be accessed by clicking Tools>Database Utilities>Switchboard Manager This is how the switchboard manager looks like with the switchboards in it: The switchboards are created by clicking the 'New' button and naming the switchboards in the dialog box that appears. To add objects to the switchboard I clicked edit and the following dialog box appeared: Here, I added the items by clicking 'New' and entering the data into the dialog box that appeared. ...read more.


The following screen dumps show the steps involved when creating a form: Here I choose the fields that I want to include in the form. Here I choose the layout of my form (Columnar). The next window asks which color scheme I want. I select the Industrial scheme as it looks casual yet seems formal. Here I choose the name of the form and also to open the form in design mode so I can modify the form's design. The following pages are displays of all the forms I have created: In the DESIGN section I mentioned that I would add some 'codes' to some fields. This was done using the CODEBUILDER. CODEBUILDER allows Microsoft Visual Basic coding to be integrated into the MS Access database. This is how I did it: QUERIES As mentioned before, I am creating queries so that data can be filtered. I had created the queries in wizard mode and then edited the criteria in design mode. These are the steps that were involved in wizard mode: In this window I can choose the fields that I wish to display in my query. The screen dump shows some fields beings inserted. Another window appears after clicking next. This window only appears if there is a field with numbers as the data type. ...read more.


Then the following dialog box appears: I choose 'Create a new document and then link the data to it'. In the company, if they have made a preset letter, they can choose the first option and choose the file that contains the letter. Then MS Word opens up and it prompts for the database password. Once this is entered Word asks for the table or query required. I choose the mail merge query and then a new toolbar (mail merge toolbar) appears. Then I typed out the standard letter and inserted the fields from the button. The following pages show examples of my mail merged letters: Now that I have shown basically my whole system, I will now summarize the test plan. TESTING Here I will show the error messages that have been displayed when the Validation Rules have been violated. I will go table-wise to make it easier to understand what's going on: Items All my tables have the validation rule 'Is Not Null'. Thus I have just displayed the error messages with the conditions below: NAME field is blank. PRESENT field is blank. SELL PRICE field is blank. SCODE not present in SUPPLIERS table. Suppliers SUPPLIER field is blank. TELEPHONE field is blank. Purchase FNAME field is blank. LNAME field is blank. NAME1 field is blank. SUPPLIER1 field is blank. Repairs FNAME field is blank. LNAME field is blank. NAME field is blank. SUPPLIER field is blank. PROBLEM field is blank. TECHNICIAN field is left blank. COLLECT field is blank. ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    Paint is very good for designing as it has many different features that Microsoft Word 2007 does not have. For example it allows you to get a paintbrush and paint freely and it has a graffiti function. The problem with Paint though is that it is not very good at inputting text.

  2. Database Design Guideline

    This means that in my database I can only enter the colour red, blue, orange or green for the ward input so while filling my forms I will have to apply and stick with these rules as my database will not allow me to entry any other information apart from using does rules.

  1. Database design.

    After the original database creation, a new data category can be added without requiring that all existing applications be modified. Employee Employee Address Telephone Number Name Number 100001 Freely IP 23, Everglade Terrace 725181 100002 Grew TG 24, Everglade Terrace 725981 100003 Strap AJ 8, Bum Town 727389 Each of

  2. Database & design.

    2.4 Spell check a) Output ( On screen: Highlight incorrect or unknown names of videos. b) Information to be output ( Correct names of videos c) Data needed to produce the output ( A list of the films the video company has sent.

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

    Create Logo * When you have accessed Paint, you will find a huge range of tools on the top. * Select the tools that you think will be most beneficial for your logo. * If you click on the Brushes tool it enables you to draw with different kinds of brushes.

  2. IT Database Identify Section

    Silver membership costs �1.99 and achieves an immediate 10% discount with any items bought with that transaction and also on certain lines of products in the future. It also allows the member to get 1% of their transaction price back per purchase that is put on their card and they can later use the credit in the shop.

  1. I am going to be looking at Tesco. I will be focusing on what ...

    The product information stored in the database is also sent to the till PC, like the price, and any special offers saved in the database. This information can then be displayed on the LED (Light Emitting Diode) screen for the customer to view once each product has been scanned.

  2. Design Section

    Using Spreadsheets I can also use formulas. This will save me time as it is just like a calculator and is linked to different cells so if one cell changes the main cell will also change. Lists of inputs, outputs and processes Inputs Data Item Data Type Data Range Staff Name on Staff Login Page Text List

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