Teach me with examples all the different sql commands I can use in Ms Access

Example: Create a table named `Students`.
$$
\boxed{\textbf{
CREATE TABLE Students (
    StudentID AUTOINCREMENT PRIMARY KEY,
    FirstName TEXT(50),
    LastName TEXT(50),
    DateOfBirth DATE,
    EnrollmentDate DATE
);
}}
$$

Example: Add a new column `Email` to the `Students` table.
$$
\boxed{\textbf{
ALTER TABLE Students
ADD COLUMN Email TEXT(100);
}}
$$

Example: Delete the `Students` table.
$$
\boxed{\textbf{
DROP TABLE Students;
}}
$$

Example: Insert a new student record into the `Students` table.
$$
\boxed{\textbf{
INSERT INTO Students (FirstName, LastName, DateOfBirth, EnrollmentDate, Email)
VALUES ('Alice', 'Smith', #2000-01-15#, #2018-09-01#, 'alice.smith@example.com');
}}
$$
*Note: Dates in MS Access SQL are enclosed in hash symbols (`#`).*

Example a: Select all columns from the `Students` table.
$$
\boxed{\textbf{
SELECT *
FROM Students;
}}
$$

Example b: Select `FirstName` and `LastName` for students enrolled after 2019.
$$
\boxed{\textbf{
SELECT FirstName, LastName
FROM Students
WHERE EnrollmentDate > #2019-01-01#;
}}
$$

Example c: Select all students, ordered by `LastName` alphabetically.
$$
\boxed{\textbf{
SELECT *
FROM Students
ORDER BY LastName ASC;
}}
$$

Example: Update Alice Smith's email address.
$$
\boxed{\textbf{
UPDATE Students
SET Email = 'alice.s@newmail.com'
WHERE FirstName = 'Alice' AND LastName = 'Smith';
}}
$$

Example: Delete the student named 'Alice Smith'.
$$
\boxed{\textbf{
DELETE FROM Students
WHERE FirstName = 'Alice' AND LastName = 'Smith';
}}
$$

Example: Assume you have a `Courses` table and a `StudentCourses` table linking students to courses.
$$
\boxed{\textbf{
SELECT Students.FirstName, Students.LastName, Courses.CourseName
FROM Students
INNER JOIN StudentCourses ON Students.StudentID = StudentCourses.StudentID
INNER JOIN Courses ON StudentCourses.CourseID = Courses.CourseID;
}}
$$

Example: Count the number of students enrolled each year.
$$
\boxed{\textbf{
SELECT YEAR(EnrollmentDate) AS EnrollmentYear, COUNT(StudentID) AS NumberOfStudents
FROM Students
GROUP BY YEAR(EnrollmentDate);
}}
$$