FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Create a select query Select Create > Query Wizard . Select Simple Query, and then OK. Select the table that contains the field, add the Available Fields you want to Selected Fields, and select Next. Choose whether you want to open the query in Datasheet view or modify the query in Design view, and then select Finish.

Detailed explanation-2: -The query wizard allows you to create four types of queries to use in accessing and modifying the data in your database. The query wizard enables you to create the following types of queries: Initial Query. Specify Base Name and Location. Specify Data Model.

Detailed explanation-3: -A parameter query is one of the simplest and most useful queries you can create. Because parameter queries are so simple, they can be easily updated to reflect a new search term.

Detailed explanation-4: -Type UNION, and then press ENTER. Type SELECT, followed by a list of the fields from the second table you want in the query. You should include the same fields from this table that you included from the first table, and in the same order.