MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Up and Running with VBA in Access

Course Summary

  Introduces object-oriented programming and provides a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language.   


  • +

    Course Syllabus

     Introduction

    Welcome
    What you should know before watching this course
    Using the exercise files
    1. Automating Processes Using Macros
    Introducing Access Automation
    Running macros
    Working with data macros
    Running a macro by clicking a command button
    Managing macro security settings
    2. Introducing Visual Basic for Applications (VBA)
    Introducing object-oriented programming
    Examining the Access Object Model
    Working in the Visual Basic Editor
    Creating, exporting, and deleting code modules
    Creating a subroutine
    Creating a function
    Adding comments to your code
    Running a VBA procedure
    3. Debugging Your VBA Code
    Managing errors in VBA code using On Error statements
    Stepping through a subroutine or function
    Setting breakpoints in your code
    Verifying output using temporary message boxes
    Watching a value in a routine
    4. Defining Variables, Constants, and Calculations
    Introducing Access data types
    Declaring variables and requiring declaration before use
    Managing variable scope
    Defining constants and static variables
    Creating a calculation using mathematical operators
    Displaying a calculated result in a message box
    Defining an array
    Defining and using an object variable
    5. Adding Logic to Your VBA Code
    Repeating a task using a For...Next loop
    Stepping through all items of a collection using a For...Each loop
    Repeating a task using a Do...While loop
    Repeating a task using a Do...Until loop
    Performing a task when conditions are met using an If...Then statement
    Selecting actions using a Case statement
    6. Manipulating Database Objects Using DoCmd
    Opening a form
    Opening a report
    Opening a table
    Opening a query
    Closing an object
    Closing a database or quitting Access
    Sounding beeps and displaying the hourglass cursor
    Running a menu command
    Printing the active database object
    Displaying or hiding warnings
    7. Reading and Manipulating Table Data
    Displaying every row in a table (Recordset)
    Adding a new record to a table
    Editing values in an existing table row
    Preserving data integrity using transactions
    Displaying a table property using the TableDef object
    Closing a Recordset
    Deleting the current record
    Finding records within a table
    Moving within a Recordset
    Counting the records in a Recordset
    8. Manipulating a Database Using the Application Object
    Summarizing values in a table field
    Finding the first or last value in a table field
    Looking up a value in a table field
    Create a progress bar using the SysCmd object
    9. Controlling Forms and Reports Using the Me Object
    Allowing or disallowing additions, deletions, and edits
    Manipulating form filters
    Setting the caption and background picture
    Requerying and repainting forms
    Discovering a record source
    Setting the ScrollBars property
    Rendering a form or reporting visible or invisible
    Conclusion
    Additional resources and final thoughts
     


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

5 - 6 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top