• 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

    - What is the hotel misuse act? - What guidelines are set out for the use of VDU's? Proposed headings for the report Management procedures: The usage of ICT for budgeting and structure of the organisation. Monitoring processes: The regular checks that are carried out by the system administrator as well making sure the network is working smoothly.

  2. Organising the database at Costsloadsless.

    o It's more professional and convenient. o you could lose the file in another unknown folder o The computer saves all the work and it is easy to update and change data o The staffs need training to use the database. Specification User Requirements Desired Out come Testing method Expected results Application form I want an

  1. GCSE Database Project ICT

    and create a mail merge where a template can be used to send multiple letters whilst the links are put in the receptionist can also create a report on his/her computer enabling them to know crucial information as whether they have paid or not, or made their yearly appointment.

  2. ICT Report 2b: ICT in Organisations

    stock control and sales would be nearly impossible to carry out without employing double the number of workers usually needed thus drastically increasing costs. In their sales department, they need EPOS systems to instantly catalogue the number of products on shelves as they're being sold; in marketing, they need computers

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