COMPUTER FUNDAMENTALS

Detailed explanation-1: -Data Manipulation Language (DML) Commands: DML commands are used to manipulate data stored in a database. Data Definition Language (DDL) Commands: DDL commands define a database schema or structure. Data Control Language (DCL) Commands: DCL commands control access to the database. More items

Detailed explanation-2: -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-3: -They are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries. Select Queries Select query is the simplest and the most common type of query. It retrieves data from one or more tables depending on what is needed and displays the result in a datasheet.