Courses

    Pages & Posts

      • IT Training
        • Amazon Cloud (AWS)
        • Analytics and Big Data
        • Blockchain
        • Cisco
        • Citrix
        • Cloud Computing
        • CompTIA Certification
        • Cybersecurity
        • Deep Learning and AI
        • Development Tools
        • DevOps
        • F5
        • FlexPod
        • IBM
        • IT Security
        • Java
        • Juniper Networks
        • Linux
        • Microsoft
        • Mobile Computing
        • NetApp
        • Oracle
        • Salesforce
        • VMware
        • Web Development, HTML, and JavaScript
        • WebSphere
      • Business Training
        • Business Analysis
        • Enterprise Architecture
        • HIPAA Certification & Training
        • IT Governance
        • ITIL® Certification
        • Project Management
        • Salesforce
        • Scrum & Agile
        • Seminars
      • Services
        • APM Practice
        • Authorized Cisco Training
        • BPM Practice
        • Cloudera Training
        • Distance Learning
        • ITIL Certification
        • Linux Certification Training
        • Media Security Solutions
        • Microsoft 365
        • Microsoft Official Courses On Demand
        • Microsoft Professional Program
        • NetApp Training
        • NIST Cybersecurity Framework
        • Salesforce Training
        • Training Facilities
        • Visual Studio TFS Training
        • Enterprise Training Solutions
        • Room Rentals
        • State & Local Government
      • Student Resources
        • Navigating Babbage Simmel Academy Courses
        • Ohio Workforce Training Voucher Program
        • Student Guide / Daily Schedule
        • College Credits / Tuition Reimbursement
        • Career Programs (WIA)
        • Student Policies
        • Testing & Certifications
        • Promotions
        • Local Hotels
        • Local Restaurants
      • Microsoft Access 2013 Programming with VBA

      Course Details

      Download PDF
      M-AP13
      3 Days
      $1,295.00
      Request a Course Date

      Microsoft Access 2013 Programming with VBA

      Share this course

      Tweet Share
      ​Access Programming with VBA class teaches students how to examine and plan an application. Topics covered include automating forms, creating custom toolbars and menu bars, working with VBA code, and advanced VBA programming.
      • Course Outline
      • Audience

      Course Outline

      Lesson 1: Designing an Application Examining the components of an application Identifying the objectives of an application Resolving design issues in an application Planning application objects Lesson 2: Automating Forms Examining the properties of a dialog box Examining the properties of controls on a dialog box Examining and creating a macro group Attaching a macro group to command buttons Discussing VBA Examining the VBE window Examining a command button code Programming a button on a form to open another form Disabling and enabling command buttons Lesson 3: Working with Switchboard and Splash Screen Forms Creating a Switchboard form by using the Switchboard Manager Testing Switchboard objects Modifying a Switchboard form Observing a Splash Screen form Creating a Splash Screen form Setting label properties Setting the properties of a Splash Screen form Displaying the Splash Screen form on database startup Displaying the Splash Screen form for a specified time Opening a Switchboard form automatically after the Splash Screen form Lesson 4: Creating Custom Toolbars and Menu Bars Creating a macro group to show or hide a toolbar Replacing the built-in toolbar with a custom toolbar Adding buttons to a custom toolbar Examining a custom menu bar Creating a custom menu bar Adding commands to a custom menu bar Creating a custom shortcut menu Setting startup properties for toolbars, menus, and Access Special Keys Lesson 5: Working with VBA Code Discussing data types Using variables and constants Examining the Code window Examining a VBA code Creating a Sub procedure in a standard module Calling a Sub procedure Creating a Function procedure in a standard module Calling a Function procedure Lesson 6: Working with Advanced VBA Programming Using the If…Then statement Using the If…Then…Else statement Using the If…Then…ElseIf statement Using the For…Next loop Using the Do While…loop Assigning event handling code to a text box Assigning event handling code to a combo box Assigning event handling code to coordinate events across two forms Assigning the Undo event procedure for a form Assigning the Unload event procedure to a form Adding error-handling code Testing an error-handling code Adding a Web browser control to a form Displaying a Web site on the form Creating an MDE file

      Audience

      Students that have completed Access Level 1, Access Level 2 and Access Level 3 or possess equivalent knowledge and are looking to advance further in Microsoft Access 2013.

      Related Courses

      Microsoft Access 2013 Level 1...

      In Access 2013 Level 1 students learn the basic skills and concepts needed to us...

      View course details

      Microsoft Access 2013 Level 2...

      You will apply database optimization concepts to a simple database, enforce refe...

      View course details

      Microsoft Access 2013 Level 3...

      In Microsoft Access 2013 Level 3 students will learn advanced features of Access...

      View course details

      College Credit, CEUs, PDUs and CDUs
      When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

      College Credit
      Select curriculum offered by Babbage Simmel is part of the accredited Ashland University undergraduate course catalogs. For questions please E-Mail: info@babsim.com or call 614-481-4345.

      Continuing Education Units (CEUs)
      Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: info@babsim.com or call 614-481-4345.

      Professional Development Units (PDUs)
      Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.

      Continuing Development Units (CDUs)
      CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.

      Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.

      About Us Contact Us Blog Find A Course

      © Copyright 2019 • Babbage Simmel. All Rights Reserved. Columbus Web Design by Jetpack | Privacy Policy