| 1 - Course Overview and Content English.vtt | 10.8 KB | ||
| 1 - Course Overview and Content.mp4 | 26.1 MB | ||
| 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 | ||
| 12 - Linking Two Tables to Other Access Databases English.vtt | 17.6 KB | ||
| 12 - Linking Two Tables to Other Access Databases.mp4 | 35 MB | ||
| 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 MB | ||
| 15 - Exercise 2 English.vtt | 1.3 KB | ||
| 15 - Exercise 2.mp4 | 2.5 MB | ||
| 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 KB | ||
| 17 - Converting Shared Table into Local Table Moving Backend Database.mp4 | 30.2 MB | ||
| 18 - Exercise 3 English.vtt | 2 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 | ||
| 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 | ||
| 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 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 | ||
| 25 - Customizing the Ribbon and Quick Access Tool English.vtt | 16.1 KB | ||
| 25 - Customizing the Ribbon and Quick Access Tool.mp4 | 30 MB | ||
| 26 - Convert Macros to VBA VBA Editor and Property Windows English.vtt | 16 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 | ||
| 3 - DOWNLOAD ME Course Exercise Files.html | 1 KB | ||
| 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 | ||
| 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 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 | ||
| 36 - Formatting Bound and Control Form English.vtt | 16.6 KB | ||
| 36 - Formatting Bound and Control Form.mp4 | 43 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 | ||
| 4 - DOWNLOAD ME Course Demo Files.html | 1 KB | ||
| 40 - Exercise 07 English.vtt | 9.6 KB | ||
| 40 - Exercise 07.mp4 | 15.5 MB | ||
| 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 | 819.2 B | ||
| 45 - Exercise 08.mp4 | 2.3 MB | ||
| 46 - Action Queries Part 1 English.vtt | 17 KB | ||
| 46 - Action Queries Part 1.mp4 | 40.6 MB | ||
| 47 - Action Queries Part 2 English.vtt | 12 KB | ||
| 47 - Action Queries Part 2.mp4 | 31.4 MB | ||
| 48 - Subqueries English.vtt | 4.3 KB | ||
| 48 - Subqueries.mp4 | 13.6 MB | ||
| 49 - Steps in Packaging Access Application English.vtt | 17.2 KB | ||
| 49 - Steps in Packaging Access Application.mp4 | 36.6 MB | ||
| 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 | ||
| 50 - Exercise 09 English.vtt | 1.7 KB | ||
| 50 - Exercise 09.mp4 | 2.2 MB | ||
| 51 - Online Support and Conclusion English.vtt | 5.6 KB | ||
| 51 - Online Support and Conclusion.mp4 | 13.9 MB | ||
| 52 - Access-Shortcuts.pdf | 2.7 MB | ||
| 52 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html | 0 B | ||
| 6 - More About Indexes English.vtt | 9.9 KB | ||
| 6 - More About Indexes.mp4 | 22.2 MB | ||
| 7 - Settingup Northwind Database English.vtt | 5.5 KB | ||
| 7 - Settingup Northwind Database.mp4 | 10 MB | ||
| 8 - Working in a Datasheet View English.vtt | 16 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 | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| 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?042148 | 39.1 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_01.accdb | 1.4 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_03x32.accde | 1.3 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_03x32_be.accdb | 420 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_03x64.accde | 1.2 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_03x64_be.accdb | 420 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_04.accdb | 1.5 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_04_be.accdb | 420 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_05.accdb | 1.7 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_05_be.accdb | 556 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_06.accdb | 2.3 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_06_be.accdb | 556 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_07.accdb | 2.8 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_07_be.accdb | 556 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_08.accdb | 2.8 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_08_be.accdb | 556 KB | ||
| SimonSezIT_Access2016Advanced_Exercise_09.accdb | 2.8 MB | ||
| SimonSezIT_Access2016Advanced_Exercise_09_be.accdb | 556 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 KB | ||
| SimonSezIT_CRM__A01.accdb | 984 KB | ||
| SimonSezIT_CRM__A02.accdb | 708 KB | ||
| SimonSezIT_CRM__A03.accdb | 628 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 KB | ||
| SimonSezIT_NightMovies_A24.accdb | 1.9 MB | ||
| SimonSezIT_NightMovies_A24_be.accdb | 556 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 KB | ||
| SimonSezIT_Students_A02.accdb | 9.8 MB | ||
| SimonSezIT_Students_A02_be.accdb | 876 KB | ||
| SimonSezIT_Students_A03.accdb | 9.8 MB | ||
| SimonSezIT_Students_A03_be.accdb | 884 KB | ||
| SimonSezIT_Students_A04.accdb | 9.8 MB | ||
| SimonSezIT_Students_A04_be.accdb | 884 KB | ||
| SimonSezIT_Students_A05.accdb | 9.8 MB | ||
| SimonSezIT_Students_A05_be.accdb | 884 KB | ||
| SimonSezIT_Students_A06.accdb | 9.8 MB | ||
| SimonSezIT_Students_A06_be.accdb | 884 KB | ||
| SimonSezIT_Update_Dates_Example_Query.sql | 102.4 B | ||
| SimonSezIT_VBA_A01.accdb | 392 KB | ||
| SimonSezIT_VBA_A02.accdb | 472 KB | ||
| SimonSezIT_VBA_A03.accdb | 520 KB | ||
| SimonSezIT_VBA_A04.accdb | 520 KB | ||
| State Abbeviations.xlsx | 10.8 KB | ||
| WideWorldImportersDW-Full.bak | 47.7 MB | ||
| clapperboard.jpg?042148 | 8.5 KB | ||
| clapperboard.ico | 16.6 KB | ||
| clapperboard.png | 50.2 KB | ||
| guardians.gif | 1.4 KB | ||
| schoolwork.ico | 97.3 KB | ||
| students.gif | 1.3 KB | ||
| ▲ 170 total files | |||
Microsoft Access 2016 Intermediate/Advanced Course
https://DevCourseWeb.com
Last updated 2/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.44 GB | Duration: 9h 7m
The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills
What you'll learn
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Explore the use of Visual Basic for Applications (VBA).
Discover advanced options for the use of forms.
Dive into options for packaging your application for distribution.
Practice with included Access 2016 exercises files.
Follow along with the instructor with included instructor stration files.
Discover advanced options and tips for building and using queries.
Follow along as you learn to create and maintain macros.
Complete database projects at the advanced level.
Get helpful techniques that allow you to link, report, and package your data quickly.
Requirements
A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
Microsoft Access 2016
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 2 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 3 weeks | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 3 weeks | 9 | 5 |
| 999.5 MB | freecoursewb | 3 weeks | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 3 weeks | 6 | 1 |
All Comments