Database

 What is a database?

A database is an organized collection of data stored and accessed electronically. 

Small databases can be stored on a file system while large databases are hosted on computer clusters or cloud storage.

Table in a database 

A table is a collection of related data held in a table format within a database. 

Data is logically organised in a row-and-column format similar to a spreadsheet.

Query in database

Query can either be a request for data results from the database or for action on data, or both. 

It gives an answer to a simple question, perform calculations, combine data from differents tables, add change, or delete data from database. 

There are two common types of database queries that are select queries (retrieves data and allows you to view it) and action queries (allows you to perform a task related to the data). 

Form in database

A form in access is a database object that you can use to create a user interface for a database application. 

A bound form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source. 

Field in database

In a database table, a field is a data structure for a single piece of data (The columns of the table are the fields). 

Fields are organized into records which contains all the information within the table relevant to a specific entity.

Softwares used for database

- Microsoft SQL Server Management Studio

- Improvado

- My SQL 

- Postgre SQL