This chapter helps students understand how data is stored and managed in Microsoft Access. Students learn how to create tables, add fields and records, set primary keys, and use queries to find specific data easily.
These notes are written in simple and clear language according to the Punjab Board syllabus, making it easier for students to understand the concepts and prepare effectively for exams.
📥 Download Chapter 6 – Table and Query Notes
Skip to PDF contentYou can download the complete Class 12 Computer Science Chapter 6 – Table and Query Notes in PDF format from the link below:
📄 Download Complete Chapter 6 Notes (PDF)
📥 Click here to download Chapter 6 Table and Query Notes PDF
🧠 MCQs – Chapter 6 Table and Query
Q1: A table in MS Access consists of:
a) Rows and Columns ✅
b) Slides
c) Pages
d) Pictures
Q2: Each column in a table is called:
a) Record
b) Field ✅
c) Row
d) Cell
Q3: Each row in a table is called:
a) Field
b) Record ✅
c) Column
d) Cell
Q4: The field that uniquely identifies each record is called:
a) Data Field
b) Primary Key ✅
c) Query
d) Table
Q5: A query is used to:
a) Store data
b) Retrieve specific data ✅
c) Delete database
d) Print screen
Q6: Which query shows data from one or more tables?
a) Select Query ✅
b) Delete Query
c) Update Query
d) Append Query
Q7: The symbol used for wildcard in queries is:
a) #
b) * ✅
c) &
d) %
Q8: Criteria in a query is used to:
a) Add data
b) Filter data ✅
c) Delete table
d) Save file
Q9: Which object is used to store data in MS Access?
a) Query
b) Table ✅
c) Form
d) Report
❓FAQs – Table and Query
Q1: What is a table in MS Access?
A table in MS Access is a database object used to store data in rows and columns. Each row represents a record, and each column represents a field.
Q2: What is a query in MS Access?
A query is used to retrieve specific data from one or more tables based on given criteria.
Q3: What is a primary key?
A primary key is a field that uniquely identifies each record in a table.
Q4: Why are queries important?
Queries help users quickly find specific information from large amounts of data.
Q5: What is the difference between a record and a field?
A record is a row of data, while a field is a column in a table.