种子简介

种子名称： Udemy - Microsoft Access VBA for Non Programmers
文件类型： 视频
文件数目： 90个文件
文件大小： 1.44 GB
收录时间： 2020-9-17 11:02
已经下载： 3次
资源热度： 177
最近下载： 2024-12-26 12:01

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:15e87874e747c715e906063c4fd281f93eaead21&dn=Udemy - Microsoft Access VBA for Non Programmers 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Udemy - Microsoft Access VBA for Non Programmers.torrent

01 Introduction/001 Course Overview.mp48.99MB

01 Introduction/002 Setup Tasks.mp49.58MB

01 Introduction/004 How to Contact Me.mp43.29MB

02 Start Learning VBA and Handling Errors/001 View Database Table and Forms - Review the Goal.mp46.2MB

02 Start Learning VBA and Handling Errors/002 Create Your First VBA Subroutine.mp424.64MB

02 Start Learning VBA and Handling Errors/003 Fix a Syntax Error and Take Over the Keyboard.mp49.87MB

02 Start Learning VBA and Handling Errors/004 Use an IF Statement and DoCmd.mp412.79MB

02 Start Learning VBA and Handling Errors/005 Use ElseIf and a Select Statement.mp417.4MB

02 Start Learning VBA and Handling Errors/006 Runtime Errors, Error Traps and Program Stops.mp427.59MB

02 Start Learning VBA and Handling Errors/007 Break Into Programs and Infinite Loops.mp411.73MB

02 Start Learning VBA and Handling Errors/009 Section 2 Conclusion and Review.mp412.87MB

03 Create Record Sorting Subroutines/001 On Open Event, Me Keyword and Orderby.mp423.32MB

03 Create Record Sorting Subroutines/002 Subroutines for Form Controls, VBA Editing Shortcuts.mp423.11MB

03 Create Record Sorting Subroutines/003 Modify Subroutines to Sort DESC, More Error Handling.mp435.64MB

03 Create Record Sorting Subroutines/005 Section 3 Conclusion and Review.mp44.35MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/001 Expanding the Keydown Subroutine.mp421.01MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/002 Using Public Variables.mp421.49MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/003 Building the Search Criteria.mp421.89MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/004 Field Names and Reserved Words.mp426.34MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/005 Using a Recordset and Bookmarks.mp416.76MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/006 Enhancing Our Instant Search.mp436.92MB

04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/008 Section 4 Conclusion and Review.mp49.06MB

05 Interact With Other Forms and Pass Information/001 Open Another Form with a Button Click.mp420.4MB

05 Interact With Other Forms and Pass Information/002 Send Data to the Other Form.mp412.95MB

05 Interact With Other Forms and Pass Information/003 Modify a Form to Utilize Data Sent to it..mp414.88MB

05 Interact With Other Forms and Pass Information/004 Intro to SQL and Using SQL in the Recordsource.mp417.82MB

05 Interact With Other Forms and Pass Information/005 Locate Same Record When Returning from the Form.mp417.92MB

05 Interact With Other Forms and Pass Information/006 Modify the Form to Remember the Sort.mp423.18MB

05 Interact With Other Forms and Pass Information/007 Create a Prompt to Save Changes.mp415.27MB

05 Interact With Other Forms and Pass Information/008 Activate the Add Customer Button.mp414.03MB

05 Interact With Other Forms and Pass Information/009 Testing for a Blank Record.mp433.59MB

05 Interact With Other Forms and Pass Information/010 Activate the Delete Button.mp419.31MB

05 Interact With Other Forms and Pass Information/012 Section 5 Conclusion and Review.mp47.36MB

06 Add Multiple Interactive Pulldown Filters/001 Setup Rowsource for Dropdown Filters.mp423.57MB

06 Add Multiple Interactive Pulldown Filters/002 Enable Editing In the Dropdown Filters.mp426.86MB

06 Add Multiple Interactive Pulldown Filters/003 Set Dropdown Rowsources on the Fly.mp427.4MB

06 Add Multiple Interactive Pulldown Filters/004 Create a Subroutine to Build All the Filters.mp420.49MB

06 Add Multiple Interactive Pulldown Filters/005 Use the AfterUpdate Event to Rebuild the Filter.mp49.8MB

06 Add Multiple Interactive Pulldown Filters/006 Setup the Clear Filter Buttons.mp417.98MB

06 Add Multiple Interactive Pulldown Filters/007 Save the Filters when Closing the Form.mp424.93MB

06 Add Multiple Interactive Pulldown Filters/009 Section 6 Conclusion and Review.mp48.55MB

07 Build a Report Containing Complex Calculations/001 Inspect the Tables and Review the Goal.mp49.61MB

07 Build a Report Containing Complex Calculations/002 Creating a Summary Table with a Query.mp418.26MB

07 Build a Report Containing Complex Calculations/003 Building Our First Function and Saving Queries to VBA.mp414.98MB

07 Build a Report Containing Complex Calculations/004 Add a Delete Query and Create a Test Macro.mp412.13MB

07 Build a Report Containing Complex Calculations/005 Restructure Tables and Add a Second Query to our VBA Function.mp418.58MB

07 Build a Report Containing Complex Calculations/006 Figure Out How to Get the Days Between Orders.mp418.66MB

07 Build a Report Containing Complex Calculations/007 Doing the Steps With A Recordset.mp436.94MB

07 Build a Report Containing Complex Calculations/008 Calculate the Average Days Between Orders.mp422.8MB

07 Build a Report Containing Complex Calculations/009 Plug the Average Days into the Report Table.mp437.81MB

07 Build a Report Containing Complex Calculations/011 Section 7 Conclusion and Review.mp48.13MB

08 Turn Off The Menu, Ribbon and Navigation Pane/001 View the Example of Removing the Nav Pane and Ribbon.mp45.69MB

08 Turn Off The Menu, Ribbon and Navigation Pane/002 Create the HideMenu subroutine.mp417.31MB

08 Turn Off The Menu, Ribbon and Navigation Pane/003 Call the HideMenu Subroutine from our Form.mp413.2MB

08 Turn Off The Menu, Ribbon and Navigation Pane/004 Make the Subroutine Toggle the Menus.mp414.89MB

08 Turn Off The Menu, Ribbon and Navigation Pane/005 Create a Startup Subroutine and an Autoexec Macro.mp414.99MB

08 Turn Off The Menu, Ribbon and Navigation Pane/006 Prevent Closing the Form and Activate the Exit Button.mp420.13MB

08 Turn Off The Menu, Ribbon and Navigation Pane/008 Section 8 Conclusion and Review.mp45.79MB

09 How to Create and Modify Table Structures In VBA/001 Overview and Goal.mp44.2MB

09 How to Create and Modify Table Structures In VBA/002 Create Delete Subroutine and Make First Changes to SummRpt Function.mp49.69MB

09 How to Create and Modify Table Structures In VBA/003 Backup the SummRpt Function and Make the First Changes.mp411.08MB

09 How to Create and Modify Table Structures In VBA/004 Pull a Query from VBA Back to Design, Change It and Update VBA.mp413.51MB

09 How to Create and Modify Table Structures In VBA/005 Use TableDefs to Add a Field to a Table.mp418.73MB

09 How to Create and Modify Table Structures In VBA/006 Use TableDefs to Create a Table and Add FIelds to it..mp413.59MB

09 How to Create and Modify Table Structures In VBA/007 Make Final Changes and Test the Modified Function.mp49.23MB

10 Summary and Conclusion/001 Congratulations and Next Steps.mp416.76MB

11 Section 11 USING SUBFORMS/002 Overview of the Tables in the Subforms Database.mp49.43MB

11 Section 11 USING SUBFORMS/003 Overview of the Forms in the Subforms Database.mp46.86MB

11 Section 11 USING SUBFORMS/004 Add OrderList as a Subform to the Customer Form..mp427.78MB

11 Section 11 USING SUBFORMS/005 Using an On Exit Subroutine to Capture the Order Number You Were On.mp416.08MB

11 Section 11 USING SUBFORMS/006 Pass the Order Number to the Go To Order Button.mp414.73MB

11 Section 11 USING SUBFORMS/007 Open the Orders Form and Move to the Specified Order.mp414.75MB

11 Section 11 USING SUBFORMS/008 Create Code to Return to the Customer Form.mp417.71MB

11 Section 11 USING SUBFORMS/009 Setup the OrdProdList Subform.mp417.46MB

11 Section 11 USING SUBFORMS/010 Create a Total in the Subform.mp413.26MB

11 Section 11 USING SUBFORMS/011 Update the Subtotal and Order Total.mp413.28MB

11 Section 11 USING SUBFORMS/012 Add a New Product to the Order.mp416.32MB

11 Section 11 USING SUBFORMS/013 Create the Add Order Subroutine and Post a New Order.mp430.56MB

11 Section 11 USING SUBFORMS/014 Get the New Order Number and Open the Order Form.mp418.94MB

11 Section 11 USING SUBFORMS/015 Review, Conclusion and Future Enhancements.mp46.4MB

12 Using POPUP Forms/002 Import Customer List Form and Rename it as CustPopup.mp45.51MB

12 Using POPUP Forms/003 Prepare the CustPopup form for use as a popup form..mp419.06MB

12 Using POPUP Forms/004 Modify the Customer Form code to Open the Popup.mp412.67MB

12 Using POPUP Forms/005 Make the Popup Move to the Current Customer On Open.mp414.93MB

12 Using POPUP Forms/006 Use the TAG Property to send the OrdCust Value Back from the Popup Form.mp419.29MB

12 Using POPUP Forms/007 Add a Customer From Inside the Popup Form.mp411.73MB

13 A CLASSIC Double Loop Walk Thru/002 A CLASSIC situation that MUST be handled correctly.mp42.68MB

13 A CLASSIC Double Loop Walk Thru/003 Database Overview and Why You Want One Table.mp48.46MB

13 A CLASSIC Double Loop Walk Thru/004 The Code Behind the Recalc Button.mp415.03MB

13 A CLASSIC Double Loop Walk Thru/005 Doing Total Queries and Making the Subroutine a Function.mp413.82MB