Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 94 - CoreGPT(Podar)_Flipbook_C8
P. 94

    Query: A query is the most powerful feature of database. It allows you to retrieve information
                         from a table based on some criteria or condition. By creating and running a query, you can
                         search, filter and extract data from the database efficiently.

                          Report: A report is a formatted presentation of data retrieved from a database, typically
                         generated  from  tables  or  queries.  Reports  are  used  to  summarise,  analyse  and  present
                         information in a clear and organised manner for decision-making or review.
                          Form: A form is a user-friendly interface in a database that enables users to enter, edit or
                         view data without directly accessing the underlying tables. Forms simplify data interaction
                         by providing a structured layout and controls for data input that makes it easier for users to

                         manage information.
                       Clickipedia

                        If more than one fields are combined to form a primary key, then it is called a composite key.

                            LIBREOFFICE BASE

                      LibreOffice  Base  is  a  powerful  and  easy  to  use  Relational  Database
                      Management System (RDBMS) that is a part of LibreOffice Suite. It provides
                      handy  tools  that  help  in  operating,  maintaining  and  manipulating  the
                      records more effectively.                                                            LibreOffice Base
                      It prevents the duplicity of data. It allows you to add, delete, modify and update the records in a

                      database by establishing a relationship between the tables.
                      Starting LibreOffice Base

                      To start LibreOffice Base, follow the below steps:
                      Step 1  Click  on  Dash  icon  → LibreOffice  Base.  The Database  Wizard  opens  with  the Select
                               database page.

                                                              Select database page

                     92     Premium Edition-VIII

| 89 90 91 92 93 94 95 96 97 98 99 |