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 or a query.

 

Data types	Description
Text (fix)	Used for fields that contain text or a combination of text and numbers having a fixed number of characters. For example, product code
Text (Default)	Used for fields having text or a combination of text and numbers, that do not require calculations. For example, phone numbers, addresses, etc.
Number	Used for a field with numeric data that may be used for mathematical calculations. It can contain decimal values. For example, product price
Date/Time	Used for a field that needs to store date or time values such as date of birth, date of joining, etc.
Yes/No	Used for a field that can contain only one out of two values such as Yes or No, True or False.

Queries :

Open Office allows you to create queries in three ways: Š

·        Use a wizard to create a query Š

·        Create a query in the design view Š

·        Create a query in the SQL view

 

Forms:  Tables are used to store data. You can enter data into tables using the Data view.

A simple form consists of all fields of a table.

Complex forms can contain selected fields, graphics, selection boxes, drop-down lists and many other elements to make data entry easier and interactive.

Open Office allows you to create forms in two ways: Š

Use a wizard to create forms Š

Create forms in the design view

 

Reports:

 Reports are used to summaries or present the information stored in a database in a useful way. They are similar to queries except that they are usually in the printed form.

 

Reports can be of two types:

1. Static reports: Static reports contain the data in selected fields and they are prepared only once from the underlying data. They do not change.

2. Dynamic reports: Dynamic reports can be updated to show the latest data or updated data