Question 1
Why assign a data type to each field?
A data type controls which values are valid and how they are stored or displayed, such as dates, text or numbers.
What to learn
Explore the Base interface, create a database and design tables with suitable field types. Set a primary key, enter and edit records, sort data and save the table.
- Choose a field type that matches the data to be stored.
- Design View controls table structure; a wizard helps create a basic table.
- A primary key prevents duplicate record identity.
- Sorting changes display order without changing the meaning of the records.
Practical activity
Create a Student table with AdmissionNo, Name, Class and DateOfBirth. Set AdmissionNo as the primary key; enter sample records, edit one record and sort by name.
Use your school’s prescribed software version and teacher instructions. Keep personal information out of public practice files.
Solved CBSE-style questions
These questions and answers are original practice written for this guide; they are not copied from past papers.
Question 2
What is the purpose of a primary key?
It uniquely identifies each table record and prevents two records from sharing the same key value.
Question 3
Does sorting a table change its stored records?
Sorting changes their displayed order according to the selected field. It does not change the values in the records.
Revision checklist
- Can I explain the key terms without memorising a definition alone?
- Can I complete the listed practical task and describe each step?
- Can I apply the idea to a new example and explain why my answer works?
Aligned to the CBSE 2026–27 syllabus outline. Check the official subject curriculum and your school’s textbook/material for the prescribed scope.