Course

Course Summary
Credit Type:
Course
ACE ID:
NEWH-0001
Organization:
New Horizons Computer Learning Centers--Anaheim, CA
Location:
Classroom-based
Length:
7 hours (1 day)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 1 Microcomputer Applications
Note: Student must successful complete both Intermediate Access and Advanced Access to receive credit for this course. Students receiving credit for Access 2.0 courses are ineligible to receive credit for Access 7.0 or Access 97 courses.
Description

Objective:

To provide advanced knowledge of Access 2.0 features needed to create macros and use modules.

Learning Outcomes:

  • Run a macro
  • Add a macro shortcut
  • Use Access basic help
  • Use the immediate window
  • Set a breakpoint
  • Use a module function in a form
  • Write user-defined functions
  • Use if-then-else statements
  • Use select case-end select statements
  • Use do-while loop statements
  • Run a macro from an event
  • Create a macro
  • Use the DoMenuItem action
  • Make a macro button
  • Construct decision-making macros
  • Run a macro from a macro
  • Explore the module window
  • Edit module syntax
  • Use for-next loops
  • Use access SQL statements
  • Use the menu builder
  • Add a graph to a form
Instruction & Assessment

Instructional Strategies:

  • Classroom Exercise
  • Discussion
  • Lectures
Supplemental Materials