VBA Access Intermediate Course #Introduction#vba#forms#tables#properties#project#management#system

VBA MS Access Intermediate Course

Lesson 1. Introduction to VBA Programming
1.1 What is a programming language?
1.2 MS Access Objects
Lesson 2. Forms, Tables and Reports Properties
2.1. Edits
2.2. Filter
2.3. Caption
2.4. Requery
2.5. Recordsource
2.6. Scroll
2.7. Visible
Lesson 3. Procedures, Comments, Run Procedures
3.1 Sub Routine
3.2 Functions
3.3 Adding Comments
Lesson 4. Manipulating Database Objects in VBA
4.1 Command Button
4.2 Open Form
4.3 Open Report
4.4 Open Table
4.5 Open Query
4.6 Close Objects
4.7 Quit
4.8 Beep
4.9 Print
4.10 Warning
Lesson 5. Defining Variables, Constants, and Calculations
5.1 Types
5.2 Dim
5.3 Scope
5.4 Static
5.5 Mathematical Operators
5.6 Msg
5.7 Array
5.8 Obj
Lesson 6. CRUD - Create, Read, Update and Delete
6.1. Create - Add Data
6.2. Read - display all, find, move, count
a. ShowEach
b. Move MoveFirst, MoveLast, MoveNext, MovePrevious
c. Count and Summarize data
d. GetProperty
e. Find FindFirst, FindLast, FindNext, FindPrevious
6.3. Update - edit data
6.4. Delete - data
6.5. Close - close record set
Lesson 7. Adding logic - for loop, each loop, while loop, do until, if, case
7.1 For Next
7.2 Each Loop
7.3 While Loop
7.4 Do until
7.5 If
7.6 Case
Lesson 8. Capstone Project
8.1 Obtain Understanding on the processes of a Residential Leasing Business
8.2 Obtain Understanding on the Basic Reporting Requirements
8.3 Obtain Understanding on the tables and relationships
8.4 Design a User Friendly Graphical User Interface
8.5 Develop a Property Management System