{"id":68479,"date":"2021-08-04T04:10:06","date_gmt":"2021-08-04T08:10:06","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/what-vba-can-do-for-microsft-access-topics-to-learn-in-vba-90\/"},"modified":"2021-08-04T04:10:06","modified_gmt":"2021-08-04T08:10:06","slug":"what-vba-can-do-for-microsft-access-topics-to-learn-in-vba-90","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=68479","title":{"rendered":"What VBA can do for Microsft Access? Topics to learn in VBA #90"},"content":{"rendered":"<p>  What VBA can do?  <\/p>\n<ul>\n<li> VBA can be used to automate Access      <\/li>\n<li> VBA provides a true automation tool, replacing and extending anything that you can do with Access macros      <\/li>\n<li> Can manipulate\/utilize Access event model      <\/li>\n<li> Can populate and manipulate access controls      <\/li>\n<li> Provides complete control over the data and layout of reports from code  <\/li>\n<\/ul>\n<p>What to learn in VBA?  <\/p>\n<ul>\n<li> Familiarize yourself with the editor to write VBA codes     <\/li>\n<li> Understand Variables, Constants, and Data Types in VBA     <\/li>\n<li> Learn procedures in VBA     <\/li>\n<li> Common VBA Functions: Financial and date calculations, text manipulation, and mathematical functions      <\/li>\n<li> Flow-of-Control Statements in VBA     <\/li>\n<li> Arrays     <\/li>\n<li> Objects: Built in VBA Objects     <\/li>\n<li> Scope and Lifetime of variables     <\/li>\n<li> VBA to automate Access forms     <\/li>\n<li> Access event handling with VBA     <\/li>\n<li> Populate and manipulate  controls such as List and Combo boxes with VBA     <\/li>\n<li> VBA to control the data and layout of reports from code     <\/li>\n<li> Get information about Access objects such as forms, reports, tables, and queries with VBA     <\/li>\n<li> Control and manipulate data access with ADO     <\/li>\n<li> ADOX to create an entirely new Access table without ever touching the Access user interface     <\/li>\n<li> Working with Text files using VBA     <\/li>\n<li> VBA code in Access to manipulate applications such as Microsoft Word or Microsoft Excel     <\/li>\n<li> Working with XML Files using VBA     <\/li>\n<li> Using Windows API from VBA          <\/li>\n<li> VBA Alternatives: Access macros or Structured Query Language (SQL)   <\/li>\n<\/ul>\n<p> From: http:\/\/sitestree.com\/?p=5123<br \/> Categories:90<br \/>Tags:<br \/> Post Data:2006-10-24 21:07:29<\/p>\n<p>\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a><br \/>\n\t\tIn Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a><br \/>\n\t\t<a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a><br \/>\n\t\t8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a><br \/>\n\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\tMedium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What VBA can do? VBA can be used to automate Access VBA provides a true automation tool, replacing and extending anything that you can do with Access macros Can manipulate\/utilize Access event model Can populate and manipulate access controls Provides complete control over the data and layout of reports from code What to learn in &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=68479\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-68479","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6379,"url":"http:\/\/bangla.sitestree.com\/?p=6379","url_meta":{"origin":68479,"position":0},"title":"Microsoft Project and Project Management","author":"Author-Check- Article-or-Video","date":"February 27, 2015","format":false,"excerpt":"Microsoft Project\u00a0\u0993 \u09aa\u09cd\u09b0\u0995\u09b2\u09cd\u09aa \u09ac\u09cd\u09af\u09ac\u09b8\u09cd\u09a5\u09be\u09aa\u09a8\u09be\u0983 \u09b0\u09bf\u09a6\u0993\u09df\u09be\u09a8 \u09ac\u09bf\u09a8 \u09b6\u09be\u09ae\u09c0\u09ae Microsoft Project \u098f\u09b0 \u0986\u0993\u09a4\u09be\u09df \u09aa\u09cd\u09b0\u0995\u09b2\u09cd\u09aa \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 \u09b8\u09c7\u0987 \u09aa\u09cd\u09b0\u0995\u09b2\u09cd\u09aa\u09c7\u09b0 \u0986\u0993\u09a4\u09be\u09df \u0986\u09ac\u09be\u09b0 \u09ac\u09bf\u09ad\u09bf\u09a8\u09cd\u09a8 \u0995\u09be\u099c \u09ac\u09be \u099f\u09be\u09b8\u09cd\u0995 \u0995\u09b0\u09be \u09af\u09be\u09df\u0964 \u098f\u09b0\u0995\u09ae \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09be \u099f\u09be\u09b8\u09cd\u0995\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09b8\u09be\u09a7\u09be\u09b0\u09a3\u09a4 \u09a8\u09be\u09ae, \u09b8\u09ae\u09df, \u09b6\u09c1\u09b0\u09c1\u09b0 \u09b8\u09ae\u09df, \u09b6\u09c7\u09b7 \u09b9\u0993\u09df\u09be\u09b0 \u09b8\u09ae\u09cd\u09ad\u09be\u09ac\u09cd\u09af \u09b8\u09ae\u09df , \u09a7\u09be\u09b0\u09be \u0987\u09a4\u09cd\u09af\u09be\u09a6\u09bf \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u0995\u09b0\u09c7 \u09a6\u09c7\u09df\u09be \u09af\u09be\u09df\u0964 \u098f \u09a7\u09b0\u09a3\u09c7\u09b0 \u0995\u09be\u099c\u09c7 \u09aa\u09c2\u09b0\u09cd\u09ac\u09c7\u09b0 \u0985\u09ad\u09bf\u099c\u09cd\u099e\u09a4\u09be\u2026","rel":"","context":"In &quot;\u09aa\u09cd\u09b0\u0995\u09b2\u09cd\u09aa \u09a8\u09bf\u09df\u09a8\u09cd\u09a4\u09cd\u09b0\u09a3 \u0964 Project Management (PMP) Basics&quot;","block_context":{"text":"\u09aa\u09cd\u09b0\u0995\u09b2\u09cd\u09aa \u09a8\u09bf\u09df\u09a8\u09cd\u09a4\u09cd\u09b0\u09a3 \u0964 Project Management (PMP) Basics","link":"http:\/\/bangla.sitestree.com\/?cat=187"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":62563,"url":"http:\/\/bangla.sitestree.com\/?p=62563","url_meta":{"origin":68479,"position":1},"title":"Microsoft Project and Project Management #PMP &#8211; Project Management","author":"Author-Check- Article-or-Video","date":"May 17, 2021","format":false,"excerpt":"First of all, you need to understand project management concepts. Check our articles on Project Management Concepts Also, check our training videos on project management You can create projects in Microsoft project. Then you can create tasks under each project For tasks you can provide name, duration, start date, finish\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":68483,"url":"http:\/\/bangla.sitestree.com\/?p=68483","url_meta":{"origin":68479,"position":2},"title":"Access 2007: How to #90","author":"Author-Check- Article-or-Video","date":"August 4, 2021","format":false,"excerpt":"Access 2007: How toHow to compact and repair database?File menu (Alt+F) -> Manage -> Compact and Repair Database. Why? To reduce file\/database size. Helpful - when you want to upload to a remote server. Compacting and Repairing databases many times can solve many database issues. Use the feature once in\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14819,"url":"http:\/\/bangla.sitestree.com\/?p=14819","url_meta":{"origin":68479,"position":3},"title":"Tools : Regression: Data Science and Analytics:","author":"Sayed","date":"June 19, 2019","format":false,"excerpt":"Online Multiple Linear Regression http:\/\/www.xuru.org\/rt\/mlr.asp --- How to Identify the Most Important Predictor Variables in Regression Models https:\/\/blog.minitab.com\/blog\/adventures-in-statistics-2\/how-to-identify-the-most-important-predictor-variables-in-regression-models --- How to Interpret Regression Analysis Results: P-values and Coefficients https:\/\/blog.minitab.com\/blog\/adventures-in-statistics-2\/how-to-interpret-regression-analysis-results-p-values-and-coefficients --- Why You Need to Check Your Residual Plots for Regression Analysis: Or, To Err is Human, To Err Randomly is\u2026","rel":"","context":"In &quot;AI ML DS RL DL NN NLP Data Mining Optimization&quot;","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69111,"url":"http:\/\/bangla.sitestree.com\/?p=69111","url_meta":{"origin":68479,"position":4},"title":"What is Hibernate? What does it mean to J2EE developers #48","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"What is Hibernate? What does it mean to J2EE developersHibernate is an open source free Java package that provides easy and efficient ways to deal with relational databases. Hibernate gives the abstraction that your databases contain just objects rather than tables. You manipulate objects to insert data or to get\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70025,"url":"http:\/\/bangla.sitestree.com\/?p=70025","url_meta":{"origin":68479,"position":5},"title":"OOP concepts in PHP 5 in brief #16","author":"Author-Check- Article-or-Video","date":"August 23, 2021","format":false,"excerpt":"OOP concepts in PHP 5 in short Why this short - note? if you are familiar with OOD and any OOP language such as Java\/C++, this short note will give you enough information to start with PHP 5 OOP Class Class definition starts with the keyword class, followed by a\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68479"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/68479\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68479"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}