آموزش برنامه نویسی اکسس Visual Basic&Access 2013

آموزش تصویری پاورپوینت PowerPoint 2013 Infiniteskills >>
آموزش برنامه نویسی اکسس Visual Basic&Access 2013
آموزش برنامه نویسی اکسس Visual Basic&Access 2013
نویسنده و تهیه کننده Infiniteskills
امتیاز جایزه: 0
قیمت: 0 تومان

Learning Visual Basic For Microsoft Access

Take your skills to the next level. This Learning Visual Basic For Microsoft Access Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.
These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace. These Learning Visual Basic For Microsoft Access Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.
Take your skills to the next level. This Learning Visual Basic For Microsoft Access Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.
These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.
These Learning Visual Basic For Microsoft Access Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.
Learn Visual Basic For Microsoft Access from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

Introducing VBA For Access
Moving From A Database To An Application
Programming In VBA
Repeating VBA Code
Working With Access Objects
Data Manipulation
Interacting With The User
Combo And ListBox Specials
Functions
Testing, Error Handling And Debugging
And Finally

Advanced Microsoft Access 2010 Training Video

A Practical Access Training Course That Teaches Real World Skills
In this project-based Advanced Microsoft Access 2010 video tutorial series, you'll quickly have relevant skills for real-world applications.
Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Advanced Microsoft Access 2010 training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Advanced Microsoft Access 2010 subjects because they're broken into simple, easy to follow tutorial videos
Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Advanced Microsoft Access 2010 tutorial, online or offline... so you'll know the exact steps for your own projects.

Getting Started
Advanced Table Design
Advanced Queries
Action Queries
Advanced Form Design
Advanced Reports
Macros
Database Utilities
Application Making And Security
Access With SQL Server
Summary

Microsoft Access 2010 Training Video

A Practical Access Training Course That Teaches Real World Skills
In this project-based Microsoft Access 2010 video tutorial series, you'll quickly have relevant skills for real-world applications.
Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Microsoft Access 2010 training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Microsoft Access 2010 subjects because they're broken into simple, easy to follow tutorial videos

Getting Started
Advanced Table Design
Advanced Queries
Action Queries
Advanced Form Design
Advanced Reports
Macros
Database Utilities
Application Making And Security
Access With SQL Server
Summary

Microsoft Access 2013 Training Video

A Practical Access Training Course That Teaches Real World Skills
In this project-based Microsoft Access 2010 video tutorial series, you'll quickly have relevant skills for real-world applications.
Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Microsoft Access 2010 training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Microsoft Access 2010 subjects because they're broken into simple, easy to follow tutorial videos

Database Theory And Design
Tables
Queries
Forms
Reports
Multiple Table Databases
Database Normalization
Advanced Tables
Advanced Select Queries
Action Queries
Advanced Forms
Advanced Reports
Custom Web Apps
Conclusion

LiveLessons – Access 2013 Development

1 Access as a Development Tool
Why Microsoft Access?
What Types of Applications Can I Build with Microsoft Access?
2 VBA: The Basics
What Types of Modules are Available?
Working with Variables
Working with Constants
Adding Comments to Your Code
Using the Line Continuation Character
Using VBA Control Structures
Passing Parameters and Returning Values
Executing Procedures in the Code Window
The DoCmd Object: Performing Macro Actions
Working with Built-In Functions
Using Built-In Dialog Boxes
Editor Tips and Tricks
3 Objects, Properties, Methods, and Events Explained
Understanding Access’s Object Model
Understanding Objects, Properties, Events, and Methods
Referring to Objects
Declaring and Assigning Object Variables
Differences between Objects and Collections
Passing Objects to Subroutines and Functions
Determining the Type of a Control
Special Properties That Refer to Objects
4 Debugging is Your Key to Successful Development
Avoiding Bugs
Harnessing the Power of the Immediate Window
Using Breakpoints to Troubleshoot
Stepping Through Code
Setting the Next Statement to Execute
Using the Call Stack Window
Working with the Locals Window
Working with the Watch Window
5 Error Handling: Preparing for the Inevitable
Implementing Error Handling
Using On Error Statements
Using Resume Statements
The Cascading Error Effect
Raising an Error
Using the Errors Collection
Creating a Generic Error Handler
Preventing Your Own Error Handling from Being Invoked
6 What Are ActiveX Data Objects and Data Access Objects and Why Are They Important?
DAO versus ADO — When to Use Each
The Data Access Object Model
Getting to Know DBEngine
Using CurrentDB()
Working with DAO Recordset Types
DAO Recordset Properties and Methods
Using DAO Code to Modify Table Data
Using DAO Code to Modify Database Objects
Examining the ADO Object Model
Working with Connections
Working with ADO Recordset Types
ADO Recordset Properties and Methods
Using ADO Code to Modify Table
Data Using ADO Code to Modify Database Objects
7 Advanced Form Techniques
Form Events and When to Use Them?
Order of Events for Forms
Utilizing Section and Control Events
Taking Advantage of Built-In Form-Filtering Features
Switching a Form’s Record Source
Power Combo Box and List Box Techniques
Synchronizing a Form with Its Underlying Recordset
8 Advanced Report Techniques
Report Events and When to Use Them
Order of Events for Reports
Practical Applications of Report Techniques
9 Advanced Query Techniques
self-Joins
Union Queries
Subqueries
The Propagation of Nulls and Query Results
Using User-Defined Functions with Queries
10 Macro Basics
The Basics of Creating and Running a Macro
Harness the Power of Submacros
Control your Macros Using Program Flow
Run a Macro from the Macros Group of the Navigation Pane
Trigger a Macro from a Form or Report Event
Modify an Existing Macro
Create an Embedded Macro
11 Advanced Macro Techniques
Create Data Macros
Create a Drillthrough Macro
Learn What Other New Features Are Available in Macros
Debug a Macro
Convert a Macro to VBA Code
Create an AutoExec Macro
12 Advanced VBA Techniques
Working with Arrays
Advanced Function Techniques
Working with Empty and Null
Creating and Working with Custom Collections
13 Exploiting the Power of Class Modules
Creating and Using a Class Module
Creating Multiple Class Instances
More about Class Modules
Class Modules in Use
14 Using External Data
Using Code to Import External Data
Using Code to Link to External Data
Refreshing and Removing Links
15 Automation: Communicating with Other Applications
Creating an Automation Object
Controlling Excel from Access
Closing an Excel Automation Object
Creating a Graph from Access
Controlling Word from Access
Controlling PowerPoint from Access
Controlling Outlook from Access
16 Exploiting the Power of the Windows API
Declaring a Windows API Function
Using a Windows API Function
Getting Information about the Operating Environment
Determining Drive Information
17 Developing Client/Server Applications
Understanding the Client/Server Model
Deciding Whether to Use the Client/Server Model
Roles Access Plays in the Application Design Model
Defining an ODBC Data Source
Upsizing an existing Access Database
Working with Linked Tables
Working with SQL Server Views
Using Pass-Through Queries
Executing Stored Procedures
Working with SQL User-Defined Functions
Building Client/Server Friendly Forms
Building Client/Server Friendly Reports
18 Working With and Customizing Ribbons
Customizing the Ribbon
Applying a Custom Ribbon when a Database Opens
Associating a Custom Ribbon with a Form or Report
Executing a Macro from a Ribbon
19 Putting it All Together — A Complete Application
Designing the Tables to Store Your Data
Building the Queries to Extract the Data You Need
Building the Forms to Edit Your Data
Designing the Reports to Display Your Data
Building the Macros Necessary to Automate Your Application
Polishing Off Your Application with the Necessary VBA Code

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 42:40
ویرایش 2013
نوع تصویری(Multimedia)
تعداد DVD 3
سطح مقدماتی-متوسط-پیشرفته
هزینه حمل دارد
اوپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2016