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

    - How does the hotel do about when purchasing new equipment, hardware or software? - How many times does the IT department have to write reports for management? Monitoring Processes - What day-to-day checks are made to the IT department?

  1. ICT Report 2b: ICT in Organisations

    This flexible wire is used to transmit flashing light signals in the form of data which is astoundingly fast and accurate. These cables are used in Boots in the LAN lines (Local Area Network). As touched upon in report 2A, these run from each cash register or other component in

  2. GCSE Database Project ICT

    Multiple Table Search Criteria The secretary needs to do a cross table search to find people who have had a filling and search dates of 3-5 years ago who have had a gold filling the database file will be opened and a multiple search criteria will be started and a report is made with the relevant fields on.

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