• 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. ICT Report 2b: ICT in Organisations

    However, they take up a lot more energy than standard monitors are not aiding the problem of our natural resources being exhausted - in fact, they are speeding up the date at which this happens. To conclude, Monitors are helpful to Boots because they can provide visual aid when managing

  2. GCSE Database Project ICT

    Data collection (Source data and identifiers, with details of input method, validation and key identifiers) Patient's data The patients Data will be retrieved from the hard-copy format of the patients records. The Secretary then manually adds them (or scans them in).

  1. Organising the database at Costsloadsless.

    be able to read it o The files won't get deleted like on a computer. o It is complicated you have to write down what customer has lent what DVD o It takes less time than getting the data programme on o It is inefficient Using a swipe card The

  2. System administration report

    the software package available to them and help them combat any technical faults they can come across. Investigation topics The following is a list of what will be covered in the report: Management procedures - How often are meetings held in the It department at the hotel?

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