در این آموزش تصویری با برنامه نویسی مقدماتی VBA در Access آشنا می شوید.
این دوره آموزشی محصول موسسه Udemy است.

سرفصل های دوره:

  • آشنایی با Access و برنامه نویسی با VBA
  • نحوه ایجاد ماکرو ها در Microsoft Access
  • ایجاد ماکرو در برنامه نویسی VBA
  • نمونه ای از Access Macro
  • نحوه تبدیل ماکروها به VBA
  • آشنایی با VBE
  • نحوه دسترسی به Visual Basic Editor
  • کار با VBA Windows
  • کار با نوار ابزارها
  • حذف و اضافه کردن ماژول ها
  • نحوه نامگذاری ماژول ها
  • نحوه انتخاب رمز عبور از کد VBA
  • نحوه نوشتن VBA
  • نحوه برنامه نویسی در VBA
  • کار با برنامه نویسی شی گرا
  • کار با ساختار توابع
  • کار با مجموعه ها
  • کار با متغیرها ، انواع داده و اپراتورها
  • نحوه اعلان متغیر
  • اهمیت انواع داده
  • کار با عملگرهای محاسباتی
  • نحوهالحاق رشته
  • کار با آرایه ها
  • کار با توابع رشته ای مانند UCase و LCase
  • کار با تابع INSTR
  • کار با تابع Day ، Month و Year
  • نحوه استفاده از عبارات
  • نحوه قالب بندی زمان و تاریخ
  • استفاده از عملکرد FormatCurrency
  • کار اب تابع FormatNumber
  • استفاده از عملکرد FormatDateTime
  • بررسی رویدادها
  • کار اب رویدادهای ماوس
  • کار با رویدادهای صفحه کلید
  • مقدمه ای بر DoCmd
  • شناخت روش SendObject
  • کار با دستورات شرطی
  • و…

عنوان دوره: Udemy Access VBA Beginners Blueprint to Programming Access VBA
مدت زمان: 5 ساعت و 30 دقیقه
نویسنده: IsBel Harrison


توضیحات:

Udemy Access VBA Beginners Blueprint to Programming Access VBA

IsBel Harrison
5.5 Hours
All Levels

Learn Access VBA Within Your Comfort Zone.
Choose Access VBA when simple tables, forms, or reports just won't do. ..
When Macros aren't quite enough. ..
And when creating your own applications from scratch is overkill. ..
Are you experienced with Access, but not with VBA programming?
This course introduces VBA programming concepts with easy to follow examples, and lessons.
First, you will learn the difference between Macros and VBA, and create a simple Macro.
Then you will get familiar with the Visual Basic Editor, your home for programming Access, and basic concepts of Visual Basic for Applications.
During this course you will learn VBA concepts that you can apply to your job, and add functionality to your Access databases:
Get comfortable with the Visual Basic Editor (VBE)
Learn the essentials of writing VBA code
Learn about the powerful DoCmd object
Create branching decision structures
Create user interactions forms, like message boxes, and input boxes
DAO recordsets
Debug your code, and handle errors
What to know before you enroll:
You will have unlimited, lifetime access to the course!
You will have instant, and free access to any updates I add to the course.
Don't forget, you are covered by a 30 day money back guarantee.
Get started programming VBA for your Access databases today.
What are the requirements?
Access 2007, 2010, 2013, 2016
To get the most out of this course, you should have working knowledge of Microsoft Access databases
What am I going to get from this course?
Over 139 lectures and 5.5 hours of content!
UNDERSTAND why you would want to use VBA in Access Databases
KNOW the differences between Macros and VBA
CREATE a simple Macro in Access
NAVIGATE comfortably in the Visual Basic Editor
LEARN the essentials of writing Access VBA code
PROGRAM command buttons
CREATE decision structures
CREATE user interaction dialog boxes, like message boxes and input boxes
DEBUG your VBA code
LEARN how to handle errors
USE built in String, Date, and Format functions
What is the target audience?
The Beginning Access VBA Programmer
Programmers of other languages that would like a good tutorial
Anyone who is responsible for working with Access databases
Anyone wanting to know more about Access VBA

Lecture 1
Welcome!
01:48
Welcome to Access VBA: Beginner's Blueprint to Programming Access VBA.
IsaBel Harrison | Udemy.com
Section 1: Creating Macros in Microsoft Access
Lecture 2
Creating Macros vs. Programming in VBA
02:14
Lecture 3
Example of an Access Macro
06:41
Lecture 4
Converting Macros to VBA
03:58
Section 2: Getting Familiar with the VBE (Visual Basic Editor)
Lecture 5
Accessing the Visual Basic Editor
01:13
Lecture 6
VBA Windows & Toolbars
06:31
Lecture 7
Option Compare and Option Explicit
1 page
Lecture 8
Adding and Removing Modules
01:22
Lecture 9
Exporting and Importing Modules
2 pages
Lecture 10
Naming Modules
01:31
Lecture 11
Options for Customizing the Visual Basic Editor
5 pages
Lecture 12
The Object Browser
1 page
Lecture 13
Password Protecting Your VBA Code
1 page
Lecture 14
A Few Time Savers When Writing VBA
02:59
Lecture 15
What to do When You Have Error in Your Code?
02:45
Lecture 16
Section Summary
Article
Section 3: Getting Started with Programming in VBA
Lecture 17
Object Oriented Programming
02:08
Lecture 18
How VBA Accesses an Object's Properties and Methods
01:38
Lecture 19
Working with Procedures
01:24
Lecture 20
Structure of Sub Procedures
02:07
Lecture 21
Structure of Functions
03:03
Lecture 22
Calling a Sub Procedure or Function
02:42
Lecture 23
Calling Procedures with the Same Name
Article
Lecture 24
Event Procedures
02:37
Lecture 25
Collections
Article
Lecture 26
Comments
03:27
You can use comments to make notes in your code. It is very helpful, and highly recommended.
Lecture 27
Section Summary
Article
Section 4: Getting to Know Variables, Data Types, and Operators
Lecture 28
Introduction
00:35
Lecture 29
Variable Declaration
03:57
Declaring a variable lets VBA know that you want to store a value in the computer's memory.
Lecture 30
The Importance of Data Types
03:09
Lecture 31
VBA's Built-in Data Types
1 page
Lecture 32
Using Identifier Type Characers to Declare Data Types
1 page
Lecture 33
About "Me"
01:30
Lecture 34
Declaring Constants
02:31
Lecture 35
Object Variables
03:58
Lecture 36
Arithmetic Operators
1 page
Arithmetic Operators
Lecture 37
Exercise: Arithmetic Operators
04:51
Lecture 38
Text Box Values
02:20
Lecture 39
String Concatenation
Article
Lecture 40
Exercise: String Concatenation
02:32
Lecture 41
The Line Continuation Operator
Article
Lecture 42
The Colon Operator
Article
Lecture 43
Carriage Return-Line Feed
01:22
Lecture 44
The With Statement
Article
Lecture 45
Controlling Access of Your Variables & Procedures with Scope
12:20
Lecture 46
Arrays
02:23
An explanation of Arrays used in VBA
Lecture 47
Test Your Skills
02:07
Lecture 48
Section Summary
Article
Section 5: Functions
Lecture 49
Introduction to Functions
00:18
Lecture 50
String Functions: Left, Right, and Mid
04:53
Lecture 51
String Functions: UCase, and LCase
00:40
Lecture 52
String Functions: InStr
04:02
Lecture 53
Date and Time Functions: Date, and Now
01:06
Lecture 54
Date and Time Functions: Day, Month, and Year
01:27
Lecture 55
Date and Time Functions: DateDiff
02:18
Lecture 56
Date and Time Functions: Time
00:26
Lecture 57
Date and Time Functions: Second, Minute, and Hour
00:57
Lecture 58
The Format Function: Using Named Format Expressions
01:52
Lecture 59
The Format Function: Creating Custom Number Formats
3 pages
Lecture 60
The Format Function: Creating Custom Date/Time Formatting
2 pages
Lecture 61
The Format Function: Creating Custom String Formats
1 page
Lecture 62
Using the FormatCurrency Function
02:40
Lecture 63
The FormatNumber Function
Article
Lecture 64
Using the FormatDateTime Function
1 page
Lecture 65
The FormatPercent Function
Article
Lecture 66
Test Your Skills
01:53
Section 6: Events Attached to Access Database Objects Explained
Lecture 67
Overview of Object Events
00:37
Lecture 68
Click Events
00:24
Lecture 69
Focus Events
00:47
Lecture 70
Mouse Events
00:28
Lecture 71
Keyboard Events
00:42
Lecture 72
Text box Events
00:34
Lecture 73
Combo box Events
00:36
Lecture 74
Form Events
2 pages
Lecture 75
Report Events
1 page
Lecture 76
Test Your Skills
01:29
Section 7: Introductions to DoCmd Methods
Lecture 77
Introduction to DoCmd
00:55
Lecture 78
DoCmd ApplyFilter
06:46
Lecture 79
DoCmd CopyObject
05:30
Lecture 80
DoCmd OpenForm
04:33
Lecture 81
DoCmd OpenReport
03:27
Lecture 82
DoCmd OpenTable
00:24
Lecture 83
DoCmd OutputTo
03:54
Lecture 84
DoCmd RunCommand
03:08
Lecture 85
Exercise: Creating an Outlook Contact
2 pages
Lecture 86
DoCmd RunSQL
03:47
Lecture 87
DoCmd SendObject
04:36
Learn how to e-mail objects with the SendObject method.
Lecture 88
DoCmd TransferDatabase
03:17
Lecture 89
DoCmd TransferSpreadsheet
02:47
Lecture 90
Section Summary
Article
Section 8: Decisions Structures
Lecture 91
The IF THEN Statement
07:21
Lecture 92
Exercise: The IF THEN Statement
2 pages