در دوره آموزشی Udemy Microsoft Access VBA for Non Programmers برنامه نویسی VBA برای Access به سادگی توضیح داده شده است. حتی اگر دانش کمی از برنامه نویسی دارید این مجموعه آموزش با بیان ساده خود برایتان مناسب خواهد بود. زمانی که این دوره را به پایان گذراندید در حدی با VBA آشنا می باشید که می توانید درگیر پروژه های خودتان شوید.
سر فصل های دوره آموزشی Udemy Microsoft Access VBA for Non Programmers :
Course Overview-
Setup Tasks-
How to Contact Me-
View Database Table and Forms – Review the Goal-
Create Your First VBA Subroutine-
Fix a Syntax Error and Take Over the Keyboard-
Use an IF Statement and DoCmd-
Use ElseIf and a Select Statement-
Runtime Errors, Error Traps and Program Stops-
Break Into Programs and Infinite Loops-
Section 2 Conclusion and Review-
On Open Event, Me Keyword and Orderby-
Subroutines for Form Controls, VBA Editing Shortcuts-
Modify Subroutines to Sort DESC, More Error Handling-
Section 3 Conclusion and Review-
Expanding the Keydown Subroutine-
Using Public Variables-
Building the Search Criteria-
Field Names and Reserved Words-
Using a Recordset and Bookmarks-
Enhancing Our Instant Search-
Section 4 Conclusion and Review-
Open Another Form with a Button Click-
Send Data to the Other Form-
Modify a Form to Utilize Data Sent to it.-
Intro to SQL and Using SQL in the Recordsource-
Locate Same Record When Returning from the Form-
Modify the Form to Remember the Sort-
Create a Prompt to Save Changes-
Activate the Add Customer Button-
Testing for a Blank Record-
Activate the Delete Button-
Section 5 Conclusion and Review-
Setup Rowsource for Dropdown Filters-
Enable Editing In the Dropdown Filters-
Set Dropdown Rowsources on the Fly-
Create a Subroutine to Build All the Filters-
Use the AfterUpdate Event to Rebuild the Filter-
Setup the Clear Filter Buttons-
Save the Filters when Closing the Form-
Section 6 Conclusion and Review-
Inspect the Tables and Review the Goal-
Creating a Summary Table with a Query-
Building Our First Function and Saving Queries to VBA-
Add a Delete Query and Create a Test Macro-
Restructure Tables and Add a Second Query to our VBA Function-
Figure Out How to Get the Days Between Orders-
Doing the Steps With A Recordset-
Calculate the Average Days Between Orders-
Plug the Average Days into the Report Table-
Section 7 Conclusion and Review-
View the Example of Removing the Nav Pane and Ribbon-
Create the HideMenu subroutine-
Call the HideMenu Subroutine from our Form-
Make the Subroutine Toggle the Menus-
Create a Startup Subroutine and an Autoexec Macro-
Prevent Closing the Form and Activate the Exit Button-
Section 8 Conclusion and Review-
Overview and Goal-
Create Delete Subroutine and Make First Changes to SummRpt Function-
Backup the SummRpt Function and Make the First Changes-
Congratulations and Next Steps-
Overview of the Tables in the Subforms Database-
Overview of the Forms in the Subforms Database-
DDownload the Subforms Database-
با تشکر ولی بهتر نیست این اموزشها فارسی باشه