DATABASE FUNDAMENTALS
DATABASE QUERY
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Design View
|
|
Datasheet View
|
|
Simple Query Wizard
|
|
None of the above
|
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: -The Query Wizard is a tool that allows you to generate QueryPairs automatically from a pair of Connections. This is useful for Business Analysts, SMEs or other team members who have data and business-rule knowledge, but who are new to SQL.
Detailed explanation-4: -A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.