• 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
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  • Level: GCSE
  • Subject: ICT
  • Word count: 2112

Access Database

Extracts from this document...

Introduction

Identify Problem: Create a computerised relational database using Microsoft Access for a library close by because the library has too many papers and lose many of them, so they want a database that solves all their problems. Users: The Librarian will be going to use the database, and the assistance will also use it, the assistance might not be an expert so the assistance must take classes on how to use the database because it has to be used carefully. I will also make it user friendly Objectives: * Must have more than one table (entity) to create relationships * Each table has a primary key to uniquely identify each record * Each table is linked through primary/foreign keys * The database will be 'normalised' so each table has its 'appropriate' data * Create Forms to gather data/reduce mistakes * Create Queries to search for data * Create Reports to show the output from your queries * Make database user friendly so it can be used * To show the stock of the videos in the library * Age group of videos Alternative solutions: I could have used a flat file database or Microsoft Excel but I used a Computerised relational database because if I use flat file database there will be lots of paper, too much space will be used unnecessarily and too much to carry. ...read more.

Middle

to create relationships The tables should have relationships + must work They worked as I expected them to 2. Each table has a primary key to uniquely identify each record The table has a primary key, the main one The tables didn't work because it had no primary key 3. Each table is linked through primary/foreign keys The tables should be linked through primary keys They worked as I expected them to 4. The database will be 'normalised' so each table has its 'appropriate' data The tables should have its appropriate fields according to their table They all had the appropriate fields 5. Create Forms to gather data/reduce mistakes When I open the forms they should work and look like the ones as I designed them to be They did work but did not like the ones I designed 6. Create Queries to search for data When I open the queries they should work and look like the ones as I designed them to be They worked as I expected 7. Create Reports to show the output from your queries When I open the reports they should work and look like the ones as I designed them to be They did work but did not like the ones I designed 8. ...read more.

Conclusion

For the forms I have kept a simple colour combination. In the forms, in the fields the background colour is yellow and the handwriting colour is blue because yellow and blue go well with each other, the colours are also bright and easy to read. For filling in the data, in those blocks the background colour will be red and the handwriting colour will be black because red and black are a good colour combination and will be easy to read. I have kept the handwriting size fairly big so it is easy for the customer and librarian to read or fill in. I have decided to use the font Arial because it is very clear and big. Also for the field names I have decided to keep them bold because they are very important. My reports are also very user friendly and attractive. User feedback From the user feedback I have decided to keep my hand drawn plans as my final designs because of the feedback I got. They have said everything in my hand drawn plans is good. They also said it is very user friendly, clear and the colour combination used goes very well together. However, one person said to add buttons and maybe an image. So I decided to add a video cover image and buttons to all my hand drawn plans. Labelled test output Evidence of Improvement ...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. ICT PROJECT

    It is hidden to prevent access to the sheet and this reduces the chances of the data being by mistake changed. Form Range The user has six form, 11C, 11A, 11S, 11R, 11E and 11D. This is stored a range named Form.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    As we can see below I have use a validation rule so not other data can be enter onto the system . RATING TABLE * RATING On this table I also have only one field, which is rating , being the only one and like in all the other tables

  1. Computer project Alevels

    * CREATING A NEW FORM: * Adding a Form - There are two ways in which you can add a form that by Design view or using Wizard. If using design view then click on "create form in Design view" and the start creating the form.

  2. IT investigative process

    Next it is important to define your room's "walkable areas" in other words the areas where your character is allowed to walk. This can be achieved by clicking on the "areas" option just under the "settings" option on the left hand pane.

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    And this technology fulfil Sainsbury's purposes and now there are Kroger self checkout are in Sainsbury, Kroger self checkout is also same self checkout, but in self-checkout Sainsbury's staff scan the foods/goods, tools for us, in Kroger self checkout we do it with own ourselves, and now most of the customers use Kroger self-checkout, and me as well.

  2. GCSE Database Project ICT

    After each appointment, a label can be stuck on each record on a 4-month basis to tell the secretary to send a letter to inform the patient he/she has an outstanding appointment renewal. Two alternate software solutions considered There are two computerised options within Microsoft both are within the Microsoft Office 2007 Suite.

  1. ICT Project 1A

    These include. Instant Karma, Break Away and On the Edge. I got the names of the new songs from Youtube and my Tokio Hotel albums. (non-it sources!) I put all of these prices on my website on the Music page so that viewers could buy the CD's.

  2. Computer study project outline - library and book club database.

    Testing all the algorithms and debugging- 10 days. 9. Designing the software- 10 days. 10. Documentation and report making- around 18 days. Hardware used I am using a variety of different hardware for this project: 1. Laptop: I am using an HP Pavilion dv3 Series laptop.

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