Overview:
The Microsoft Access VBA programming short course teaches in-depth Microsoft Access VBA programming techniques that enable the developer to go beyond capabilities offered by basic Access usage and smooth out the rough edges that Access leaves behind.
Pre-Requisites:
Working knowledge of MS Access; basic programming as taught in VBA in Excel.
Course Curriculum
| Introduction and overview | |||
| The Visual Basic Editor Details | 00:00:00 | ||
| Standard modules and class modules Details | 00:00:00 | ||
| Attaching buttons to forms and writing VBA procedures and functions Details | 00:00:00 | ||
| Code generated by Command Button wizards Details | 00:00:00 | ||
| Error handling code Details | 00:00:00 | ||
| Debugging your programs by stepping through code and using the Immediate window. Details | 00:00:00 | ||
| VBA | |||
| Basic programming with variables and data type Details | 00:00:00 | ||
| If statements Details | 00:00:00 | ||
| VBA’s inbuilt functions Details | 00:00:00 | ||
| Use Access objects to write programs to control Forms and Reports Details | 00:00:00 | ||
| Transferring data to and from Excel and other databases Details | 00:00:00 | ||
| Importing text files Details | 00:00:00 | ||
| Placing advanced controls on Forms (subforms, combo boxes, toggle buttons, list boxes) and creating programs for their events Details | 00:00:00 | ||
| An introduction to Access SQL | |||
| Select statements; Group By clauses Details | 00:00:00 | ||
| Update, Insert and Delete statements Details | 00:00:00 | ||
| Joins and Union queries Details | 00:00:00 | ||
| The three types of loop that are used to make programs repeat commands (Do loops, For loops, For Each loops) Details | 00:00:00 | ||
| Programming the DAO, the object model that is intrinsic to Access, with an emphasis on Recordsets Details | 00:00:00 | ||
| Programming the ADO (Active X Data Objects), a component of Microsoft’s universal data access strategy, including ADO recordsets Details | 00:00:00 | ||
| Connecting Access to other applications in both directions using OLE Automation and ADO, for example create an Excel chart from Access data. Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED