Scribd
Upload
24 views9 pages

SQL Commands

Uploaded by

Idmilao, Maria Isabelle, M.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
24 views9 pages

SQL Commands

Uploaded by

Idmilao, Maria Isabelle, M.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

ACCESS SQL

(STRUCTURED QUERY
LANGUAGE)
BY: ELICIYO [Link]
ICT Teacher
LEARNING OBJECTIVES:
1. Explain the importance of Access SQL in a database.
2. Identify and use some common Access SQL Commands in creating and managing a database.
3. Appreciate the significance of using Access SQL to manage a database efficiently.
WHAT IS ACCESS SQL
(STRUCTURED QUERY
LANGUAGE)?

Access SQL is, fundamentally, a programming language designed for


accessing, modifying and extracting information from relational
databases.
As a programming language, SQL has commands and a syntax for issuing
those commands.
WHAT ARE ACCESS SQL
COMMANDS?

Access SQL commands are the instructions used to


communicate with a database to perform tasks,
functions, and queries with data.
LIST OF ACCESS SQL COMMANDS
SQL DESCRIPTION SYNTAX
COMMANDS
CREATE Create a new Table CREATE TABLE table_name (
TABLE column1 datatype,
column2 datatype,
column3 datatype,
....
);
INSERT INTO Insert new data into a INSERT INTO table_name
Table VALUES (value1, value2, value3, ...);

SELECT Extract data from a SELECT column1, column2, ...


database. FROM table_name;
AND HAVE A NICE
DAY

You might also like