Luna Systems Courses

Luna Systems Course Outlines



Intro to Programming in Access	• Overview of Access • The Programming Environment • Difference Between Modules and CBF - Event procedures • The Anatomy of Code - Subs vs. Functions - Public vs. Private • Constants and Variables - Dim, Static, and Global Statements - Data Types - Arrays • Introduction to Object Variables Access Objects, DAO • Creating Custom Message and Dialog Boxes • Hungarian Naming Standard
Programming in Access Intermediate Level	• Creating Conditional Statements and Loops - If, Then, Else, Select Case, and Do Until • Working with Recordsets - Manipulating data with DAO - Passing variable parameters • Applying Properties and Methods to Objects - Controls, Forms, and Reports as objects • Data Access Objects - Workspaces, TableDefs, QueryDefs • Debugging and Error Handling - Using the Immediate Window

Developing Access Applications	• Develop an application from the ground up - brainstorming, table design, build a relationship model • Learn the 15 steps of Application Development • Develop a user interface - learn which features of form design to pay attention to and which to avoid - write code to automate data entry and search tasks • Develop management reports - create reports that grab attention (add charts and create an export to Microsocft Excel) • Learn the 6 steps of Troubleshooting • Add the finishing touches