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

