{"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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1917],"tags":[],"class_list":["post-68479","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"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":66338,"url":"http:\/\/bangla.sitestree.com\/?p=66338","url_meta":{"origin":68479,"position":5},"title":"J2EE Architecture: J2EE Design Patterns: Related Concepts #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 18, 2021","format":false,"excerpt":"Design Patterns What are design patterns? Design patterns are specific\/(context-based) solutions\/approaches to address specific problems\/situations. Some problems are general\/open problems and very common problems in a particular type of applications. Design patterns can be created to solve such problems in a specific context and that can be re-used every time\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":[]}],"jetpack_featured_media_url":"","_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}]}}