【Lynda】Up and Running with VBA in Access【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公, ◇ 编程与开发

==========教程信息=====================================================
教程名称:Up and Running with VBA in Access
作者:Curt Frye
主题:Business, Developer
使用软件:Access 2003, 2007, 2010, Visual Basic for Applications
难度等级:高级
时长: 4h 38m
发布日期: Oct 06, 2011

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Up and Running with VBA in Access[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 What you should know before watching this course.srt
│ └─◇ 0003 Using the exercise files.srt
├─◆1. Automating Processes Using Macros
│ └─◇ 0101 Introducing Access Automation.srt
│ └─◇ 0102 Running macros.srt
│ └─◇ 0103 Working with data macros.srt
│ └─◇ 0104 Running a macro by clicking a command button.srt
│ └─◇ 0105 Managing macro security settings.srt
├─◆2. Introducing Visual Basic for Applications (VBA)
│ └─◇ 0201 Introducing object-oriented programming.srt
│ └─◇ 0202 Examining the Access Object Model.srt
│ └─◇ 0203 Working in the Visual Basic Editor.srt
│ └─◇ 0204 Creating, exporting, and deleting code modules.srt
│ └─◇ 0205 Creating a subroutine.srt
│ └─◇ 0206 Creating a function.srt
│ └─◇ 0207 Adding comments to your code.srt
│ └─◇ 0208 Running a VBA procedure.srt
├─◆3. Debugging Your VBA Code
│ └─◇ 0301 Managing errors in VBA code using On Error statements.srt
│ └─◇ 0302 Stepping through a subroutine or function.srt
│ └─◇ 0303 Setting breakpoints in your code.srt
│ └─◇ 0304 Verifying output using temporary message boxes.srt
│ └─◇ 0305 Watching a value in a routine.srt
├─◆4. Defining Variables, Constants, and Calculations
│ └─◇ 0401 Introducing Access data types.srt
│ └─◇ 0402 Declaring variables and requiring declaration before use.srt
│ └─◇ 0403 Managing variable scope.srt
│ └─◇ 0404 Defining constants and static variables.srt
│ └─◇ 0405 Creating a calculation using mathematical operators.srt
│ └─◇ 0406 Displaying a calculated result in a message box.srt
│ └─◇ 0407 Defining an array.srt
│ └─◇ 0408 Defining and using an object variable.srt
├─◆5. Adding Logic to Your VBA Code
│ └─◇ 0501 Repeating a task using a For…Next loop.srt
│ └─◇ 0502 Stepping through all items of a collection using a For…Each loop.srt
│ └─◇ 0503 Repeating a task using a Do…While loop.srt
│ └─◇ 0504 Repeating a task using a Do…Until loop.srt
│ └─◇ 0505 Performing a task when conditions are met using an If…Then statement.srt
│ └─◇ 0506 Selecting actions using a Case statement.srt
├─◆6. Manipulating Database Objects Using DoCmd
│ └─◇ 0601 Opening a form.srt
│ └─◇ 0602 Opening a report.srt
│ └─◇ 0603 Opening a table.srt
│ └─◇ 0604 Opening a query.srt
│ └─◇ 0605 Closing an object.srt
│ └─◇ 0606 Closing a database or quitting Access.srt
│ └─◇ 0607 Sounding beeps and displaying the hourglass cursor.srt
│ └─◇ 0608 Running a menu command.srt
│ └─◇ 0609 Printing the active database object.srt
│ └─◇ 0610 Displaying or hiding warnings.srt
├─◆7. Reading and Manipulating Table Data
│ └─◇ 0701 Displaying every row in a table (Recordset).srt
│ └─◇ 0702 Adding a new record to a table.srt
│ └─◇ 0703 Editing values in an existing table row.srt
│ └─◇ 0704 Preserving data integrity using transactions.srt
│ └─◇ 0705 Displaying a table property using the TableDef object.srt
│ └─◇ 0706 Closing a Recordset.srt
│ └─◇ 0707 Deleting the current record.srt
│ └─◇ 0708 Finding records within a table.srt
│ └─◇ 0709 Moving within a Recordset.srt
│ └─◇ 0710 Counting the records in a Recordset.srt
├─◆8. Manipulating a Database Using the Application Object
│ └─◇ 0801 Summarizing values in a table field.srt
│ └─◇ 0802 Finding the first or last value in a table field.srt
│ └─◇ 0803 Looking up a value in a table field.srt
│ └─◇ 0804 Create a progress bar using the SysCmd object.srt
├─◆9. Controlling Forms and Reports Using the Me Object
│ └─◇ 0901 Allowing or disallowing additions, deletions, and edits.srt
│ └─◇ 0902 Manipulating form filters.srt
│ └─◇ 0903 Setting the caption and background picture.srt
│ └─◇ 0904 Requerying and repainting forms.srt
│ └─◇ 0905 Discovering a record source.srt
│ └─◇ 0906 Setting the ScrollBars property.srt
│ └─◇ 0907 Rendering a form or reporting visible or invisible.srt
├─◆Conclusion
│ └─◇ Additional resources and final thoughts.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

标签:

您的留言是我最大的支持!

你必须登录才能发表评论!

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com