|
|
1 - Course Overview and Content English.vtt
|
VTT
|
10.8 KB
|
|
|
1 - Course Overview and Content.mp4
|
MP4
|
26.1 MB
|
|
|
10 - Subdatasheets English.vtt
|
VTT
|
12.6 KB
|
|
|
10 - Subdatasheets.mp4
|
MP4
|
31.9 MB
|
|
|
11 - Exercise 01 English.vtt
|
VTT
|
1.3 KB
|
|
|
11 - Exercise 01.mp4
|
MP4
|
2.1 MB
|
|
|
12 - Linking Two Tables to Other Access Databases English.vtt
|
VTT
|
17.6 KB
|
|
|
12 - Linking Two Tables to Other Access Databases.mp4
|
MP4
|
35 MB
|
|
|
13 - Acquiring and Installing SQL Server Express English.vtt
|
VTT
|
16.6 KB
|
|
|
13 - Acquiring and Installing SQL Server Express.mp4
|
MP4
|
41.8 MB
|
|
|
14 - Setting up SQL Server Database English.vtt
|
VTT
|
16.5 KB
|
|
|
14 - Setting up SQL Server Database.mp4
|
MP4
|
37 MB
|
|
|
15 - Exercise 2 English.vtt
|
VTT
|
1.3 KB
|
|
|
15 - Exercise 2.mp4
|
MP4
|
2.5 MB
|
|
|
16 - Splitting an Access Database into Frontend and Backend Databases English.vtt
|
VTT
|
14.8 KB
|
|
|
16 - Splitting an Access Database into Frontend and Backend Databases.mp4
|
MP4
|
26.3 MB
|
|
|
17 - Converting Shared Table into Local Table Moving Backend Database English.vtt
|
VTT
|
16 KB
|
|
|
17 - Converting Shared Table into Local Table Moving Backend Database.mp4
|
MP4
|
30.2 MB
|
|
|
18 - Exercise 3 English.vtt
|
VTT
|
2 KB
|
|
|
18 - Exercise 3.mp4
|
MP4
|
6.4 MB
|
|
|
19 - Addressing Multiusers Issues When Sharing Data English.vtt
|
VTT
|
18.2 KB
|
|
|
19 - Addressing Multiusers Issues When Sharing Data.mp4
|
MP4
|
32.6 MB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience English.vtt
|
VTT
|
1.8 KB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
37.9 MB
|
|
|
20 - Basics of Macros English.vtt
|
VTT
|
15.6 KB
|
|
|
20 - Basics of Macros.mp4
|
MP4
|
27.7 MB
|
|
|
21 - Macros on Events AutoExec English.vtt
|
VTT
|
15.4 KB
|
|
|
21 - Macros on Events AutoExec.mp4
|
MP4
|
35.7 MB
|
|
|
22 - More About AutoExec Bypassing AutoExec English.vtt
|
VTT
|
18.5 KB
|
|
|
22 - More About AutoExec Bypassing AutoExec.mp4
|
MP4
|
41 MB
|
|
|
23 - Macro Security Settings English.vtt
|
VTT
|
10.3 KB
|
|
|
23 - Macro Security Settings.mp4
|
MP4
|
18.9 MB
|
|
|
24 - Exercise 4 English.vtt
|
VTT
|
6.7 KB
|
|
|
24 - Exercise 4.mp4
|
MP4
|
11.7 MB
|
|
|
25 - Customizing the Ribbon and Quick Access Tool English.vtt
|
VTT
|
16.1 KB
|
|
|
25 - Customizing the Ribbon and Quick Access Tool.mp4
|
MP4
|
30 MB
|
|
|
26 - Convert Macros to VBA VBA Editor and Property Windows English.vtt
|
VTT
|
16 KB
|
|
|
26 - Convert Macros to VBA VBA Editor and Property Windows.mp4
|
MP4
|
27.7 MB
|
|
|
27 - VBA Modules Running Code and Error Handling English.vtt
|
VTT
|
19.1 KB
|
|
|
27 - VBA Modules Running Code and Error Handling.mp4
|
MP4
|
33.5 MB
|
|
|
28 - Creating Modules Subs Functions Intellisense and Variables English.vtt
|
VTT
|
17.1 KB
|
|
|
28 - Creating Modules Subs Functions Intellisense and Variables.mp4
|
MP4
|
27.5 MB
|
|
|
29 - Scope Variable Naming and Strings English.vtt
|
VTT
|
16.4 KB
|
|
|
29 - Scope Variable Naming and Strings.mp4
|
MP4
|
31.1 MB
|
|
|
3 - DOWNLOAD ME Course Exercise Files.html
|
HTML
|
1 KB
|
|
|
30 - Standard Functions Logical Case and Loop Statements English.vtt
|
VTT
|
17.3 KB
|
|
|
30 - Standard Functions Logical Case and Loop Statements.mp4
|
MP4
|
32.7 MB
|
|
|
31 - Adding Events to Assets Database English.vtt
|
VTT
|
16.2 KB
|
|
|
31 - Adding Events to Assets Database.mp4
|
MP4
|
37.7 MB
|
|
|
32 - Exercise 05 English.vtt
|
VTT
|
2.6 KB
|
|
|
32 - Exercise 05.mp4
|
MP4
|
5.4 MB
|
|
|
33 - Common Events Form and Report Events English.vtt
|
VTT
|
18 KB
|
|
|
33 - Common Events Form and Report Events.mp4
|
MP4
|
37.1 MB
|
|
|
34 - Switchboard and Navigation Form Error Handling English.vtt
|
VTT
|
18.6 KB
|
|
|
34 - Switchboard and Navigation Form Error Handling.mp4
|
MP4
|
36.5 MB
|
|
|
35 - Exercise 06 English.vtt
|
VTT
|
12.4 KB
|
|
|
35 - Exercise 06.mp4
|
MP4
|
26.5 MB
|
|
|
36 - Formatting Bound and Control Form English.vtt
|
VTT
|
16.6 KB
|
|
|
36 - Formatting Bound and Control Form.mp4
|
MP4
|
43 MB
|
|
|
37 - Split Forms Macro Error Handling English.vtt
|
VTT
|
17.3 KB
|
|
|
37 - Split Forms Macro Error Handling.mp4
|
MP4
|
35.6 MB
|
|
|
38 - Creating Form with Tab English.vtt
|
VTT
|
14.4 KB
|
|
|
38 - Creating Form with Tab.mp4
|
MP4
|
29.6 MB
|
|
|
39 - Go To Combo Box and Its Properties English.vtt
|
VTT
|
14.2 KB
|
|
|
39 - Go To Combo Box and Its Properties.mp4
|
MP4
|
34.4 MB
|
|
|
4 - DOWNLOAD ME Course Demo Files.html
|
HTML
|
1 KB
|
|
|
40 - Exercise 07 English.vtt
|
VTT
|
9.6 KB
|
|
|
40 - Exercise 07.mp4
|
MP4
|
15.5 MB
|
|
|
41 - Basic of Queries Review English.vtt
|
VTT
|
15.4 KB
|
|
|
41 - Basic of Queries Review.mp4
|
MP4
|
31.6 MB
|
|
|
42 - Syntax of SQL Statements English.vtt
|
VTT
|
14.3 KB
|
|
|
42 - Syntax of SQL Statements.mp4
|
MP4
|
39.1 MB
|
|
|
43 - Use of Multiple Where Criteria Select Statements Function English.vtt
|
VTT
|
11.3 KB
|
|
|
43 - Use of Multiple Where Criteria Select Statements Function.mp4
|
MP4
|
29.6 MB
|
|
|
44 - Joins and Its Types English.vtt
|
VTT
|
14.2 KB
|
|
|
44 - Joins and Its Types.mp4
|
MP4
|
35.9 MB
|
|
|
45 - Exercise 08 English.vtt
|
VTT
|
819.2 B
|
|
|
45 - Exercise 08.mp4
|
MP4
|
2.3 MB
|
|
|
46 - Action Queries Part 1 English.vtt
|
VTT
|
17 KB
|
|
|
46 - Action Queries Part 1.mp4
|
MP4
|
40.6 MB
|
|
|
47 - Action Queries Part 2 English.vtt
|
VTT
|
12 KB
|
|
|
47 - Action Queries Part 2.mp4
|
MP4
|
31.4 MB
|
|
|
48 - Subqueries English.vtt
|
VTT
|
4.3 KB
|
|
|
48 - Subqueries.mp4
|
MP4
|
13.6 MB
|
|
|
49 - Steps in Packaging Access Application English.vtt
|
VTT
|
17.2 KB
|
|
|
49 - Steps in Packaging Access Application.mp4
|
MP4
|
36.6 MB
|
|
|
5 - Primary Keys and Indexing Rules and Guidelines English.vtt
|
VTT
|
13.7 KB
|
|
|
5 - Primary Keys and Indexing Rules and Guidelines.mp4
|
MP4
|
28.2 MB
|
|
|
50 - Exercise 09 English.vtt
|
VTT
|
1.7 KB
|
|
|
50 - Exercise 09.mp4
|
MP4
|
2.2 MB
|
|
|
51 - Online Support and Conclusion English.vtt
|
VTT
|
5.6 KB
|
|
|
51 - Online Support and Conclusion.mp4
|
MP4
|
13.9 MB
|
|
|
52 - Access-Shortcuts.pdf
|
PDF
|
2.7 MB
|
|
|
52 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html
|
HTML
|
0 B
|
|
|
6 - More About Indexes English.vtt
|
VTT
|
9.9 KB
|
|
|
6 - More About Indexes.mp4
|
MP4
|
22.2 MB
|
|
|
7 - Settingup Northwind Database English.vtt
|
VTT
|
5.5 KB
|
|
|
7 - Settingup Northwind Database.mp4
|
MP4
|
10 MB
|
|
|
8 - Working in a Datasheet View English.vtt
|
VTT
|
16 KB
|
|
|
8 - Working in a Datasheet View.mp4
|
MP4
|
51.7 MB
|
|
|
9 - Customizing Datasheet View and Advanced Sorting and Filtering English.vtt
|
VTT
|
18.7 KB
|
|
|
9 - Customizing Datasheet View and Advanced Sorting and Filtering.mp4
|
MP4
|
71.2 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
MC900056942.WMF
|
WMF
|
29.2 KB
|
|
|
MC900056945.WMF
|
WMF
|
21.5 KB
|
|
|
MC900056946.WMF
|
WMF
|
16.8 KB
|
|
|
MC900412030.WMF
|
WMF
|
39.7 KB
|
|
|
MC900412030.gif
|
GIF
|
33.8 KB
|
|
|
MC900412030.jpg
|
JPG
|
39.1 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_01.accdb
|
ACCDB
|
1.4 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_03x32.accde
|
ACCDE
|
1.3 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_03x32_be.accdb
|
ACCDB
|
420 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_03x64.accde
|
ACCDE
|
1.2 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_03x64_be.accdb
|
ACCDB
|
420 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_04.accdb
|
ACCDB
|
1.5 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_04_be.accdb
|
ACCDB
|
420 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_05.accdb
|
ACCDB
|
1.7 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_05_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_06.accdb
|
ACCDB
|
2.3 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_06_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_07.accdb
|
ACCDB
|
2.8 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_07_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_08.accdb
|
ACCDB
|
2.8 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_08_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_09.accdb
|
ACCDB
|
2.8 MB
|
|
|
SimonSezIT_Access2016Advanced_Exercise_09_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_Asset_Tracking.accdb
|
ACCDB
|
1.6 MB
|
|
|
SimonSezIT_Asset_Tracking.accde
|
ACCDE
|
1.5 MB
|
|
|
SimonSezIT_Asset_Tracking_A01.accdb
|
ACCDB
|
1.6 MB
|
|
|
SimonSezIT_Asset_Tracking_A02.accdb
|
ACCDB
|
2.1 MB
|
|
|
SimonSezIT_Asset_Tracking_be.accdb
|
ACCDB
|
480 KB
|
|
|
SimonSezIT_CRM__A01.accdb
|
ACCDB
|
984 KB
|
|
|
SimonSezIT_CRM__A02.accdb
|
ACCDB
|
708 KB
|
|
|
SimonSezIT_CRM__A03.accdb
|
ACCDB
|
628 KB
|
|
|
SimonSezIT_EspritDeTour_A21.accdb
|
ACCDB
|
7.1 MB
|
|
|
SimonSezIT_EspritDeTour_A22.accdb
|
ACCDB
|
7.2 MB
|
|
|
SimonSezIT_NightMovies_A21.accdb
|
ACCDB
|
1.8 MB
|
|
|
SimonSezIT_NightMovies_A22.accdb
|
ACCDB
|
1.5 MB
|
|
|
SimonSezIT_NightMovies_A23.accdb
|
ACCDB
|
1.4 MB
|
|
|
SimonSezIT_NightMovies_A23_be.accdb
|
ACCDB
|
420 KB
|
|
|
SimonSezIT_NightMovies_A24.accdb
|
ACCDB
|
1.9 MB
|
|
|
SimonSezIT_NightMovies_A24_be.accdb
|
ACCDB
|
556 KB
|
|
|
SimonSezIT_NorthwindTraders_A01.accdb
|
ACCDB
|
4.6 MB
|
|
|
SimonSezIT_NorthwindTraders_A02.accdb
|
ACCDB
|
4.6 MB
|
|
|
SimonSezIT_Students_A01.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A01_be.accdb
|
ACCDB
|
876 KB
|
|
|
SimonSezIT_Students_A02.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A02_be.accdb
|
ACCDB
|
876 KB
|
|
|
SimonSezIT_Students_A03.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A03_be.accdb
|
ACCDB
|
884 KB
|
|
|
SimonSezIT_Students_A04.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A04_be.accdb
|
ACCDB
|
884 KB
|
|
|
SimonSezIT_Students_A05.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A05_be.accdb
|
ACCDB
|
884 KB
|
|
|
SimonSezIT_Students_A06.accdb
|
ACCDB
|
9.8 MB
|
|
|
SimonSezIT_Students_A06_be.accdb
|
ACCDB
|
884 KB
|
|
|
SimonSezIT_Update_Dates_Example_Query.sql
|
SQL
|
102.4 B
|
|
|
SimonSezIT_VBA_A01.accdb
|
ACCDB
|
392 KB
|
|
|
SimonSezIT_VBA_A02.accdb
|
ACCDB
|
472 KB
|
|
|
SimonSezIT_VBA_A03.accdb
|
ACCDB
|
520 KB
|
|
|
SimonSezIT_VBA_A04.accdb
|
ACCDB
|
520 KB
|
|
|
State Abbeviations.xlsx
|
XLSX
|
10.8 KB
|
|
|
WideWorldImportersDW-Full.bak
|
BAK
|
47.7 MB
|
|
|
clapperboard.JPG
|
JPG
|
8.5 KB
|
|
|
clapperboard.ico
|
ICO
|
16.6 KB
|
|
|
clapperboard.png
|
PNG
|
50.2 KB
|
|
|
guardians.gif
|
GIF
|
1.4 KB
|
|
|
schoolwork.ico
|
ICO
|
97.3 KB
|
|
|
students.gif
|
GIF
|
1.3 KB
|
