class 7 chapter 8
1. What is a Query and Types of Query in MS Access? Definition: A Query is used to retrieve specific data from one or more tables in a database. It helps to filter, sort, and analyze data easily. Types of Queries in MS Access: Select Query – Used to display data based on certain conditions. Action Query – Used to change data (Update, Delete, Append, or Make-Table). Parameter Query – Asks the user for input (like a search term) before showing results. Crosstab Query – Used to summarize and analyze data in table format. SQL Query – Used to write queries directly using SQL commands. 2. Steps to Create the First Query in MS Access Open MS Access and open your database. Click on the Create tab. Select Query Design. Choose the table(s) you want to use and click Add, then Close. In the design grid, add the fields you want to display. In the Criteria row, type the condition (e.g., >50 or "India" ). Click on the Run button (red exclamat...