Page 277 - Trackpad 402_Class-X_Final
P. 277

DATABASE OBJECTS

            A database is made up different objects some of them are given below:

            •  Table: Table is a collection of related data stored in the form of rows and columns. It contains information about one
              type of item.
            •  Query: Query is a set of commands that generates a request to access or manipulate data in a table. A query is of
              great help when information is required to be extracted from different tables. It uses the process of filtering the
              information based on the criteria from the table.
            •  Form: Form is a database object which is used to create an interactive user interface by connecting it with a table.
              Each field of a table is displayed in a text box with a Field label on one side so that the user can enter, edit and view

              records in an efficient way. The data added, deleted, updated through a form will be reflected in the table connected
              to the form.
            •  Report: Report is the formatted data displayed from one or more tables or queries. This layout of the information
              is based on a criteria. It is also known as the summary of a table and helps in data analysis. For example, creating a
              report of students who secured 80% and above.


                    INSERTING A NEW RECORD IN A TABLE
            After the structure of the table is created the data can be inserted by using the given steps:

            Step 1:  Select the STUDENT table created earlier.
            Step 2:  Double-click on table to open the Table Data View.
                    OR
                    Right-click on the table and click on Open option from the context menu.






























                      This view displays the table created with the field heading displayed and the cursor blinking to help you add
                    a record. If the records  are already added earlier then those records will also be displayed and you can add
                    more, modify or delete the existing records.






                                                                                   Database  Management System  277
   272   273   274   275   276   277   278   279   280   281   282