Advanced Access VBA
9/24/2020 - 9/25/2020COURSE LENGTH:
9:00am - 4:30pm
This 2-day instructor led course is for advanced Access VBA students.
Students will work with Data, Create Schema, Data Manipulation, Other Data files and Other Applications
AUDIENCE AND PREREQUISITES
With Microsoft Access VBA you will learn Visual Basic for Applications (VBA). VBA is a superset of the Visual Basic command syntax and a rich assortment of functions with the capability to control objects in your application.
With the information provided you will explore commands, functions, properties, and methods and how to use them.
You will learn the two main ways to get at data: Data Access Objects (DAO) and ActiveX Data Objects (ADO). You will learn object models as they apply to the Access Connectivity Engine (ACE), the database engine under the hood of Access. You will learn advanced topics of database analysis, such as retrieving a list of all relationships in your database or discovering all the computers that are connected to your database.
Access Database Users and Analysis. Students who took Access Programming with VBA Introduction.
Course is subject to minimum enrollment. Courseware is not included in the course cost. For more information on costs, please contact: email@example.com
Menus, Navigation, and Ribbon Introduction to Menus Creating Form-Based Menus Managing the Navigation Pane Using Custom RibbonsApplication Collections Understanding application Collections Retrieving Lists of Objects Working with Object Properties Programmatically Determining Dependencies Case Study-Version ControlWorking with Data / Object Models for Working with Data What they Are and Why We Need Them Data Access Objects ActiveX Data Objects ActiveX Data Objects Extensions for Data Definition Object Model SelectionCreating Schema Overview Creating Databases Using DAO & ADOX Object Model Creating Tables Creating Fields Creating Indexes Creating Relationships Creating Queries Case Study - Updating an Existing Database InstallationData Manipulation Connecting to a Data Source Opening a Recordset Inserting Data Finding Data Updating Data Deleting Data Case Study / Backing Up DataAdvanced Data Operations Creating Linked Tables Data Definition Language Schema Recordsets SubqueriesWorking with Other Data Files Understanding File I/O Opening Files Reading from Files Writing to Files Printing to Files Case Study - Using ini FilesWorking with Other Applications Understanding Automation Setting Object References Creating Objects Working with Automation Servers Case Study - Using Excel ChartsWorking with XML Files Understanding XML Using Export XML Using Import XMLUsing the Windows API Declaring API Calls Using API Calls API Calls You Can Use from Access Knowing When to Use the Windows API Case Study - Capturing a Filename to Use for ProcessingA Review of Access SQL Introduction to SQL SQL Structure and Syntax The Select Statement The Insert Statement The Update Statement The Select Into Statement The Delete Statement Crosstabs