Page 87 - Trackpad_ipro 4.1_Class7
P. 87

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 a 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 2019

                 Access is a  powerful  and  easy-to-use  Relational Database Management
                 System (RDBMS) which is a part of the 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
                                                                                                            Access 2019
                 update the records in a database by establishing a relationship between the

                 tables.
                 To start Access 2019, click on the Start → Access 2019 → Blank database → Create. This will
                 open the Access window.

                     COMPONENTS OF ACCESS 2019

                 Access 2019 has the following components:
                                         Quick Access Toolbar      Title Bar





                                                                                                       Ribbon

                                                                                                       Objects Tabs

                    Navigation
                      Pane



                                                                                                       Work Area





                                           Status Bar                   Navigation Buttons

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


                                                                           Database and DBMS—An Introduction     85
   82   83   84   85   86   87   88   89   90   91   92