Udemy - Microsoft Access VBA for Non Programmers_Sin

seeders: 1
leechers: 7
Download torrent
Added on June 26, 2016 by Sinin Other > Tutorials
Torrent verified.


Udemy - Microsoft Access VBA for Non Programmers_Sin (Size: 1.44 GB)
 001 Course Overview.mp48.99 MB
 002 Setup Tasks.mp49.58 MB
 003 Direct Download Links for Database Files.pdf242.12 KB
 004 How to Contact Me.mp43.29 MB
 desktop.ini138 bytes
 001 View Database Table and Forms - Review the Goal.mp46.2 MB
 002 Create Your First VBA Subroutine.mp424.64 MB
 003 Fix a Syntax Error and Take Over the Keyboard.mp49.87 MB
 004 Use an IF Statement and DoCmd.mp412.79 MB
 005 Use ElseIf and a Select Statement.mp417.4 MB
 006 Runtime Errors, Error Traps and Program Stops.mp427.59 MB
 007 Break Into Programs and Infinite Loops.mp411.73 MB
 008 What Have You Learned in Section 2 Quiz.html12.1 KB
 009 Section 2 Conclusion and Review.mp412.87 MB
 010 Section 2 Notes.pdf200.73 KB
 desktop.ini138 bytes
 001 On Open Event, Me Keyword and Orderby.mp423.32 MB
 002 Subroutines for Form Controls, VBA Editing Shortcuts.mp423.11 MB
 003 Modify Subroutines to Sort DESC, More Error Handling.mp435.64 MB
 004 What Have You Learned in Section 3 Quiz.html10.81 KB
 005 Section 3 Conclusion and Review.mp44.35 MB
 006 Section 3 Notes.pdf195.74 KB
 desktop.ini138 bytes
 001 Expanding the Keydown Subroutine.mp421.01 MB
 002 Using Public Variables.mp421.49 MB
 003 Building the Search Criteria.mp421.89 MB
 004 Field Names and Reserved Words.mp426.34 MB
 005 Using a Recordset and Bookmarks.mp416.76 MB
 006 Enhancing Our Instant Search.mp436.92 MB
 007 What Have You Learned In Section 4 Quiz.html13.15 KB
 008 Section 4 Conclusion and Review.mp49.06 MB
 009 Section 4 Notes.pdf207.06 KB
 desktop.ini138 bytes
 001 Open Another Form with a Button Click.mp420.4 MB
 002 Send Data to the Other Form.mp412.95 MB
 003 Modify a Form to Utilize Data Sent to it..mp414.88 MB
 004 Intro to SQL and Using SQL in the Recordsource.mp417.82 MB
 005 Locate Same Record When Returning from the Form.mp417.92 MB
 006 Modify the Form to Remember the Sort.mp423.18 MB
 007 Create a Prompt to Save Changes.mp415.27 MB
 008 Activate the Add Customer Button.mp414.03 MB
 009 Testing for a Blank Record.mp433.59 MB
 010 Activate the Delete Button.mp419.31 MB
 001 Setup Rowsource for Dropdown Filters.mp423.57 MB
 002 Enable Editing In the Dropdown Filters.mp426.86 MB
 003 Set Dropdown Rowsources on the Fly.mp427.4 MB
 004 Create a Subroutine to Build All the Filters.mp420.49 MB
 005 Use the AfterUpdate Event to Rebuild the Filter.mp49.8 MB
 006 Setup the Clear Filter Buttons.mp417.98 MB
 007 Save the Filters when Closing the Form.mp424.93 MB
 008 What Have You Learned in Section 6 Quiz.html13.17 KB
 009 Section 6 Conclusion and Review.mp48.55 MB
 010 Section 6 Notes.pdf212.51 KB
 desktop.ini138 bytes
 001 Inspect the Tables and Review the Goal.mp49.61 MB
 002 Creating a Summary Table with a Query.mp418.26 MB
 003 Building Our First Function and Saving Queries to VBA.mp414.98 MB
 004 Add a Delete Query and Create a Test Macro.mp412.13 MB
 005 Restructure Tables and Add a Second Query to our VBA Function.mp418.58 MB
 006 Figure Out How to Get the Days Between Orders.mp418.66 MB
 007 Doing the Steps With A Recordset.mp436.94 MB
 008 Calculate the Average Days Between Orders.mp422.8 MB
 009 Plug the Average Days into the Report Table.mp437.81 MB
 010 What Have You Learned In Section 7 Quiz.html18.25 KB
 001 View the Example of Removing the Nav Pane and Ribbon.mp45.69 MB
 002 Create the HideMenu subroutine.mp417.31 MB
 003 Call the HideMenu Subroutine from our Form.mp413.2 MB
 004 Make the Subroutine Toggle the Menus.mp414.89 MB
 005 Create a Startup Subroutine and an Autoexec Macro.mp414.99 MB
 006 Prevent Closing the Form and Activate the Exit Button.mp420.13 MB
 007 What Have You Learned in Section 8 Quiz.html16.78 KB
 008 Section 8 Conclusion and Review.mp45.79 MB
 009 Section 8 Notes.pdf283.79 KB
 desktop.ini138 bytes
 001 Overview and Goal.mp44.2 MB
 002 Create Delete Subroutine and Make First Changes to SummRpt Function.mp49.69 MB
 003 Backup the SummRpt Function and Make the First Changes.mp411.08 MB
 004 Pull a Query from VBA Back to Design, Change It and Update VBA.mp413.51 MB
 005 Use TableDefs to Add a Field to a Table.mp418.73 MB
 006 Use TableDefs to Create a Table and Add FIelds to it..mp413.59 MB
 007 Make Final Changes and Test the Modified Function.mp49.23 MB
 desktop.ini138 bytes
 001 Congratulations and Next Steps.mp416.76 MB
 desktop.ini138 bytes
 001 Download the Subforms Database.pdf226.27 KB
 002 Overview of the Tables in the Subforms Database.mp49.43 MB
 003 Overview of the Forms in the Subforms Database.mp46.86 MB
 004 Add OrderList as a Subform to the Customer Form..mp427.78 MB
 005 Using an On Exit Subroutine to Capture the Order Number You Were On.mp416.08 MB
 006 Pass the Order Number to the Go To Order Button.mp414.73 MB
 007 Open the Orders Form and Move to the Specified Order.mp414.75 MB
 008 Create Code to Return to the Customer Form.mp417.71 MB
 009 Setup the OrdProdList Subform.mp417.46 MB
 010 Create a Total in the Subform.mp413.26 MB
 001 Download the POPUPS Database.pdf229.51 KB
 002 Import Customer List Form and Rename it as CustPopup.mp45.51 MB
 003 Prepare the CustPopup form for use as a popup form..mp419.06 MB
 004 Modify the Customer Form code to Open the Popup.mp412.67 MB
 005 Make the Popup Move to the Current Customer On Open.mp414.93 MB
 006 Use the TAG Property to send the OrdCust Value Back from the Popup Form.mp419.29 MB
 007 Add a Customer From Inside the Popup Form.mp411.73 MB
 desktop.ini138 bytes
 001 Double Loop Database Download.pdf229.67 KB
 002 A CLASSIC situation that MUST be handled correctly.mp42.68 MB
 003 Database Overview and Why You Want One Table.mp48.46 MB
 004 The Code Behind the Recalc Button.mp415.03 MB
 005 Doing Total Queries and Making the Subroutine a Function.mp413.82 MB
 desktop.ini138 bytes
 001 Bonus Lecture - Expand Your Knowledge With My Other Courses.pdf244.4 KB
 desktop.ini138 bytes

Description

Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!

Create VBA Subroutines for Forms and Control the Keyboard
Extensive Training on Handling Errors
Control Record Sorting and Searching for Specific Records
Learn How to Move and Pass Data Between Forms
Create Interactive Pull Down Filters for Form Data
Build a Complex Report Entirely with VBA
Introduction to SQL and How to Use SQL in VBA
Turn the Ribbon and Nav Pane On and Off
Prevent Form Closure or Resizing
Learn How to Close Access with VBA

Powerful Skills That Increase Your Value in the Marketplace

Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!

There is a HUGE need in the marketplace for people who can create systems like this in Access. This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks! This could be your shortest path to increasing your income!

Content and Overview

All you need to do the course is some basic experience with Access components: tables, queries, forms and reports. This course does not require any programming experience or knowledge of macros.

Even though there are 80+ lectures and over 7.5 hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build a complete system, step by step.

By the time you have finished the course you will have done so much with VBA and it will be so familiar that you will be ready to tackle your own project immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

The course is complete with working files and finished code samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

Required Software

You should have Office 2010 or later. The course was created using Office 2010.

What are the requirements?

No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2013.

What am I going to get from this course?

Be able to create and test vba subroutines and functions
Be comfortable with moving to and from the vba editor
Take control of the keyboard within forms
Control interaction between forms and pass data back and forth
Tie sorting to clicking on controls within forms
Create and debug pull down filters on forms
Create the capability to instantly search for records
Use recordsets within forms to locate specific records
Convert queries into SQL and place them inside vBA code
Create complex reports using embedded queries and recordsets
Secure forms by turning off resize and close capabilities
Hide the menu and navigation pane and bring them back

What is the target audience?

This course is meant for those who have a basic familiarity with Microsoft Access, but have never used macros or done any VBA programming.

Sharing Widget


Download torrent
1.44 GB
seeders:1
leechers:7
Udemy - Microsoft Access VBA for Non Programmers_Sin