Udemy Access Database Programmers Bundle SQL and VBA

2.3 GB | 10min 32s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 -Welcome.mp4 (5.58 MB)
2 -Downloading Resources.mp4 (2.69 MB)
1 -Primary Key and Foreign Key.mp4 (30.86 MB)
2 -Common Types of Joins.mp4 (34.81 MB)
3 -The JOIN Syntax.mp4 (11.48 MB)
4 -JOIN.mp4 (64.46 MB)
5 -Aliasing Tables in Joins.mp4 (14.48 MB)
1 -The CREATE TABLE Syntax.mp4 (4.66 MB)
2 -CREATE TABLE I.mp4 (22.87 MB)
3 -CREATE TABLE II.mp4 (12.34 MB)
4 -The INSERT INTO Syntax.mp4 (6.19 MB)
5 -INSERT INTO.mp4 (11.57 MB)
6 -ALTER TABLE.mp4 (15.12 MB)
1 -Using TRANSFORM and PIVOT to Create Crosstabs.mp4 (66.46 MB)
2 -Using DISTINCT.mp4 (16.07 MB)
3 -Using TOP.mp4 (36.03 MB)
4 -UNION Queries.mp4 (49.55 MB)
1 -Get Ready to Transition to VBA.mp4 (4.92 MB)
1 -Creating Macros vs Programming in VBA.mp4 (8.53 MB)
2 -Example of an Access Macro.mp4 (31.79 MB)
2 -MacroExample.zip (100.33 KB)
3 -Converting Macros to VBA.mp4 (34.04 MB)
1 -Accessing the Visual Basic Editor.mp4 (12.24 MB)
2 -VBA Windows & Toolbars.mp4 (39.55 MB)
3 -Naming Modules.mp4 (9.82 MB)
4 -Adding and Removing Modules.mp4 (9.67 MB)
5 -A Few Time Savers When Writing VBA.mp4 (7.14 MB)
6 -What to do When You Have Error in Your Code.mp4 (12.35 MB)
1 -Object Oriented Programming.mp4 (8.73 MB)
2 -How VBA Accesses an Object's Properties and Methods.mp4 (4.36 MB)
3 -Working with Procedures.mp4 (7.39 MB)
4 -Structure of Sub Procedures.mp4 (6.85 MB)
5 -Structure of Functions.mp4 (10.53 MB)
6 -Calling a Sub Procedure or Function.mp4 (7.99 MB)
7 -Event Procedures.mp4 (12.49 MB)
8 -Comments.mp4 (35.37 MB)
1 -GettingToKnow.zip (146.57 KB)
1 -Introduction.mp4 (2.4 MB)
10 -Controlling Access of Your Variables & Procedures with Scope.mp4 (70.02 MB)
11 -Arrays.mp4 (28.75 MB)
12 -Getting+to+Know+Section.zip (32.68 KB)
12 -Test Your Skills.mp4 (5.58 MB)
2 -Variable Declaration.mp4 (12.9 MB)
3 -The Importance of Data Types.mp4 (8.27 MB)
4 -About Me.mp4 (6.19 MB)
5 -Declaring Constants.mp4 (11.45 MB)
6 -Object Variables.mp4 (12.16 MB)
7 -Exercise Arithmetic Operators.mp4 (27.32 MB)
8 -Text Box Values.mp4 (8.96 MB)
9 -Carriage Return-Line Feed.mp4 (8.68 MB)
1 -Functions.zip (90.57 KB)
1 -Introduction to Functions.mp4 (721 KB)
10 -FormattingValues.zip (19.34 KB)
10 -The Format Function Using Named Format Expressions.mp4 (6.28 MB)
11 -Using the FormatCurrency Function.mp4 (13.7 MB)
12 -Format+Section.zip (40.81 KB)
12 -Test Your Skills.mp4 (6.49 MB)
2 -String Functions Left, Right, and Mid.mp4 (18.96 MB)
3 -String Functions UCase, and LCase.mp4 (2.3 MB)
4 -String Functions InStr.mp4 (11.07 MB)
5 -Date and Time Functions Date, and Now.mp4 (3.57 MB)
6 -Date and Time Functions Day, Month, and Year.mp4 (4.81 MB)
7 -Date and Time Functions DateDiff.mp4 (7.98 MB)
8 -Date and Time Functions Time.mp4 (1.59 MB)
9 -Date and Time Functions Second, Minute, and Hour.mp4 (3.63 MB)
1 -The SELECT Syntax.mp4 (5.7 MB)
2 -SELECT Statements.mp4 (70.44 MB)
3 -Aliasing Columns.mp4 (20.16 MB)
1 -Overview of Object Events.mp4 (1.42 MB)
2 -Click Events.mp4 (1.71 MB)
3 -Focus Events.mp4 (3.29 MB)
4 -Mouse Events.mp4 (2.11 MB)
5 -Keyboard Events.mp4 (3.27 MB)
6 -Text box Events.mp4 (4.17 MB)
7 -Combo box Events.mp4 (4.29 MB)
8 -Events+Section.zip (33.7 KB)
8 -Test Your Skills.mp4 (4.19 MB)
1 -DoCmdExamples.zip (154.94 KB)
1 -Introductions to DoCmd.mp4 (3.36 MB)
10 -DoCmd SendObject.mp4 (22.31 MB)
11 -DoCmd TransferDatabase.mp4 (20.94 MB)
12 -DoCmd TransferSpreadsheet.mp4 (21.09 MB)
2 -DoCmd ApplyFilter.mp4 (41.87 MB)
3 -DoCmd CopyObject.mp4 (36.04 MB)
4 -DoCmd OpenForm.mp4 (26.62 MB)
5 -DoCmd OpenReport.mp4 (23.87 MB)
6 -DoCmd OpenTable.mp4 (1.39 MB)
7 -DoCmd OutputTo.mp4 (23.82 MB)
8 -DoCmd RunCommand.mp4 (17.91 MB)
9 -DoCmd RunSQL.mp4 (26.09 MB)
1 -Decisions.zip (142.05 KB)
1 -The IF THEN Statement.mp4 (27.54 MB)
2 -The Select Case Statement.mp4 (27.56 MB)
3 -Decision+Section.zip (52.19 KB)
3 -Test Your Skills.mp4 (5.55 MB)
4 -Decision+Section2.zip (43.99 KB)
4 -Test Your Skills II.mp4 (6.31 MB)
1 -Message Boxes.mp4 (30.25 MB)
1 -User+Interaction.zip (67.35 KB)
2 -Input Boxes.mp4 (14.49 MB)
3 -Exercise Input Boxes & Message Boxes.mp4 (14.38 MB)
1 -Introduction to Loops.mp4 (3.79 MB)
1 -Loops.zip (158.06 KB)
2 -For Next Loop Introduction.mp4 (3.8 MB)
3 -For Next Loop.mp4 (26.02 MB)
4 -For Each Next Loop Introduction.mp4 (2.01 MB)
5 -For Each Loop.mp4 (9.37 MB)
6 -Do While Loop Introduction.mp4 (2.27 MB)
7 -Do While Loop.mp4 (39.27 MB)
8 -Do Until Loop Introduction.mp4 (2.38 MB)
1 -Opening and Closing a Recordset.mp4 (23.18 MB)
1 -RecordsetDatabase.zip (138.97 KB)
2 -Adding New Records.mp4 (21.12 MB)
3 -Editing a Record.mp4 (17.81 MB)
4 -Deleting a Record.mp4 (9.04 MB)
5 -Counting Records.mp4 (13.64 MB)
1 -Introduction to Debugging and Error Handling.mp4 (1.07 MB)
2 -Debugging Setting a Breakpoint & Stepping Through Code.mp4 (39.48 MB)
2 -DebuggingExamples.zip (26.06 KB)
3 -Debugging The Watch Window.mp4 (20.56 MB)
4 -Debugging The Locals Window.mp4 (15 MB)
5 -Debugging The Immediate Window.mp4 (27.58 MB)
6 -Error Handling The On Error Resume Next Statement.mp4 (9.97 MB)
7 -Error Handling The Err Object.mp4 (10.36 MB)
1 -The WHERE Syntax.mp4 (3.74 MB)
2 -Understanding Filtering Operators LIKE, , and [ ].mp4 (21.46 MB)
3 -Understanding NOT, !, BETWEEN AND, IN, NULL, NOT NULL.mp4 (17.75 MB)
4 -WHERE Part I.mp4 (51.22 MB)
5 -WHERE Part II.mp4 (40.07 MB)
1 -The ORDER BY Syntax.mp4 (3.51 MB)
2 -ORDER BY.mp4 (45.43 MB)
1 -Intro to Aggregate Functions.mp4 (13.48 MB)
2 -SUM.mp4 (44.83 MB)
3 -AVERAGE.mp4 (5.29 MB)
4 -COUNT.mp4 (26.77 MB)
5 -MIN and MAX.mp4 (19.04 MB)
1 -Date.mp4 (3.24 MB)
2 -Now.mp4 (1.52 MB)
3 -Day.mp4 (3.22 MB)
4 -MonthName.mp4 (4.52 MB)
5 -DatePart.mp4 (15.12 MB)
6 -DateAdd.mp4 (11.24 MB)
7 -DateDiff.mp4 (7.67 MB)
8 -DateValues.mp4 (8.22 MB)
9 -Formatting Dates.mp4 (17.05 MB)
1 -Using CONCATENATE.mp4 (8.21 MB)
2 -LCase and UCase.mp4 (6.48 MB)
3 -Left and Right.mp4 (7.2 MB)
4 -Mid.mp4 (7.98 MB)
5 -Len.mp4 (3.07 MB)
6 -Trim, LTrim, and RTrim.mp4 (5.13 MB)
7 -Replace.mp4 (16.68 MB)
1 -The UPDATE Syntax.mp4 (4.46 MB)
2 -UPDATE.mp4 (63.8 MB)
3 -The DELETE Syntax.mp4 (4.33 MB)
4 -DELETE.mp4 (35.9 MB)
1 -Subqueries.mp4 (42.49 MB)]
Screenshot