Access Database Programmer's Bundle: SQL & VBA

Focused View

IsáBel .

3:16:50

0 View

1 - Welcome to this 2 Course Programmers Bundle

1 -Welcome.mp4

00:48

2 -Downloading Resources.mp4

00:22

2 - ACCESS SQL SQL SELECT

1 -SQL+Clauses.pdf

1 -The SELECT Syntax.mp4

02:11

2 -SELECT Statements.mp4

10:32

3 -Aliasing Columns.mp4

03:55

4 -Lesson+Lab+-+Select.pdf

4 - Exercise Lesson Lab.html

4 - Section SQL - SELECT.html

3 - ACCESS SQL SQL WHERE

1 -The WHERE Syntax.mp4

01:22

2 -Understanding Filtering Operators LIKE, , and [ ].mp4

04:46

2 -wildcard+characters+.zip

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

04:24

4 -WHERE Part I.mp4

08:07

5 -WHERE Part II.mp4

07:27

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.mp4

01:08

2 -ORDER BY.mp4

07:40

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.mp4

01:48

2 -SUM.mp4

07:03

3 -AVERAGE.mp4

01:16

4 -COUNT.mp4

04:47

5 -MIN and MAX.mp4

03:41

6 -Lesson+Lab+-+Aggregate.pdf

6 - Exercise Lesson Lab.html

6 - Section SQL - Aggregate Functions.html

6 - SQL Date Functions

1 -Date.mp4

00:45

2 -Now.mp4

00:18

3 -Day.mp4

00:36

4 -MonthName.mp4

00:58

5 -DatePart.mp4

03:39

5 -date+part+.zip

6 -DateAdd.mp4

02:31

6 -date+add+.zip

7 -DateDiff.mp4

02:02

7 -date+diff+.zip

8 -DateValues.mp4

01:42

9 -Formatting Dates.mp4

02:58

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.mp4

01:52

2 -LCase and UCase.mp4

01:21

3 -Left and Right.mp4

01:44

4 -Mid.mp4

01:44

5 -Len.mp4

00:43

6 -Trim, LTrim, and RTrim.mp4

01:13

7 -Replace.mp4

03:54

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.mp4

01:55

2 -UPDATE.mp4

09:41

3 -The DELETE Syntax.mp4

02:22

4 -DELETE.mp4

05:03

5 -Lesson+Lab+-+Update.pdf

5 - Exercise Lesson Lab.html

5 - Section SQL - Updating and Deleting Records.html

9 - ACCESS SQL Subqueries

1 -Subqueries.mp4

07:49

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.mp4

03:42

2 -Common Types of Joins.mp4

05:12

3 -The JOIN Syntax.mp4

05:08

4 -JOIN.mp4

12:47

5 -Aliasing Tables in Joins.mp4

03:28

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.mp4

01:58

2 -CREATE TABLE I.mp4

03:23

2 -Data+types.pdf

2 - Data Types.html

3 -CREATE TABLE II.mp4

02:27

4 -The INSERT INTO Syntax.mp4

03:01

5 -INSERT INTO.mp4

02:02

6 -ALTER TABLE.mp4

03:05

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.mp4

08:55

2 -Using DISTINCT.mp4

02:13

3 -Using TOP.mp4

06:57

4 -UNION Queries.mp4

05:43

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.mp4

00:42

Description

Master SQL and VBA for Efficient Access Database Development

What You'll Learn?

WRITE SQL Queries in Your Microsoft Access Databases
CREATE Tables and Insert Records Using SQL
LEARN About Functions
- - - Files & SQL Script Included!
NAVIGATE Comfortably in the Visual Basic Editor
LEARN the Essentials of Writing Access VBA Code
PROGRAM Command Buttons
CREATE User Interactive Dialog Boxes, like message boxes and input boxes
DEBUG Your VBA Code
- - - Databases & VBA Included!

Who is this for?

The Beginning Access VBA Programmer

Those New to Access SQL

Anyone who is responsible for working with Access databases

Programmers of other languages that would like a good tutorial

What You Need to Know?

Access 2016 - 365

To get the most out of this course, you should have working knowledge of Microsoft Access databases

No programming experience needed, just a willingness to learn!

More details

Description
Welcome to the Access Database Programmer's Bundle: SQL & VBA, a bundled course combining Microsoft Access SQL: SQL for Non-Programmers and Access VBA: The Beginner's Blueprint to Programming Access.
This course is designed to elevate your database skills and empower you to create dynamic, efficient, and user-friendly databases.
Whether youâ€™re a beginner looking to learn the fundamentals or an experienced developer seeking to enhance your expertise, this comprehensive bundle has everything you need.

Who This Course Is For:
Aspiring database developers wanting to build a strong foundation in Access.
Business professionals looking to automate repetitive tasks and improve data management.
Anyone interested in enhancing their resume with in-demand SQL and VBA skills.

Interactive Learning: Enjoy a mix of video lectures, hands-on exercises, and quizzes that keep you engaged and reinforce your understanding.

Lifetime Access: Revisit the course materials at any time, allowing you to learn at your own pace and refresh your skills whenever needed.

Enroll Today!
Transform your approach to database programming and unlock new career opportunities with the Access Database Programmer's Bundle: SQL & VBA. Donâ€™t miss this chance to master essential skills that will set you apart in the job market.
Sign up now and start your journey toward becoming an Access database expert!
Who this course is for:
The Beginning Access VBA Programmer
Those New to Access SQL
Anyone who is responsible for working with Access databases
Programmers of other languages that would like a good tutorial

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

IsáBel .

Instructor's Courses

Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want?IsáBel Will Show You How.ABOUTSince 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel.Technical courses in everyday language are offered in her Udemy portfolio.IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.IsaBel grew up around teachers, so education was always important to her.All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.COURSES ON UDEMY.COMSQL: - Microsoft Access SQL: SQL for Non-Programmers - SQL Made Simple: SQL Server Queries for Non-ProgrammersMicrosoft Office:- Excel Pivot Tables: The Power of Pivot Tables... Made Easy- Excel: Time Saving Tips That Will Boost Your Productivity ✔- Excel VBA: The VBA Beginner's Blueprint to Programming Excel- Access: Time Saving Tips That Will Boost Your Productivity ✔- Access Macros: Automate Your Access Databases- Microsoft Access: Beyond the Basics of Access Bundle- Access VBA: The Beginner's Blueprint to Programming Access- Microsoft Word: Forms, Mail Merge, and Field Code Rules- Microsoft Word Time Saving Tips To Boost Your Productivity ✔- Microsoft Office: Word, Excel and Access Productivity BundleSharePoint:- SharePoint 2010: Survey Creation for SharePoint Admins- SharePoint 2013: Survey Creation for SharePoint AdminsRESOURCES:▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.