Page 89 - TP_iPlus_V2.1_Class7
P. 89

•  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.

                     Info Byte

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




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

                 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.
                 To start Access 2016, follow these steps:

                                    3  Click on the Access 2016 from the list.















                     1  Click on the
                     Start button.

                                       2  Type here Access 2016.



                  i +  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.



                                                                                                                  87
                                                                            Database and DBMS—An Introduction
   84   85   86   87   88   89   90   91   92   93   94