Database tools

Databases store data, but you also need to be able to search and filter the data to find and present results.

Some of the tools you use when working with databases include:

Forms

Forms are used to enter data into a database. This is only required if the database needs a user to enter data. The form should make it clear what data should be inputted, eg if you are selling something, you would fill in a form which prompts you for information like product name, brand and size.

Some databases are filled with data without direct user interaction, eg records of sensor readings from a weather station.

Queries

Queries are used to search and filter a database. For example, when shopping online you select the options that you need and run a search. You can also filter and sort results, eg you may want the cheapest item first, or the item with the least time left at auction. All these actions are searching, sorting and filtering – and they are all queries.

Reports

Reports are used to export data and present it in a way that is easy to read. For example, your address book database is full of details such as addresses, emails, dates of birth, but you might want to run a report to present just names and phone numbers.

Modules

Database software and languages contain modules - pre-written programs. However, when making a database you might think of actions you want to do that do not have a specific module. In this case, you can edit modules in the programming language and your own procedures.

Move on to Test
next