آموزش استفاده از VBA به منظور تبدیل فایل های Access به یک برنامه تمام عیار / InfiniteSkills Learning Visual Basic For Microsoft Access Training Video

InfiniteSkills Learning Visual Basic For Microsoft Access Training Video
آموزش استفاده از VBA به منظور تبدیل فایل های Access به یک برنامه تمام عیار

  • کاربرد : آموزش استفاده از VBA به منظور تبدیل فایل های Access به یک برنامه تمام عیار
  • نوع فایل : فیلم آموزشی
  • زبان : انگلیسی
  • سیستم عامل : Windows-Mac-Linux-Android-iOS
  • تولید کننده : InfiniteSkills
  • سال تولید : 2012

توضیحات

همانطور که می دانید در نرم افزار آفیس نوع خاصی از زبان Visual Basic تعبیه شده است که به VBA شهرت دارد و با استفاده از آن می توانید اقدام به برنامه نویسی کرده و از این طریق بسیاری از کارها را با سادگی بیشتری به انجام رسانید .

با مشاهده این کورس آموزشی استفاده از VBA به منظور تبدیل کردن فایل های دیتابیس Access به یک برنامه تمام عیار را خواهید آموخت .

Description

In this project-based Learning Visual Basic For Microsoft Access 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 Visual Basic For Microsoft Access 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 Visual Basic For Microsoft Access 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 Visual Basic For Microsoft Access tutorial, online or offline... so you'll know the exact steps for your own projects.

بخش های فایل

این فایل شامل 79 بخش می باشد که بخش های آن به صورت جداگانه در زیر آمده است.
Row Title Format Size Play Download
01. Introducing VBA For Access
1 01_01-Can I Really Become A Programmer 4.34 MB DOWNLOAD
2 01_02-About The Author 3.40 MB DOWNLOAD
3 01_03-Using The Working Files 5.53 MB DOWNLOAD
4 01_04-Initial Setup Of The Sample Databases Provided 7.00 MB DOWNLOAD
02. Moving From A Database To An Application
5 02_01-What Is VBA 10.45 MB DOWNLOAD
6 02_02-Where Is The VBA 11.08 MB DOWNLOAD
7 02_03-The VBA Editor Quick Tour 8.12 MB DOWNLOAD
8 02_04-The Editor - Explorer And Properties Windows 8.19 MB DOWNLOAD
9 02_05-The Editor - The Debug Window 8.54 MB DOWNLOAD
10 02_06-Macros Or VBA - Convert Your Macro To Code 10.32 MB DOWNLOAD
03. Programming In VBA
11 03_01-Getting Started With A Standard Module 6.81 MB DOWNLOAD
12 03_02-Creating A Procedure 8.05 MB DOWNLOAD
13 03_03-Adding Comments To Your Code 6.65 MB DOWNLOAD
14 03_04-VBA Data Types 8.49 MB DOWNLOAD
15 03_05-Declaring Parameters For Use In Procedures 12.96 MB DOWNLOAD
16 03_06-How To Declare Variables And Constants 15.28 MB DOWNLOAD
17 03_07-Creating And Assigning Array Values 13.59 MB DOWNLOAD
18 03_08-The Scope And Lifetime Of Variables 11.36 MB DOWNLOAD
19 03_09-Standard Naming Conventions For Variables 9.93 MB DOWNLOAD
20 03_10-Handling Multiple Line Commands 11.06 MB DOWNLOAD
21 03_11-The Very Useful Keyword - ME 9.05 MB DOWNLOAD
04. Repeating VBA Code
22 04_01-Do Loop 13.90 MB DOWNLOAD
23 04_02-While Wend 6.12 MB DOWNLOAD
24 04_03-For Next 14.38 MB DOWNLOAD
25 04_04-If Else End If 20.22 MB DOWNLOAD
26 04_05-The Very Flexible Select Case Statement 15.78 MB DOWNLOAD
05. Working With Access Objects
27 05_01-The Access Object Model 17.68 MB DOWNLOAD
28 05_02-Changing The Value Of Object Properties 11.83 MB DOWNLOAD
29 05_03-Access Special Object DoCmd 12.15 MB DOWNLOAD
30 05_04-Class Modules And Class Procedures 11.27 MB DOWNLOAD
31 05_05-Enable And Disable Controls 15.44 MB DOWNLOAD
32 05_06-Hide Or Show Form Controls 13.89 MB DOWNLOAD
33 05_07-Lock Unlock Controls 9.14 MB DOWNLOAD
34 05_08-Form Events To Trigger Procedures 14.68 MB DOWNLOAD
35 05_09-Setting Color Properties 18.54 MB DOWNLOAD
36 05_10-Defining Your Own Custom Colours 20.20 MB DOWNLOAD
37 05_11-Defining Font Properties Through Your Code 15.01 MB DOWNLOAD
38 05_12-With End With To Shorten Code Writing 8.72 MB DOWNLOAD
39 05_13-Assigning Values To Data Fields On A Form 15.61 MB DOWNLOAD
40 05_14-Opening A Form 13.35 MB DOWNLOAD
41 05_15-Open Form And Display Filtered Dataset 16.10 MB DOWNLOAD
42 05_16-Closing Any Open Form 15.13 MB DOWNLOAD
06. Data Manipulation
43 06_01-A Very Quick SQL Tour 10.74 MB DOWNLOAD
44 06_02-Running An Action Query As Code 11.56 MB DOWNLOAD
45 06_03-Stop Warnings On Action Queries When Run In VBA 10.13 MB DOWNLOAD
46 06_04-Building And Storing SQL In Variables 13.91 MB DOWNLOAD
47 06_05-Changing The Sql That Populates A List Or Combo Box 10.55 MB DOWNLOAD
48 06_06-Create A New Table 10.74 MB DOWNLOAD
49 06_07-Deleting (And Closing) A Table 13.03 MB DOWNLOAD
50 06_08-Adding Data To Tables Through Code 17.96 MB DOWNLOAD
51 06_09-The Recordset Explained 18.60 MB DOWNLOAD
52 06_10-How To Reference Fields In A Recordset 7.41 MB DOWNLOAD
53 06_11-Navigating Through The Rows Of A Recordset 8.81 MB DOWNLOAD
54 06_12-Closing Off A Recordset And ADODB Connection 7.24 MB DOWNLOAD
55 06_13-The Recordset In Action 29.89 MB DOWNLOAD
56 06_14-DCOUNT (Great Function) 14.09 MB DOWNLOAD
07. Interacting With The User
57 07_01-Getting Started With The MSGBOX 17.04 MB DOWNLOAD
58 07_02-Customizing The MSGBOX 15.53 MB DOWNLOAD
59 07_03-Reacting To The User Response In A MSGBOX 15.39 MB DOWNLOAD
60 07_04-Creating A Dialog Box 10.42 MB DOWNLOAD
61 07_05-Using A Dialog To Give Choices To Users 18.00 MB DOWNLOAD
62 07_06-Combo Box Dynamic List Building 15.03 MB DOWNLOAD
63 07_07-Excluding Values From The Combo Box List 8.44 MB DOWNLOAD
64 07_08-Using The Combo Box Selected Value 11.28 MB DOWNLOAD
65 07_09-Detecting The Right Mouse Click 17.35 MB DOWNLOAD
08. Combo And ListBox Specials
66 08_01-Combo Box And ListBox Properties 12.87 MB DOWNLOAD
67 08_02-Accessing And Setting Combo And Field List Properties 22.41 MB DOWNLOAD
68 08_03-Accessing Combo Box Fields From A Different Form 24.03 MB DOWNLOAD
69 08_04-List Box Search Application 10.24 MB DOWNLOAD
09. Functions
70 09_01-What Is A Function 5.88 MB DOWNLOAD
71 09_02-Creating A Custom Function 12.77 MB DOWNLOAD
72 09_03-A Proper ProperCase Function 18.95 MB DOWNLOAD
10. Testing, Error Handling And Debugging
73 10_01-The Three Types Of Errors 13.54 MB DOWNLOAD
74 10_02-Handling Logical Errors With Debug Print 13.22 MB DOWNLOAD
75 10_03-Handling Logical Errors With Breakpoints 16.06 MB DOWNLOAD
76 10_04-Creating Your Own Runtime Error Handler 15.54 MB DOWNLOAD
77 10_05-Specific Error Messages For Specific Errors 16.38 MB DOWNLOAD
11. And Finally
78 11_01-Locking The VBA From Prying Eyes 7.00 MB DOWNLOAD
79 11_02-So What's Next 4.87 MB DOWNLOAD
شما می توانید مجموعه کامل بخش های این فابل را نیز به صورت مجموعه کامل دریافت نمایید.
اگر شما نسبت به این اثر یا عنوان محق هستید، لطفا از طریق "بخش تماس با ما" با ما تماس بگیرید و برای اطلاعات بیشتر، صفحه قوانین و مقررات را مطالعه نمایید.

دیدگاه کاربران


لطفا در این قسمت فقط نظر شخصی در مورد این عنوان را وارد نمایید و در صورتیکه مشکلی با دانلود یا استفاده از این فایل دارید در صفحه کاربری تیکت ثبت کنید.

بارگزاری