What is Database?
The database is an organized collection of data in an easily accessible form that is shared and used for multiple purposes as desired. A database system gives us a way of gathering together specific pieces of relevant information. It also provides a way to store and maintain that information in a central place.
DBMS (Database Management System)
The Database Management System (DBMS) is the element that allows the data to be organized so that it can be easily accessed by application programs. The DBMS manages the logical organization of data, and the data storage system manages the physical organization of data.
Features of DBMS
Some Features of DBMS are
Data: Data is the information to the data computer which are processed to get desired results. These are the pieces of information.
File: A file is a collection f information on various items.
Record: A record is an information about an element such as a person, animal, student, employee, client, etc. A record can have much information under separate headings called fields. A record contains information about an element.
Field: A field is a piece of information about animals, people, clients, employees, etc. This is the unit of the title of the data record. The fields are the titles in the table of MS-Access.
Microsoft Access is a desktop database management system where we can create and maintain related data. It is a relational database management system (RDBMS). In a multiuser environment, it uses a file-sharing mechanism. It collects data and information in the form of tables. Microsoft Access is the premier database management system on desktop computers these days.
Features of MS Access
The major features of MS-Access are:
Objects of MS-Access Database
Table: A table is primary building block of MS-Access database system. All the data are stored in table form. We can open a table in Datasheet View to enter data or we can create a data entry form for the table.
Form: Forms present the data from a table or a query in a way we want it to be displayed. The fields in the table or query are made available to a place on the forms we create.
Queries: A query is a search or question that we make for a record or item. The record is stored in the database file. Queries help to investigate data records.
Report: Reports are the printed results of data processing.
Pages: The Data Access page is the user interface for the database. They are used in viewing and entering data from a website or the Internet.
Macros / Modules: Macros are small programs used to automate repetitive tasks. A module stores programmed codes written in the Access database.