Posts

Showing posts from October, 2022

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