Searching and sorting a database

  1. In your own words, explain the difference between a search and a sort
  2. In your own words, explain how you would find the oldest member of a database using their date of birth.

Database forms

Learning Intentions

  • Understand the term database form
  • Understand how database forms can improve usability concerns regarding database applications

Success Criteria

  • I can build a database form

Forms

  • A form is a feature of Microsoft Access that allows the database user to add data more easily.
  • Forms consist of multiple elements that allow data to be easily viewed, modified and added.

Forms

  • Forms allow us to display information in a more presentable way that allows easy updating of the database

Forms

  • Users of the database can easily populate the database using a form like below
Build a form for your Top Trumps database.
Style it and move parts around as you see fit. 

Task

JB
Databases : 3.1 Database forms
© J Balfour
Tools