Enhance productivity by automating routine tasks and providing custom
functionality not built into Access with a few basics in VBA code.
Author Curt Frye introduces object-oriented programming and provides
database designers with a foundation in the Access object model and the
Visual Basic for Applications (VBA) programming language. The course
covers automating tasks with macros, working in the Visual Basic Editor,
writing functions, adding logic, reading data, controlling forms, and
more.
Topics include:
- Working with macros and managing macro security settings
- Creating, exporting, and deleting code modules
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Creating conditional statements
- Manipulating database objects, such as forms, tables, and queries
- Adding, editing, and deleting records
- Looking up values in a table
- Requerying and repainting forms
Table of content
- Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Automating Processes Using Macros
- Introducing Access Automation
- Running macros
- Working with data macros
- Running a macro by clicking a command button
- Managing macro security settings
- Introducing Visual Basic for Applications (VBA)
- Introducing object-oriented programming
- Examining the Access Object Model
- Working in the Visual Basic Editor
- Creating, exporting, and deleting code modules
- Creating a subroutine
- Creating a function
- Adding comments to your code
- Running a VBA procedure
- Debugging Your VBA Code
- Managing errors in VBA code using On Error statements
- Stepping through a subroutine or function
- Setting breakpoints in your code
- Verifying output using temporary message boxes
- Watching a value in a routine
- Defining Variables, Constants, and Calculations
- Introducing Access data types
- Declaring variables and requiring declaration before use
- Managing variable scope
- Defining constants and static variables
- Creating a calculation using mathematical operators
- Displaying a calculated result in a message box
- Defining an array
- Defining and using an object variable
- Adding Logic to Your VBA Code
- Repeating a task using a For…Next loop
- Stepping through all items of a collection using a For…Each loop
- Repeating a task using a Do…While loop
- Repeating a task using a Do…Until loop
- Performing a task when conditions are met using an If…Then statement
- Selecting actions using a Case statement
- Manipulating Database Objects Using DoCmd
- Opening a form
- Opening a report
- Opening a table
- Opening a query
- Closing an object
- Closing a database or quitting Access
- Sounding beeps and displaying the hourglass cursor
- Running a menu command
- Printing the active database object
- Displaying or hiding warnings
- Reading and Manipulating Table Data
- Displaying every row in a table (Recordset)
- Adding a new record to a table
- Editing values in an existing table row
- Preserving data integrity using transactions
- Displaying a table property using the TableDef object
- Closing a Recordset
- Deleting the current record
- Finding records within a table
- Moving within a Recordset
- Counting the records in a Recordset
- Manipulating a Database Using the Application Object
- Summarizing values in a table field
- Finding the first or last value in a table field
- Looking up a value in a table field
- Create a progress bar using the SysCmd object
- Controlling Forms and Reports Using the Me Object
- Allowing or disallowing additions, deletions, and edits
- Manipulating form filters
- Setting the caption and background picture
- Requerying and repainting forms
- Discovering a record source
- Setting the ScrollBars property
- Rendering a form or reporting visible or invisible
- Conclusion
- Additional resources and final thoughts
Rapidgator.net
- bit.ly/1l1IPoM
No comments:
Post a Comment