Page 86 - iPrime_V2.2_class7
P. 86

Query: A query is the most powerful object of a database. It helps you to retrieve information

                     from a table based on some criteria or conditions. You can find and retrieve data from the
                     database just by creating and running the query.
                      Report: A report is a database object that is specially designed to display or print the data in a
                     formatted way. It is the final result of the manipulated data that comes from tables or queries
                     in DBMS is known as a report.

                      Form: A form is a database object used to create a user interface to enter or update a record
                     in a table that is connected to it. It also allows us to view all the records from the table one by
                     one.
                   Clickipedia



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


                      ACCESS 2016

                  Access is a  powerful  and  easy-to-use  Relational Database Management
                  System (RDBMS) which is a part of Office Suite. It provides handy tools that
                  help in operating, maintaining and manipulating the records more effectively.

                  It prevents the duplication of data. It allows you to add, delete, modify and update
                  the records in a database by establishing a relationship between the tables.           Access 2016
                  To start Access 2016, click on the Start → Access 2016. This will open the Access window.


                      COMPONENTS OF ACCESS 2016
                  Access 2016 has the following components:

                      Quick Access Toolbar: It is a small bar at the top-left corner of the Access 2016 window. It
                     usually has buttons for Save, Undo, and Redo, and it can be customised to include additional
                     commands as needed.
                      Title Bar: It is the topmost bar of the Access window that displays the name of the currently

                     opened database.
                      Ribbon: In Access 2016, the long bar located just below the Title bar is known as the Ribbon.
                     It is organised into different tabs, such as File, Home, Create, and others. Each tab is further
                     divided into groups, which contain various commands and tools used in Access 2016.
                      Navigation Pane: This pane is present on the left side of the Access window. It displays the

                     names of the objects used in the database such as Table, Query, Form, etc. It allows users to
                     easily access and manage the objects.
                      Navigation Buttons: These buttons help in navigating through the records.

                      Work Area: It is the area where records are added to the various fields in a table.
                      Objects Tabs: The objects such as Tables, Queries, and Forms that we open in the database
                     are present in the form of tabs under the Ribbon.



                  84     Touchpad iPRIME (Ver. 2.2)–VII
   81   82   83   84   85   86   87   88   89   90   91