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

    easy to use & easy to understand form for customers to use to join the store I shall make sure that the form has all the relevant fields (name, post code, etc...) An accurate easy to read & understand, detailed form used by customers to join the store.

  1. GCSE Database Project ICT

    The receptionist and the Dentist can either have synchronised computers or have computers on a network. When the receptionist has to send reminder letters multiple criteria can be used to search and manipulate data. After she has found the results of the search she then can connect to Microsoft Word

  2. ICT Report 2b: ICT in Organisations

    with high-speed internet connections and an office software package to carry out primary/secondary research. To promote new products and offers, Boots must advertise through a variety of media, one being television, meaning video-editing software must be used such as Adobe Premiere.

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