Access Database Programmer’s Bundle: SQL & VBA

سرفصل های دوره

Master SQL and VBA for Efficient Access Database Development

1 - Welcome to this 2 Course Programmers Bundle

1 -Welcome

2 -Downloading Resources

2 - ACCESS SQL SQL SELECT

1 -SQL+Clauses.pdf

1 -The SELECT Syntax

2 -SELECT Statements

3 -Aliasing Columns

4 -Lesson+Lab+-+Select.pdf

4 - Exercise Lesson Lab.html

4 - Section SQL - SELECT.html

3 - ACCESS SQL SQL WHERE

1 -The WHERE Syntax

2 -Understanding Filtering Operators LIKE, , and [ ]

2 -wildcard+characters+.zip

3 -Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL

4 -WHERE Part I

5 -WHERE Part II

6 -Lesson+Lab+-+Where.pdf

6 - Exercise Lesson Lab.html

6 - Section SQL - WHERE.html

4 - ACCESS SQL SQL ORDER BY

1 -The ORDER BY Syntax

2 -ORDER BY

3 -Lesson+Lab+-+Order+By.pdf

3 - Exercise Lesson Lab.html

3 - Section SQL - ORDER BY.html

5 - ACCESS SQL Introduction to Aggregate Functions in SQL

1 -Intro to Aggregate Functions

2 -SUM

3 -AVERAGE

4 -COUNT

5 -MIN and MAX

6 -Lesson+Lab+-+Aggregate.pdf

6 - Exercise Lesson Lab.html

6 - Section SQL - Aggregate Functions.html

6 - SQL Date Functions

1 -Date

2 -Now

3 -Day

4 -MonthName

5 -DatePart

5 -date+part+.zip

6 -DateAdd

6 -date+add+.zip

7 -DateDiff

7 -date+diff+.zip

8 -DateValues

9 -Formatting Dates

9 -Formatting+Dates.pdf

10 -Lesson+Lab+-+Date.pdf

10 - Exercise Lesson Lab.html

10 - Section SQL - Date Functions.html

7 - ACCESS SQL String Functions

1 -Using CONCATENATE

2 -LCase and UCase

3 -Left and Right

4 -Mid

5 -Len

6 -Trim, LTrim, and RTrim

7 -Replace

8 -Lesson+Lab+-+String.pdf

8 - Exercise Lesson Lab.html

8 - Section SQL - String Functions.html

8 - ACCESS SQL Updating and Deleting Records Using SQL

1 -The UPDATE Syntax

2 -UPDATE

3 -The DELETE Syntax

4 -DELETE

5 -Lesson+Lab+-+Update.pdf

5 - Exercise Lesson Lab.html

5 - Section SQL - Updating and Deleting Records.html

9 - ACCESS SQL Subqueries

1 -Subqueries

2 -Lesson+Lab+-+Subqueries.pdf

2 -Using+EXISTS+with+Subqueries.pdf

2 - Exercise Lesson Lab.html

2 - Section SQL - Subqueries.html

2 - Using EXISTS with Subqueries.html

10 - ACCESS SQL Joining Tables Using SQL

1 -Primary Key and Foreign Key

2 -Common Types of Joins

3 -The JOIN Syntax

4 -JOIN

5 -Aliasing Tables in Joins

5 -Joining+3+or+More+Tables.pdf

5 - More Examples of Three Table Joins.html

6 -Lesson+Lab+-+Joins.pdf

6 -SQL+Subqueries+v+Joins.pdf

6 - Exercise Lesson Lab.html

6 - Section SQL - Joins.html

6 - Subqueries vs. Joins.html

11 - ACCESS SQL Tables

1 -The CREATE TABLE Syntax

2 -CREATE TABLE I

2 -Data+types.pdf

2 - Data Types.html

3 -CREATE TABLE II

4 -The INSERT INTO Syntax

5 -INSERT INTO

6 -ALTER TABLE

7 -Lesson+Lab+-+Tables.pdf

7 - Exercise Lesson Lab.html

7 - Section SQL - Tables.html

12 - ACCESS SQL Other SQL Clauses & Functions

1 -Using TRANSFORM and PIVOT to Create Crosstabs

2 -Using DISTINCT

3 -Using TOP

4 -UNION Queries

5 -The+Format+Function.pdf

5 - Formatting Numbers.html

5 - Section SQL - Other Clauses & Functions.html

13 - ACCESS SQL Test Your SQL Skills

1 -TEST+YOUR+SKILLS.pdf

1 -TEST+YOUR+SKILL+ANSWERS.pdf

1 - Test Your Skills Answers.html

1 - Test Your Skills Questions.html

14 - From SQL to VBA

1 -Get Ready to Transition to VBA

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy