Class 12th Computer-Chapter 6 – Table and Query

Long Questions

Short Questions

MCQ’s

This chapter focuses on two fundamental components of Microsoft Access: Tables and Queries. Tables store data, while Queries allow users to retrieve and manipulate that data based on specific criteria.

Tables

1. Definition:
   • Tables are the primary objects in a database where data is stored. Each table consists of rows (records) and columns (fields).
2. Structure:
   • Fields: Each field represents a specific attribute of the data (e.g., name, age, address). Each field has a defined data type (e.g., text, number, date).
   • Records: Each record is a unique entry in the table, containing data related to a single entity.
3. Creating a Table:
   • Users can create a table in Design View or Datasheet View.
   • In Design View, define fields, their data types, and set a primary key to uniquely identify records.
4. Data Types:
   • Common data types include:
     • Text: For alphanumeric data.
     • Number: For numeric data.
     • Date/Time: For date and time values.
     • Yes/No: For Boolean values.

Queries

1. Definition:
   • Queries are used to retrieve and manipulate data stored in tables. They allow users to filter, sort, and analyze data according to specific criteria.
2. Types of Queries:
   • Select Query: Retrieves data from one or more tables based on specified conditions.
   • Action Query: Performs actions on the data, such as adding, updating, or deleting records.
   • Parameter Query: Prompts the user for input before running the query.
3. Creating a Query:
   • Users can create a query using the Query Design view, where they can drag and drop fields from tables.
   • Set criteria to filter the results (e.g., showing only records where age is greater than 18).
4. Sorting and Filtering:
   • Queries allow users to sort results in ascending or descending order based on specified fields.
   • Users can apply filters to narrow down results, making it easier to find relevant information.
5. Using SQL:
   • For advanced users, queries can be created using SQL (Structured Query Language), providing greater control and flexibility over data retrieval.

Conclusion

Understanding Tables and Queries in Microsoft Access is crucial for effective data management. Tables provide a structured way to store data, while Queries enable users to retrieve and manipulate that data efficiently. Mastering these concepts enhances users’ ability to work with databases and analyze information effectively.