Class 12 Computer Science Chapter 5 Notes

• Describe MS Access? Describe Benefits of MS Access: Microsoft Access : Microsoft Access is one of the most popular and powerful DBMS. It has many built in features to assist you in constructing database and viewing information. MS Access is much more involved and is a more genuine DBMS than other programs such as Microsoft Works. Microsoft Access is a Relational Database Management System (RDBMS) that you can use to store and manipulate large amount of information. It is easy to understand and its graphical interface, helps to create queries, forms, and reports. In other words, even inexperienced programmers can use MS Access to turn a stack of invoices, a card file of customer names, a ledger, and an inventory list into a relational database that makes entering, updating, and reporting information as easy as clicking a button.
• Describe MS Access Database Components ? Answer : Microsoft Access Database Components : MS-Access database consists of various components called the objects. The database objects are used to store data and to retrieve data from database. The major database objects are : Tables : The most important object of a database is a Table. The data is stored in tables of database. A table is a collection of related data organized in rows and, columns. Each row consist a record, and each record consists of columns. The row is divided into columns called field containing different data values of a particular record. A relational database may contain multiple tables, which are identified by unique names. This is the fundamental property of a relational database.
• Queries : Query is a statement that extracts specific information from database. It is created by specifying the fields to display from a table or another query. It is more flexible way of selecting, filtering and sorting records. The user can also change data in the database that fulfils certain criteria. In addition, queries allow to perform calculations of different fields. The output of a query is also displayed in the form of a table and can also be used as source of records for Forms and Reports. The query allows you to view and analyze data in many different ways. Technically, a query is a stored question or request. You design a query in design view to extract certain information from the database. 
• Forms : The Form object of database is used to enter data into databases, edit data and view data from database. You can add, update, and delete records in your table by using a form. Form provide : An easy method for entering and editing data in tables. Thus the user does not have to work directly with tables. Facilities to display data retrieved from database tables. Most of the DBMSs provide the facility to create Forms. The application programmer creates the user interface by designing the Forms. In this way arid Reports, the users can perform different operations on the database very easily. Reports : The Report object of database is used to retrieve and present data in a formatted way. The Report can be printed. Some reports are simply a list of the records in the database, one record after the other.