zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
Udemy - Microsoft Access VBA for Non Programmers
magnet:?xt=urn:btih:15e87874e747c715e906063c4fd281f93eaead21&dn=Udemy - Microsoft Access VBA for Non Programmers
磁力链接详情
Hash值:
15e87874e747c715e906063c4fd281f93eaead21
点击数:
144
文件大小:
1.44 GB
文件数量:
90
创建日期:
2020-9-17 11:02
最后访问:
2024-7-15 13:40
访问标签:
Udemy
-
Microsoft
Access
VBA
for
Non
Programmers
文件列表详情
01 Introduction/001 Course Overview.mp4 8.99 MB
01 Introduction/002 Setup Tasks.mp4 9.58 MB
01 Introduction/004 How to Contact Me.mp4 3.29 MB
02 Start Learning VBA and Handling Errors/001 View Database Table and Forms - Review the Goal.mp4 6.2 MB
02 Start Learning VBA and Handling Errors/002 Create Your First VBA Subroutine.mp4 24.64 MB
02 Start Learning VBA and Handling Errors/003 Fix a Syntax Error and Take Over the Keyboard.mp4 9.87 MB
02 Start Learning VBA and Handling Errors/004 Use an IF Statement and DoCmd.mp4 12.79 MB
02 Start Learning VBA and Handling Errors/005 Use ElseIf and a Select Statement.mp4 17.4 MB
02 Start Learning VBA and Handling Errors/006 Runtime Errors, Error Traps and Program Stops.mp4 27.59 MB
02 Start Learning VBA and Handling Errors/007 Break Into Programs and Infinite Loops.mp4 11.73 MB
02 Start Learning VBA and Handling Errors/009 Section 2 Conclusion and Review.mp4 12.87 MB
03 Create Record Sorting Subroutines/001 On Open Event, Me Keyword and Orderby.mp4 23.32 MB
03 Create Record Sorting Subroutines/002 Subroutines for Form Controls, VBA Editing Shortcuts.mp4 23.11 MB
03 Create Record Sorting Subroutines/003 Modify Subroutines to Sort DESC, More Error Handling.mp4 35.64 MB
03 Create Record Sorting Subroutines/005 Section 3 Conclusion and Review.mp4 4.35 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/001 Expanding the Keydown Subroutine.mp4 21.01 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/002 Using Public Variables.mp4 21.49 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/003 Building the Search Criteria.mp4 21.89 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/004 Field Names and Reserved Words.mp4 26.34 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/005 Using a Recordset and Bookmarks.mp4 16.76 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/006 Enhancing Our Instant Search.mp4 36.92 MB
04 Use Instant Search to Learn More About the Keyboard, Recordsets and Variables/008 Section 4 Conclusion and Review.mp4 9.06 MB
05 Interact With Other Forms and Pass Information/001 Open Another Form with a Button Click.mp4 20.4 MB
05 Interact With Other Forms and Pass Information/002 Send Data to the Other Form.mp4 12.95 MB
05 Interact With Other Forms and Pass Information/003 Modify a Form to Utilize Data Sent to it..mp4 14.88 MB
05 Interact With Other Forms and Pass Information/004 Intro to SQL and Using SQL in the Recordsource.mp4 17.82 MB
05 Interact With Other Forms and Pass Information/005 Locate Same Record When Returning from the Form.mp4 17.92 MB
05 Interact With Other Forms and Pass Information/006 Modify the Form to Remember the Sort.mp4 23.18 MB
05 Interact With Other Forms and Pass Information/007 Create a Prompt to Save Changes.mp4 15.27 MB
05 Interact With Other Forms and Pass Information/008 Activate the Add Customer Button.mp4 14.03 MB
05 Interact With Other Forms and Pass Information/009 Testing for a Blank Record.mp4 33.59 MB
05 Interact With Other Forms and Pass Information/010 Activate the Delete Button.mp4 19.31 MB
05 Interact With Other Forms and Pass Information/012 Section 5 Conclusion and Review.mp4 7.36 MB
06 Add Multiple Interactive Pulldown Filters/001 Setup Rowsource for Dropdown Filters.mp4 23.57 MB
06 Add Multiple Interactive Pulldown Filters/002 Enable Editing In the Dropdown Filters.mp4 26.86 MB
06 Add Multiple Interactive Pulldown Filters/003 Set Dropdown Rowsources on the Fly.mp4 27.4 MB
06 Add Multiple Interactive Pulldown Filters/004 Create a Subroutine to Build All the Filters.mp4 20.49 MB
06 Add Multiple Interactive Pulldown Filters/005 Use the AfterUpdate Event to Rebuild the Filter.mp4 9.8 MB
06 Add Multiple Interactive Pulldown Filters/006 Setup the Clear Filter Buttons.mp4 17.98 MB
06 Add Multiple Interactive Pulldown Filters/007 Save the Filters when Closing the Form.mp4 24.93 MB
06 Add Multiple Interactive Pulldown Filters/009 Section 6 Conclusion and Review.mp4 8.55 MB
07 Build a Report Containing Complex Calculations/001 Inspect the Tables and Review the Goal.mp4 9.61 MB
07 Build a Report Containing Complex Calculations/002 Creating a Summary Table with a Query.mp4 18.26 MB
07 Build a Report Containing Complex Calculations/003 Building Our First Function and Saving Queries to VBA.mp4 14.98 MB
07 Build a Report Containing Complex Calculations/004 Add a Delete Query and Create a Test Macro.mp4 12.13 MB
07 Build a Report Containing Complex Calculations/005 Restructure Tables and Add a Second Query to our VBA Function.mp4 18.58 MB
07 Build a Report Containing Complex Calculations/006 Figure Out How to Get the Days Between Orders.mp4 18.66 MB
07 Build a Report Containing Complex Calculations/007 Doing the Steps With A Recordset.mp4 36.94 MB
07 Build a Report Containing Complex Calculations/008 Calculate the Average Days Between Orders.mp4 22.8 MB
07 Build a Report Containing Complex Calculations/009 Plug the Average Days into the Report Table.mp4 37.81 MB
07 Build a Report Containing Complex Calculations/011 Section 7 Conclusion and Review.mp4 8.13 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/001 View the Example of Removing the Nav Pane and Ribbon.mp4 5.69 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/002 Create the HideMenu subroutine.mp4 17.31 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/003 Call the HideMenu Subroutine from our Form.mp4 13.2 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/004 Make the Subroutine Toggle the Menus.mp4 14.89 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/005 Create a Startup Subroutine and an Autoexec Macro.mp4 14.99 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/006 Prevent Closing the Form and Activate the Exit Button.mp4 20.13 MB
08 Turn Off The Menu, Ribbon and Navigation Pane/008 Section 8 Conclusion and Review.mp4 5.79 MB
09 How to Create and Modify Table Structures In VBA/001 Overview and Goal.mp4 4.2 MB
09 How to Create and Modify Table Structures In VBA/002 Create Delete Subroutine and Make First Changes to SummRpt Function.mp4 9.69 MB
09 How to Create and Modify Table Structures In VBA/003 Backup the SummRpt Function and Make the First Changes.mp4 11.08 MB
09 How to Create and Modify Table Structures In VBA/004 Pull a Query from VBA Back to Design, Change It and Update VBA.mp4 13.51 MB
09 How to Create and Modify Table Structures In VBA/005 Use TableDefs to Add a Field to a Table.mp4 18.73 MB
09 How to Create and Modify Table Structures In VBA/006 Use TableDefs to Create a Table and Add FIelds to it..mp4 13.59 MB
09 How to Create and Modify Table Structures In VBA/007 Make Final Changes and Test the Modified Function.mp4 9.23 MB
10 Summary and Conclusion/001 Congratulations and Next Steps.mp4 16.76 MB
11 Section 11 USING SUBFORMS/002 Overview of the Tables in the Subforms Database.mp4 9.43 MB
11 Section 11 USING SUBFORMS/003 Overview of the Forms in the Subforms Database.mp4 6.86 MB
11 Section 11 USING SUBFORMS/004 Add OrderList as a Subform to the Customer Form..mp4 27.78 MB
11 Section 11 USING SUBFORMS/005 Using an On Exit Subroutine to Capture the Order Number You Were On.mp4 16.08 MB
11 Section 11 USING SUBFORMS/006 Pass the Order Number to the Go To Order Button.mp4 14.73 MB
11 Section 11 USING SUBFORMS/007 Open the Orders Form and Move to the Specified Order.mp4 14.75 MB
11 Section 11 USING SUBFORMS/008 Create Code to Return to the Customer Form.mp4 17.71 MB
11 Section 11 USING SUBFORMS/009 Setup the OrdProdList Subform.mp4 17.46 MB
11 Section 11 USING SUBFORMS/010 Create a Total in the Subform.mp4 13.26 MB
11 Section 11 USING SUBFORMS/011 Update the Subtotal and Order Total.mp4 13.28 MB
11 Section 11 USING SUBFORMS/012 Add a New Product to the Order.mp4 16.32 MB
11 Section 11 USING SUBFORMS/013 Create the Add Order Subroutine and Post a New Order.mp4 30.56 MB
11 Section 11 USING SUBFORMS/014 Get the New Order Number and Open the Order Form.mp4 18.94 MB
11 Section 11 USING SUBFORMS/015 Review, Conclusion and Future Enhancements.mp4 6.4 MB
12 Using POPUP Forms/002 Import Customer List Form and Rename it as CustPopup.mp4 5.51 MB
12 Using POPUP Forms/003 Prepare the CustPopup form for use as a popup form..mp4 19.06 MB
12 Using POPUP Forms/004 Modify the Customer Form code to Open the Popup.mp4 12.67 MB
12 Using POPUP Forms/005 Make the Popup Move to the Current Customer On Open.mp4 14.93 MB
12 Using POPUP Forms/006 Use the TAG Property to send the OrdCust Value Back from the Popup Form.mp4 19.29 MB
12 Using POPUP Forms/007 Add a Customer From Inside the Popup Form.mp4 11.73 MB
13 A CLASSIC Double Loop Walk Thru/002 A CLASSIC situation that MUST be handled correctly.mp4 2.68 MB
13 A CLASSIC Double Loop Walk Thru/003 Database Overview and Why You Want One Table.mp4 8.46 MB
13 A CLASSIC Double Loop Walk Thru/004 The Code Behind the Recalc Button.mp4 15.03 MB
13 A CLASSIC Double Loop Walk Thru/005 Doing Total Queries and Making the Subroutine a Function.mp4 13.82 MB
其他位置