• 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
  29. 29
    29
  • Level: GCSE
  • Subject: ICT
  • Word count: 464

Database Report

Extracts from this document...

Introduction

In this report I will show how I created my own database so you can also create your own database following these simple steps that I will guide you through. How to set a Drop down list: How to set the primary key: How to set the Input Masks: How to set the Data Validation: Relationship: I have completed my tables now I need to make a relationship between them, we use relationships to link tables. This is done so that the details in the table can easily link up. ...read more.

Middle

I linked the other two tables by the "Loan ID" this was also a one to many relationship because each loan in the "Loans Available" table can have only contain one "Loan ID" while the "Lending Details" table can have several; this is because many people may open the same type of loan which contains its ID number. Forms: Queries and Reports: Simple Queries: Finding the customer with the "Account number" 1: Finding the customers with an Occupation: Finding the customers which are male: Finding the customer with a surname called (Khan): Finding the customer with the "Loans Id" 1: Finding the customer with the "Lending Id" 5: Complex Queries: ...read more.

Conclusion

and have entered the information you are looking for, to run the query you have to click an icon that looks similar to an explanation mark which is located on the top toolbar. Switchboard A database Switchboard is a unique type of Form that can be used to navigate around the various inputs or output documents generated by the database. How to create a switchboard The purpose of my switchboard is to make life easy for the employees or the receptionist that input new information like adding new customers, this switchboard will allow them to enter the new information without any hassle at all. ?? ?? ?? ?? Database Report ...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. System administration report

    Administrative procedures: How consumables and other equipments is purchased or organised and how they are kept, and the general work of the system administrator. Backup procedures: What data is backed up, and how and when, is at regular intervals or the end of every working day.

  2. GCSE Database Project ICT

    Data can be edited by word of mouth where the patient is informing the secretary that there is a change of address she could tell the secretary the new address. When the receptionist inputs the data, she visually checks the record for any spelling errors (such as a misspelt road name)

  1. Organising the database at Costsloadsless.

    Writing the system on paper This system would be on paper in a folder this would hold all information from DVD/ video information to the customer information. The video/ DVD information would all be set up in the front of the folder all organised from love DVD's to action set

  2. ICT Report 2b: ICT in Organisations

    I will proceed to discuss how Boots Plc employ ICT in their Sales department. The sales department is responsible for selling and marketing the goods or services that a company produces (in this case, Boots doesn't produce all the products it sells, though they do have own-brand products).

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