1. Урок 1.00:03:09
    Course Overview
  2. Урок 2.00:03:00
    Setup Tasks
  3. Урок 3.00:00:59
    How to Contact Me
  4. Урок 4.00:01:52
    View Database Table and Forms - Review the Goal
  5. Урок 5.00:07:42
    Create Your First VBA Subroutine!
  6. Урок 6.00:03:25
    Fix a Syntax Error and Take Over the Keyboard
  7. Урок 7.00:04:29
    Use an IF Statement and DoCmd
  8. Урок 8.00:06:14
    Use ElseIf and a Select Statement
  9. Урок 9.00:10:00
    Runtime Errors, Error Traps and Program Stops
  10. Урок 10.00:03:49
    Break Into Programs and Infinite Loops
  11. Урок 11.00:04:07
    Section 2 Conclusion and Review
  12. Урок 12.00:05:55
    On Open Event, Me Keyword and Orderby
  13. Урок 13.00:05:26
    Subroutines for Form Controls, VBA Editing Shortcuts
  14. Урок 14.00:10:25
    Modify Subroutines to Sort DESC, More Error Handling
  15. Урок 15.00:01:31
    Section 3 Conclusion and Review
  16. Урок 16.00:06:36
    Expanding the Keydown Subroutine
  17. Урок 17.00:06:14
    Using Public Variables
  18. Урок 18.00:06:37
    Building the Search Criteria
  19. Урок 19.00:08:41
    Field Names and Reserved Words
  20. Урок 20.00:05:38
    Using a Recordset and Bookmarks
  21. Урок 21.00:11:07
    Enhancing Our Instant Search
  22. Урок 22.00:03:13
    Section 4 Conclusion and Review
  23. Урок 23.00:06:18
    Open Another Form with a Button Click
  24. Урок 24.00:04:16
    Send Data to the Other Form
  25. Урок 25.00:06:07
    Modify a Form to Utilize Data Sent to it.
  26. Урок 26.00:07:10
    Intro to SQL and Using SQL in the Recordsource
  27. Урок 27.00:05:28
    Locate Same Record When Returning from the Form
  28. Урок 28.00:06:35
    Modify the Form to Remember the Sort
  29. Урок 29.00:04:51
    Create a Prompt to Save Changes
  30. Урок 30.00:04:31
    Activate the Add Customer Button
  31. Урок 31.00:09:55
    Testing for a Blank Record
  32. Урок 32.00:06:03
    Activate the Delete Button
  33. Урок 33.00:02:32
    Section 5 Conclusion and Review
  34. Урок 34.00:08:30
    Setup Rowsource for Dropdown Filters
  35. Урок 35.00:07:50
    Enable Editing In the Dropdown Filters
  36. Урок 36.00:08:26
    Set Dropdown Rowsources on the Fly
  37. Урок 37.00:07:36
    Create a Subroutine to Build All the Filters
  38. Урок 38.00:03:30
    Use the AfterUpdate Event to Rebuild the Filter
  39. Урок 39.00:04:44
    Setup the Clear Filter Buttons
  40. Урок 40.00:08:31
    Save the Filters when Closing the Form
  41. Урок 41.00:03:03
    Section 6 Conclusion and Review
  42. Урок 42.00:03:01
    Inspect the Tables and Review the Goal
  43. Урок 43.00:06:45
    Creating a Summary Table with a Query
  44. Урок 44.00:06:17
    Building Our First Function and Saving Queries to VBA
  45. Урок 45.00:04:31
    Add a Delete Query and Create a Test Macro
  46. Урок 46.00:06:26
    Restructure Tables and Add a Second Query to our VBA Function
  47. Урок 47.00:06:07
    Figure Out How to Get the Days Between Orders
  48. Урок 48.00:10:07
    Doing the Steps With A Recordset
  49. Урок 49.00:07:05
    Calculate the Average Days Between Orders
  50. Урок 50.00:10:40
    Plug the Average Days into the Report Table
  51. Урок 51.00:02:46
    Section 7 Conclusion and Review
  52. Урок 52.00:01:40
    View the Example of Removing the Nav Pane and Ribbon
  53. Урок 53.00:07:17
    Create the HideMenu subroutine
  54. Урок 54.00:04:16
    Call the HideMenu Subroutine from our Form
  55. Урок 55.00:04:55
    Make the Subroutine Toggle the Menus
  56. Урок 56.00:04:39
    Create a Startup Subroutine and an Autoexec Macro
  57. Урок 57.00:05:55
    Prevent Closing the Form and Activate the Exit Button
  58. Урок 58.00:02:03
    Section 8 Conclusion and Review
  59. Урок 59.00:01:58
    Overview and Goal
  60. Урок 60.00:02:58
    Create Delete Subroutine and Make First Changes to SummRpt Function
  61. Урок 61.00:02:56
    Backup the SummRpt Function and Make the First Changes
  62. Урок 62.00:04:46
    Pull a Query from VBA Back to Design, Change It and Update VBA
  63. Урок 63.00:04:51
    Use TableDefs to Add a Field to a Table
  64. Урок 64.00:04:22
    Use TableDefs to Create a Table and Add FIelds to it.
  65. Урок 65.00:02:51
    Make Final Changes and Test the Modified Function
  66. Урок 66.00:03:15
    Overview of the Tables in the Subforms Database
  67. Урок 67.00:02:19
    Overview of the Forms in the Subforms Database
  68. Урок 68.00:06:39
    Add OrderList as a Subform to the Customer Form.
  69. Урок 69.00:04:48
    Using an On Exit Subroutine to Capture the Order Number You Were On
  70. Урок 70.00:04:38
    Pass the Order Number to the Go To Order Button
  71. Урок 71.00:05:23
    Open the Orders Form and Move to the Specified Order
  72. Урок 72.00:05:33
    Create Code to Return to the Customer Form
  73. Урок 73.00:04:52
    Setup the OrdProdList Subform
  74. Урок 74.00:04:25
    Create a Total in the Subform
  75. Урок 75.00:04:21
    Update the Subtotal and Order Total
  76. Урок 76.00:05:01
    Add a New Product to the Order
  77. Урок 77.00:09:52
    Create the Add Order Subroutine and Post a New Order
  78. Урок 78.00:04:50
    Get the New Order Number and Open the Order Form
  79. Урок 79.00:03:00
    Review, Conclusion and Future Enhancements
  80. Урок 80.00:03:01
    Import Customer List Form and Rename it as CustPopup
  81. Урок 81.00:04:59
    Prepare the CustPopup form for use as a popup form.
  82. Урок 82.00:06:06
    Modify the Customer Form code to Open the Popup
  83. Урок 83.00:06:02
    Make the Popup Move to the Current Customer On Open
  84. Урок 84.00:05:42
    Use the TAG Property to send the OrdCust Value Back from the Popup Form
  85. Урок 85.00:03:11
    Add a Customer From Inside the Popup Form
  86. Урок 86.00:01:19
    A CLASSIC situation that MUST be handled correctly
  87. Урок 87.00:04:04
    Database Overview and Why You Want One Table
  88. Урок 88.00:06:32
    The Code Behind the Recalc Button
  89. Урок 89.00:05:57
    Doing Total Queries and Making the Subroutine a Function
  90. Урок 90.00:05:39
    Congratulations and Next Steps