Build SQL queries to interact with Access Databases
What you will learn
Fetch data with SQL
Remove duplicate data with SQL
Filter data with SQL
Sort data with SQL
Create a table with SQL
Insert data into tables
Update data in database
Delete data in database
Description
Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.
What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
- What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL is a standard language for accessing and manipulating databases.
- SQL can set permissions on tables, procedures, and views
- SQL is a Standard – BUT….
- Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.
However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.
Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
English
language
Content
Microsoft Access Database Setup
Introduction
What is SQL
What is Microsoft Access
How to get Microsoft Access
Database concepts
Install Sample Database
Querying Microsoft Access Database with SQL
Fetching data with SQL SELECT Statement
Removing duplicate data with SQL DISTINCT
Using SQL Aliases
Filtering data with SQL WHERE Clause
Filtering data with SQL AND Operator
Filtering data with SQL OR Operator
Filtering data with SQL AND | OR Operator
Filtering data with SQL IN Operator
Filtering data with SQL BETWEEN Operator
Sorting data with SQL ORDER BY Clause
Performing CRUD Operations
What is CRUD
Create a database and table with access
Create a table with SQL
Insert data into tables
Update data in database
Delete data in database