Get the most out of Microsoft Access with VBA

Contents

• Introduction Introduction

  • Get the most out of Microsoft Access with VBA

    25s
  • What you should know

    1m 38s
• 1. Introduction to Visual Basic for Applications 1. Introduction to Visual Basic for Applications

  • (Locked)
    Introduction to object-oriented programming

    1m 59s
  • (Locked)
    Examine the Access object model

    4m 57s
  • (Locked)
    Work in the Visual Basic Editor

    3m 52s
  • (Locked)
    Create, export, and delete code modules

    5m 47s
  • Create a subroutine

    5m
  • (Locked)
    Create a function

    5m 26s
  • (Locked)
    Add comments to your code

    4m 15s
  • (Locked)
    Run a VBA procedure

    5m 7s
• 2. Define Variables, Constants, and Calculations 2. Define Variables, Constants, and Calculations

  • (Locked)
    Introduction to Access data types

    3m 53s
  • (Locked)
    Declare variables and require declaration before using

    5m 28s
  • Manage variable scope

    4m 47s
  • (Locked)
    Define constants and static variables

    7m 23s
  • (Locked)
    Create a calculation using mathematical operators

    4m 57s
  • (Locked)
    Display a calculated result in a message box

    4m 2s
  • (Locked)
    Define an array

    7m 12s
  • (Locked)
    Define and use an object variable

    3m 57s
• 3. Add Logic to Your VBA Code 3. Add Logic to Your VBA Code

  • (Locked)
    Repeat a task using a For…Next loop

    5m 5s
  • (Locked)
    Step through all items of a collection using a For…Each loop

    4m 59s
  • (Locked)
    Repeat a task using a Do…While loop

    5m 32s
  • (Locked)
    Perform a task when conditions are met using an If…Then statement

    6m 20s
  • Select actions using a Case statement

    6m 17s
• 4. Debug Your VBA Code 4. Debug Your VBA Code

  • (Locked)
    Manage errors in VBA code using On Error statements

    6m 32s
  • (Locked)
    Step through a subroutine or function

    5m 16s
  • (Locked)
    Set breakpoints in your code

    3m 48s
  • (Locked)
    Verify output using the Immediate window

    7m 11s
  • (Locked)
    Watch a value in a routine

    4m 53s
• 5. Manipulate Database Objects Using DoCmd 5. Manipulate Database Objects Using DoCmd

  • (Locked)
    Open a form

    4m 6s
  • (Locked)
    Open a report

    4m 29s
  • (Locked)
    Open a table

    3m 30s
  • (Locked)
    Open a query

    3m 59s
  • (Locked)
    Close an object

    6m 36s
  • (Locked)
    Close a database or quit Access

    3m 34s
  • Run a menu command

    3m 17s
  • (Locked)
    Print the active database object

    3m 21s
  • (Locked)
    Display or hide warnings

    4m 26s
• 6. Read and Manipulate Table Data 6. Read and Manipulate Table Data

  • (Locked)
    Display every row in a table (recordset)

    5m 20s
  • (Locked)
    Add a new record to a table

    5m 54s
  • (Locked)
    Edit values in an existing table row

    4m 21s
  • (Locked)
    Preserve data integrity using transactions

    7m 37s
  • (Locked)
    Display a table property using the TableDef object

    5m 20s
  • (Locked)
    Close a recordset

    3m 8s
  • (Locked)
    Delete the current record

    5m 28s
  • Find records within a table

    6m 37s
  • (Locked)
    Move within a recordset

    4m 52s
  • (Locked)
    Count the records in a recordset

    5m 26s
• 7. Manipulate a Database Using the Application Object 7. Manipulate a Database Using the Application Object

  • (Locked)
    Summarize values in a table field

    3m 2s
  • (Locked)
    Find the first or last value in a table field

    2m 22s
  • Look up a value in a table field

    3m 56s
  • (Locked)
    Create a progress bar using the SysCmd object

    4m 15s
• 8. Control Forms and Reports Using the Me Object 8. Control Forms and Reports Using the Me Object

  • (Locked)
    Allow or disallow additions, deletions, and edits

    3m 39s
  • (Locked)
    Manipulate form filters

    3m 19s
  • (Locked)
    Set the caption and background picture

    4m 38s
  • (Locked)
    Requery and repaint forms

    4m 1s
  • (Locked)
    Discover a record source

    2m 26s
  • (Locked)
    Render a form or report visible or invisible

    2m 30s
• 9. Automate Processes Using Macros 9. Automate Processes Using Macros

  • (Locked)
    Introduction to Access macros and data macros

    1m 28s
  • (Locked)
    Create macros

    2m 14s
  • (Locked)
    Work with data macros

    4m 6s
  • (Locked)
    Run a macro by clicking a command button

    4m 11s
  • (Locked)
    Manage macro security settings

    2m 44s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 7s