Kips IT Class 10 Chapter 11 Solutions Creating and Using Tables Part-B

Tables: Tables are the building blocks of a database. They store data items in the form of rows and columns. As you know, all the rows are referred to as records or tuples, and all the columns are known as fields or attributes. For example, in the Employee table, the data of related fields of the employees, such as Emp_Code, Name, Department, Salary, etc., is called a record and specific property of that employee, such as Salary, is known as field.
Queries: As the name suggests, queries are used to ask questions from the tables of a database, which stores a vast amount of data. Queries help to retrieve the filtered data from the database tables, based upon some conditions. They are also used to insert, delete, and update the data in the database depending upon the criteria specified by the user.
Forms: Forms are the user-friendly interfaces that facilitate the process of inserting, editing, deleting, and updating the data in tables and queries. It accepts the data from the user and stores it in the corresponding table or query. Using a form, you can add and update one record at a time.
Reports: Reports are used to display the selected data in a printable format. Reports collect the summarised data from one or more tables/queries and organise it in a printable form.

Data type determines what type of data you can enter into a field. For example, a field whose data type is ‘Number” can only store numeric data and does not allow you to enter text data into it.

Text is stored in form of character or string, or in combination of text and number. This type of data is not used to perform calculation.
Text [VARCHAR]: It is a variable length field type to store character or string values.

In Table Data view you can enter and navigate the records. Where in Table Design you can create a Table by defining the field name and field types.

The Table Design view allows you to edit the structure of created tables.