Computer : Ch : 2 Open office Base (Notes)
Ch : 2 Open office Base Notes : Database : is a collection of pieces of information that can be accessed or managed in a systematic manner. Every column represents a field, and every row represents a record in the table. Records: Every row in a database table that contains complete information about a particular person or thing is called a record Fields: A record consists of a set of individual pieces of information. Each piece of information in a record is called a field. Database Management System (DBMS) Advantages of a DBMS 1. Efficient data sharing: 2. Data security 3. Better data integration 4. Reduced data inconsistency 5. Increased productivity of end-user Tables are used to store data in a database. Queries allow you to display only selected data from tables based on certain conditions. Š Forms allow you to enter and view data stored in tables. Š Reports allow you to print a summary of data based on a table
