• More Courses
  • MCQs
  • Blog Download
  • Tools
  • Contact

    DBMS (Database Management System) and MS Access

    Posted on 2021-03-06

    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 

    • Easy to add new data
    • Easy to modify the data
    • Delete existing data
    • Sorting and indexing of data
    • Easy queries in data
    • Retrieve the data easily
    • Print the formatted reports, labels, etc. 
    • Linking between two or more databases.

    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 

    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: 

    • It provides very useful database features such as database tables, forms, reports, data access pages and queries. 
    • It works as Front End Development tool. 
    • This provides an End-user applications developer environment.
    • It shares data with other applications such as Word, Excel, or Web pages. 
    • It incorporates three programming languages: SQL, macros, and Visual Basic (VB) 

    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. 

    Microsoft Access Video Tutorial Part 1 (Creating Table, Form and Report)

    Microsoft Access Video Tutorial Part 2 (Creating Query)