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

    MEMBERS TABLE This table includes the following fields: * MEMBER_ID * TITLE * F_NAME * M_NAME * L_NAME * ADDRESS * COUNTY * POST_CODE * CONTACT_# * DATE_JOINING * EXPIRED_DATE To the right we can see a copy of the table on design view, most of field use the same

  1. Computer project Alevels

    * A screen shown below will appear asking you what you want to do with the CD. * Click on "Open folder to view files using Windows Explorer" which is highlighted in the above diagram. * Under the drive, the CD is in, you will see a folder named "MediCare Hospital System".

  2. IT investigative process

    To create a room is very simple, once you have an image of the room (it can be either a photo or a picture you created yourself on the computer), export it to a directory in the same resolution you decided to create your game with.

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

    outer surfaces except at the/or each corner where the outer surface is polished ant at regions where light is to e transmitted into or out of the light pipe. This arrangement allows the barcode image to be conveyed from the light inlet to the image detector along a bent path

  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

    I used the 'advance search' tool. I found only 291,000 webpage's and in most of these it was simply stating that he was in the band and that he played the bass guitar. I used this information to further narrow down my search by adding the instrument he played into the search engine.

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

    I don?t need to attach an external keyboard, because this one works just fine. 4. Mouse: I have attached a wireless optical epro mouse to the computer. I prefer using this mouse to the touchpad, because the touchpad of the laptop can be inaccurate and tough to use.

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