Access Basic Programming

Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

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

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

Attend and You Will Learn
Lesson 1: GETTING STARTED
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 Lesson 2: WORKING WITH PROCEDURES AND FUNCTIONS
Understanding procedures

Creating a sub procedure

Creating a function procedure

Calling procedures and functions

Using the immediate window

Working with code Lesson 3: OBJECTS, PROPERTIES, METHODS, AND EVENTS
Understanding objects and collections

Understanding properties

Understanding methods

Understanding events Lesson 4: 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 Lesson 5: USING VARIABLES, ARRAYS, AND CONSTANTS
Declaring variables

Declaring arrays

Declaring constants

Declaring object variables Lesson 6: USING FUNCTIONS, MESSAGE BOXES, AND INPUT BOXES
Using intrinsic functions

Using message boxes

Using input boxes Lesson 7: 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 Lesson 8: 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 ...''

Phone:919.515.8163

School Address:

Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA

Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh

Word 2007
Excel Programming
Excel Macros
Excel
Access Application Development
Access Boot Camp
Crystal Reports Level I
Crystal Reports Level II
Microsoft Project
Relational Database
Visio
Acrobat
AutoCAD
Illustrator
InDesign

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.