Database Management system

What is Data

      In simple words data can be facts related to any object inconsideration.For example , your name ,age,height,weight,etc. 

    We already know what data is.But this data could be random.A database is systematic collection of data.Since the data in a database is organized it makes data management easy.

What is Database Management System

Database management system (DBMS) is a collection of Programs which enables its users to access database,manipulate data, and help in representation of data.

Type of DBMS

TABLE(DATABASE)

A table is a collection of related data held in a structured format within a database. It consists of columns, and rows.

In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.

Relation (database)

In relational database theory, a relation, as originally defined by E. F. Codd,^[1] is a set of tuples (d₁, d₂, ..., d_n), where each element d_j is a member of D_j, a data domain. Codd's original definition notwithstanding, and contrary to the usual definition in mathematics, there is no ordering to the elements of the tuples of a relation.^[2][3] Instead, each element is termed an attribute value. An attribute is a name paired with a domain (nowadays more commonly referred to as a type or data type). An attribute value is an attribute name paired with an element of that attribute's domain, and a tuple is a set of attribute values in which no two distinct elements have the same name. Thus, in some accounts, a tuple is described as a function, mapping names to values.

Row & Column (database)

In simple terms, a database table can be thought of as consisting of rows and columns.^[1] Each row in a table represents a set of related data, and every row in the table has the same structure

RECORD

 A record is composed of fields and contains all the data about one particular person, company, or item in a database. In thisdatabase, a record contains the data for one customer support incident report. Records appear as rows in the database table.

FIELD

data that has several parts, known as a record, can be divided into fields. Relational databases arrange data as sets ofdatabase records, also called rows. Each record consists of several fields; the fields of all records form the columns. Examples of fields: name, gender, hair colour.

REPORT

A database report is the formatted result ofdatabase queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

FORM

A form in Access is a database object that you can use to create a user interface for a databaseapplication. 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. ... This article focuses primarily on bound forms.

QUERY

A query is a request for data or information from adatabase table or combination of tables. This data may be generated as results returned by StructuredQuery Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools.

PRIMARY KEY

A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. A primary key's main features are: It must contain a unique value for each row of data. It cannot contain null values.

FOREIGN KEY

In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.

Microsoft Access

Jump to navigationJump to search

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational.Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.^[1]

Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating system operations.