Loading...

Course Description

Learn how to create powerful applications using Access. You will explore programming constructs such as objects, arrays, functions, and debugging.

See specific content information below in the "Attend and You Will Learn" section.

Who Should Attend

This class is geared towards experienced Access users who are interested in programming with the Visual Basic language.

Attend and You Will Receive

Participants who successfully complete this course will receive a certificate of completion from NC State University

Prerequisites

Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.

Attend and You Will Learn / Expected Outcome

Attend and You Will Learn

Getting Started Functions

  • Introduction to programming in Access
  • Why program in Access?
  • Creating a macro
  • Understanding modules
  • Creating a standard module
  • Understanding the development environment
  • Using the Project Explorer
  • Using the Properties Window
  • Using the Code Window

 Working with Procedures and Functions

  • Understanding procedures
  • Creating a sub procedure
  • Creating a function procedure
  • Calling procedures and function
  • Working with code

Objects, Properties, Methods and Events

  • Understanding objects and collections
  • Understanding properties
  • Understanding methods
  • Understanding events

Understanding the Access Object Hierarchy

  • Understanding access objects
  • Using the object browser
  • Controlling the application object
  • Understanding the forms collection and form object
  • Understanding the controls collection and control object
  • Using the "with" statement
  • Understanding the reports collection and report object
  • Understanding the DoCmd object
  • Using the screen object

Using Variables, Arrays and Constants

  • Declaring variables
  • Declaring arrays
  • Declaring constants
  • Declaring object variables

Using Functions, Message Boxes and Input Boxes

  • Using intrinsic functions
  • Using message boxes
  • Using input boxes

Controlling Program Execution

  • Using control structures
  • Working with conditional expressions
  • Using the If...Then...End If structure
  • Using the If...Then...Else...End If structure
  • Using the select case...End select structure
  • Using the Do...Loop structure
  • Using the For...Next structure

Debugging Code

  • Understanding errors
  • Using debugging tools
  • Stepping through code and setting break points
  • Understanding error events
  • Understanding the err object
  • Using the On Error statement
  • Writing an Error handling routine
  • Compiling all procedures

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Access Programming
Type
In-Class
Days
T, W
Time
9:00AM to 4:30PM
Dates
Dec 08, 2020 to Dec 09, 2020
Schedule and Location
Contact Hours
12.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $545.00
Instructors