MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 1: Overview
Having a Brief SQL Flavor
SQL
for MS Access differ from SQL for Oracle very minutely. All companies
having RDBMS database as product has to fulfill the basic RDBMS
commands. SQL is composed of bunch of commands rather complete English
words and I sometimes say to my students that anyone knowing just
English can imagine the outcome of SQL commands e.g.
SELECT ename, salary
FROM emp;
Here ename and salary are the column names (a.k.a. field names) of emp
table. This is one of the basic forms of SELECT statement in SQL. SELECT
statements are used to retrieve the information from the database. If
you want to limit the number of records you can write in the following
manner.
SELECT ename, salary
FROM emp
WHERE salary < 30000;
Using the WHERE clause can help in filtering records or in other words
limiting the number of records in the output of a query. There is one
more very interesting clause in the SELECT statement that is the ORDER
BY clause. Using this clause you can have the data arranged in order
e.g. alphabetically ascending or descending etc.
SELECT ename, salary
FROM emp
WHERE salary < 30000
ORDER BY ename;
If you want the order to be descending then just write DESC at the end
of the statement as shown below.
SELECT ename, salary
FROM emp
WHERE salary < 30000
ORDER BY ename DESC;
Other DML Statements:
UPDATE statement is used to edit the information already existing in the
table. If you want to insert a new record in the table then we user the
INSERT statement and if you want to delete any record or more than one
record we use the DELETE statement.
Example:
UPDATE emp
SET comm = NULL
WHERE job = 'TRAINEE';
Example:
INSERT INTO dept
VALUES (50, 'PRODUCTION', 'SAN FRANCISCO');
Another version,
INSERT INTO emp (empno, ename, job, sal, comm, deptno)
VALUES (7890, 'JINKS', 'CLERK', 1.2E3, NULL, 40);
Example:
DELETE FROM emp
WHERE JOB = 'SALESMAN' AND COMM < 100;
Chapter 1: Overview
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: