Pass query in design mode in Access 2007

[Chandranath]

How to pass a query in design mode in Microsoft Access. I have a attendance table. Now I want to generate a query which an assign some automated task and give out the proper result. The query which I tried gave out an error. What are the steps to pass a query in normal and design mode.

[Raine]

The basic types of queries in access are as follows. Queries are the objects in a database that can retrieve data from a table, modify and even save the result in another table. There many types of them. The most I used is Action queries. This query is used for making changes to records. There are several types of action queries, removal, update, append data and creating tables.

[Eric B]

These are the queries that extract data or show us. They show that data from a table that meet the specified criteria. Once the result we see the data to modify (this can be done or not as the query). A select query generates a logical table (called logical because it is not physically on the hard disk but in memory of the computer and every time you open recalculated).

[Glenny]

One of the most useful query used for SQL is SQL-specific queries. They are queries that can not be defined from the Access QBE grid but have to be defined directly in SQL. This query needs a advance knowledge of SQL. So even if you just go through the basic to generate a query that is enough for your.

[JonathanD]

To create a query, follow these steps. Open the database where the query to create. Click the Layout button in the Create tab Search. The you have the option of using the Query Wizard, if you click the Query Wizard button displays the following dialog box. The Simple Query Wizard make a simple select query as defined in the preceding paragraph.

[Macarenas]

You can also generate query in a Design mode. This lets you to generate a automated query. Entering the Query Design view first asked us tables which consultation will draw the data with a dialog box like this. Select the table from which we get information and clicking on the Add button. If we are to add data from multiple tables in the same way the other tables. Finally click on the Close button.