Udemy - Microsoft Access 2016 Intermediate - Advanced Course

Files:

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