Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. To begin learning today, simply click on the movie links.

Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formateur : Robert Ekblaw
Langue : Anglais
Durée : 7
Nombre de séquences vidéo : 79
SKU : 34363
Réf :
ISBN : 978-1-61866-058-9
Date de publication : 2012-08-24
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :

Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. To begin learning today, simply click on the movie links.

Robert Ekblaw

Robert Ekblaw is a professor in the Computer Science department at the University at Albany, part of the State University of New York. He has been a business and financial coach for over twenty years, specializing in computer-based tools to help organize and manage projects, people, and resources. He has taught thousands of people how to program and use computer applications. For twelve years he headed Breakthrough Consulting Services, one of the most highly-respected computer consulting companies in the Metropolitan New York City area.

Plan de formation

  • Form and Record Navigation

    • (05:01)
      Record Navigation Buttons
    • (05:11)
      DoCmd Object
    • (06:01)
      Record Navigation Events
    • (03:58)
      Adding New Records
    • (04:19)
      Form Operation Events
    • (04:33)
      Report Operation Events
    • (04:15)
      Sample Navigation
  • Collections and User-Defined Data Types

    • (05:23)
      Creating Composite Data Types
    • (04:23)
      Declaring Variables of Composite Types
    • (04:39)
      Accessing Data in Composite Types
    • (05:38)
      Nested Types
    • (05:29)
      Dynamic Arrays
    • (04:59)
      Collections
    • (05:27)
      Creating a Collection
    • (04:32)
      Searching a Collection
    • (05:59)
      Sample Collection
  • VBA and Form Objects

    • (04:22)
      Checkbox
    • (04:59)
      Option Buttons
    • (05:38)
      VBA Code for Option Groups
    • (04:36)
      List Box Single Selection
    • (05:18)
      List Box Multiple Selection
    • (04:49)
      Filling List Box
    • (04:50)
      Sample Data Fill
  • Embedded SQL

    • (04:44)
      What Embedded SQL Is
    • (05:45)
      SELECT Statement
    • (05:13)
      WHERE Clause
    • (04:45)
      Computed Fields
    • (05:24)
      SQL Summation Functions
    • (05:07)
      SQL Row Limitation Functions
    • (04:30)
      Sample Query
    • (04:29)
      Sorting Results
    • (06:06)
      Grouping Results
    • (02:36)
      Sample Gathering
    • (06:15)
      Joins
    • (04:09)
      Sample Join
    • (06:46)
      Action Queries
  • Recordsets

    • (05:01)
      What a Recordset Is
    • (05:55)
      Creating a Recordset
    • (05:51)
      Opening Recordsets
    • (04:53)
      Recordset Navigation
    • (05:33)
      Finding Records
    • (05:21)
      Reading and Updating Records
    • (06:19)
      Adding and Deleting Records
    • (05:45)
      Snapshot Recordsets
    • (06:27)
      Sample Recordset
    • (03:08)
      Sample Recordset Use
    • (05:33)
      Sample Recordset Find
  • Classes

    • (07:01)
      What a Class Is
    • (05:06)
      Defining a Class and Data
    • (06:27)
      Class Properties
    • (05:27)
      Class Methods
    • (03:44)
      Initialize Method
    • (04:27)
      Sample Class Design
    • (04:33)
      Sample Class Code
  • Databases

    • (06:46)
      Database Object
    • (07:05)
      Connection Object
    • (06:32)
      Using Remote Databases
    • (05:58)
      Referencing Remote Databases
    • (04:22)
      Using Data from a Remote Database
  • Conclusion

    • (05:45)
      Course Wrap Up
    • (05:59)
      Planning for Events
    • (06:00)
      Navigation Forms
  • Credits

    • (05:28)
      About the Author