Home > Store > Data > Access

Access 2013 Development LiveLessons (Video Training)

Downloadable Video

  • Your Price: $119.99
  • List Price: $149.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 1

Access as a Development Tool, Downloadable Version

In this section you will learn about the appropriate uses for Microsoft Access. During that process you will discover the types of applications that you can build with Microsoft Access. Lesson 1.1: Why Microsoft Access? Lesson 1.2: What Types of Applications Can I Build with Microsoft Access?

Duration: 00:06:43  File Size: 17 MB

Lesson 2

VBA: The Basics, Downloadable Version

Lesson 2 provides you with a solid foundation of the VBA language. Although you may already be familiar with the VBA language, you may find that reviewing some of the topics covered in the section might be useful. Topics covered include working with variables, parameters, control structures, and much more. Let’s take a look. Lesson 2.1: What Types of Modules are Available? Lesson 2.2: Working with Variables Lesson 2.3: Working with Constants Lesson 2.4: Adding Comments to Your Code Lesson 2.5: Using the Line Continuation Character Lesson 2.6: Using VBA Control Structures Lesson 2.7: Passing Parameters and Returning Values Lesson 2.8: Executing Procedures in the Code Window Lesson 2.9: The DoCmd Object: Performing Macro Actions Lesson 2.10: Working with Built-In Functions Lesson 2.11: Using Built-In Dialog Boxes Lesson 2.12: Editor Tips and Tricks

Duration: 01:00:29  File Size: 176 MB

Lesson 3

Objects, Properties, Methods, and Events Explained, Downloadable Version

In Lesson 3 you get a strong foundation of working with objects, properties, methods, and events. As with Lesson 2, this is a foundational section. But, even if you are more advanced, you may find it useful to review the process of working with collections, passing objects to functions, and many other important techniques. Let’s get started. Lesson 3.1: Understanding Access’s Object Model Lesson 3.2: Understanding Objects, Properties, Events, and Methods Lesson 3.3: Referring to Objects Lesson 3.4: Declaring and Assigning Object Variables Lesson 3.5: Differences Between Objects and Collections Lesson 3.6: Passing Objects to Subroutines and Functions Lesson 3.7: Determining the Type of a Control Lesson 3.8: Special Properties That Refer to Objects

Duration: 00:32:00  File Size: 131 MB

Lesson 4

Debugging: Your Key to Successful Development, Downloadable Version

In Lesson 4 you learn how to effectively debug the applications that you build. I find that some wiz-bang programmers are ineffective, simply because they are uncomfortable using the Access debugger. In this section you learn everything there is to know about debugging, including working with breakpoints, the watch window, and watch expressions. Let’s debug! Lesson 4.1: Avoiding Bugs Lesson 4.2: Harnessing the Power of the Immediate Window Lesson 4.3: Using Breakpoints to Troubleshoot Lesson 4.4: Stepping Through Code Lesson 4.5: Setting the Next Statement to Execute Lesson 4.6: Using the Call Stack Window Lesson 4.7: Working with the Locals Window Lesson 4.8: Working with the Watch Window

Duration: 00:30:47  File Size: 78 MB

Lesson 5

Error Handling: Preparing for the Inevitable, Downloadable Version

Most of us would like to avoid errors entirely, but unfortunately, at one point or another, errors happen. Fortunately Lesson 5 can help you out. In the section we cover not only foundational topics such as On Error statements and Resume statements, but you will leave the section with a complete custom error handler that you can use with your own applications. Let’s error-handle. Lesson 5.1: Implementing Error Handling Lesson 5.2: Using On Error Statements Lesson 5.3: Using Resume Statements Lesson 5.4: The Cascading Error Effect Lesson 5.5: Raising an Error Lesson 5.6: Using the Errors Collection Lesson 5.7: Creating a Generic Error Handler Lesson 5.8: Preventing Your Own Error Handling from Being Invoked

Duration: 00:28:41  File Size: 95 MB

Lesson 6

What Are ActiveX Data Objects and Data Access Objects and Why Are They Important? Downloadable Vers

In Lesson 6 you learn an extensive amount about both DAO (data access objects) and ADO (activex data objects). You learn how to manipulate and modify data, and how to modify table structures, using both DAO and ADO. After viewing this section you will feel fluent in the use of both object models. Let’s get started. Lesson 6.1: DAO versus ADO — When to Use Each Lesson 6.2: The Data Access Object Model Lesson 6.3: Getting to Know DBEngine Lesson 6.4: Using CurrentDB() Lesson 6.5: Working with DAO Recordset Types Lesson 6.6: DAO Recordset Properties and Methods Lesson 6.7: Using DAO Code to Modify Table Data Lesson 6.8: Using DAO Code to Modify Database Objects Lesson 6.9: Examining the ADO Object Model Lesson 6.10: Working with Connections Lesson 6.11: Working with ADO Recordset Types Lesson 6.12: ADO Recordset Properties and Methods Lesson 6.13: Using ADO Code to Modify Table Data Lesson 6.14: Using ADO Code to Modify Database Objects

Duration: 00:58:05  File Size: 201 MB

Lesson 7

Advanced Form Techniques, Downloadable Version

In Lesson 7, explore advanced form techniques. You will not only delve into many form events, but you will see many practical examples of what you are learning. Let’s see what techniques are available for forms. Lesson 7.1: Form Events and When To Use Them? Lesson 7.2: Order of Events for Forms Lesson 7.3: Utilizing Section and Control Events Lesson 7.4: Taking Advantage of Built-In Form-Filtering Features Lesson 7.5: Switching a Form’s Record Source Lesson 7.6: Power Combo Box and List Box Techniques Lesson 7.7: Synchronizing a Form with Its Underlying Recordset

Duration: 00:40:42  File Size: 146 MB

Lesson 8

Advanced Report Techniques, Downloadable Version

In Lesson 8 we cover advanced report techniques. You learn about many report events. More importantly, you will see many practical examples of how you can use those events in your own applications. Let’s see what techniques are available for reports. Lesson 8.1: Report Events and When to Use Them Lesson 8.2: Order of Events for Reports Lesson 8.3: Practical Applications of Report Techniques

Duration: 00:20:51  File Size: 91 MB

Lesson 9

Advanced Query Techniques, Downloadable Version

In Lesson 9 we cover advanced query techniques. We begin with a foundation of the SQL language. We follow that up with a tour of the many special types of queries available to you including self join, union queries, and subqueries. Let’s see what techniques are available for queries. Lesson 9.1: Self-Joins Lesson 9.2: Union Queries Lesson 9.3: Subqueries Lesson 9.4: The Propagation of Nulls and Query Results Lesson 9.5: Using User-Defined Functions with Queries

Duration: 00:16:40  File Size: 49 MB

Lesson 10

Macro Basics, Downloadable Version

Although you may not to build an entire application using macros, you should consider using macros in certain situations. Lesson 10 covers the basics of designing and working with macros. You learn about submacros, program flow, embedded macros, and more. Open your mind, and join me on a tour of macros. Lesson 10.1: The Basics of Creating and Running a Macro Lesson 10.2: Harness the Power of Submacros Lesson 10.3: Control your Macros Using Program Flow Lesson 10.4: Run a Macro from the Macros Group of the Navigation Pane Lesson 10.5: Trigger a Macro from a Form or Report Event Lesson 10.6: Modify an Existing Macro Lesson 10.7: Create an Embedded Macro

Duration: 00:26:25  File Size: 116 MB

Lesson 11

Advanced Macro Techniques, Downloadable Version

If you are at all convinced that macros may be the best solution in specific situations, Lesson 11 is for you. In Lesson 11 you learn important macro techniques such as how to create data macros, drillthrough macros, and autoexec macros. Let’s have some fun with macros. Lesson 11.1: Create Data Macros Lesson 11.2: Create a Drillthrough Macro Lesson 11.3: Learn What Other New Features Are Available in Macros Lesson 11.4: Debug a Macro Lesson 11.5: Convert a Macro to VBA Code Lesson 11.6: Create an AutoExec Macro

Duration: 00:25:46  File Size: 107 MB

Lesson 12

Advanced VBA Techniques, Downloadable Version

Whereas Lesson 2 provided you with a foundation of the VBA language, Lesson 12 steps it up enormously with the coverage of advanced VBA techniques. Included in this section is the coverage of arrays, advanced function techniques, nulls, and advanced collection techniques. Let’s forge ahead into advanced VBA techniques. Lesson 12.1: Working with Arrays Lesson 12.2: Advanced Function Techniques Lesson 12.3: Working with Empty and Null Lesson 12.4: Creating and Working with Custom Collections

Duration: 00:27:30  File Size: 96 MB

Lesson 13

Exploiting the Power of Class Modules, Downloadable Version

Class modules are extremely powerful. Using them, you can take your applications to a new level. Lesson 13 teaches you everything you need to know about working with class modules. Let’s enter the exciting world of class modules. Lesson 13.1: Creating and Using a Class Module Lesson 13.2: Creating Multiple Class Instances Lesson 13.3: More About Class Modules Lesson 13.4: Class Modules in Use

Duration: 00:41:23  File Size: 126 MB

Lesson 14

Using External Data, Downloadable Version

In Lesson 14 you will learn how to utilize data stored in other formats. Not only will you see how to use code to import data, you will also learn how to programmatically link to external data. Let’s see how Access interfaces with external data. Lesson 14.1: Using Code to Import External Data Lesson 14.2: Using Code to Link to External Data Lesson 14.3: Refreshing and Removing Links

Duration: 00:12:56  File Size: 46 MB

Lesson 15

Automation: Communicating with Other Applications, Downloadable Version

Lesson 15 is one of my favorites. In this section you will learn to automate other applications from Access. During our tour of automation, you will learn how to interface with Excel, Word, PowerPoint, and Outlook. It’s time to get familiar with these important techniques. Lesson 15.1: Creating an Automation Object Lesson 15.2: Controlling Excel from Access Lesson 15.3: Closing an Excel Automation Object Lesson 15.4: Creating a Graph from Access Lesson 15.5: Controlling Word from Access Lesson 15.6: Controlling PowerPoint from Access Lesson 15.7: Controlling Outlook from Access

Duration: 00:33:45  File Size: 117 MB

Lesson 16

Exploiting the Power of the Windows API, Downloadable Version

In Lesson 16 you learn how to exploit the power of the Windows API. Windows has a rich set of functions available to you if you know how to use them. In this section, you’ll see how you can declare and use Windows functions. As with many other sections, this section includes practical examples that you can use in your own applications. Let’s see how it all works. Lesson 16.1: Declaring a Windows API Function Lesson 16.2: Using a Windows API Function Lesson 16.3: Getting Information About the Operating Environment Lesson 16.4: Determining Drive Information

Duration: 00:12:53  File Size: 48 MB

Lesson 17

Developing Client/Server Applications, Downloadable Version

In Lesson 17 you learn how to use Access to build client/server applications. Many people think this is impossible, but I have proven them wrong over and over again with the success of my clients’ applications. You will learn how to make the decision as to whether to go client/server. You will also learn all of the techniques that you need to know to build a successful client/server application. Let’s get rollin'! Lesson 17.1: Understanding the Client/Server Model Lesson 17.2: Deciding Whether to Use the Client/Server Model Lesson 17.3: Roles Access Plays in the Application Design Model Lesson 17.4: Defining an ODBC Data Source Lesson 17.5: Upsizing an existing Access Database Lesson 17.6: Working with Linked Tables Lesson 17.7: Working with SQL Server Views Lesson 17.8: Using Pass-Through Queries Lesson 17.9: Executing Stored Procedures Lesson 17.10: Working with SQL User-Defined Functions Lesson 17.11: Building Client/Server Friendly Forms Lesson 17.12: Building Client/Server Friendly Reports

Duration: 01:06:21  File Size: 234 MB

Lesson 18

Working With and Customizing Ribbons, Downloadable Version

The ribbon was introduced with Access 2007. In Lesson 18, you learn how to customize the ribbon. You’ll learn how to apply your custom ribbon to the entire database, or to specific forms and reports. You’ll even learn how to run macros from a ribbon button. Let’s have some fun with ribbons! Lesson 18.1: Customizing the Ribbon Lesson 18.2: Applying a Custom Ribbon when a Database Opens Lesson 18.3: Associating a Custom Ribbon with a Form or Report Lesson 18.4: Executing a Macro from a Ribbon

Duration: 00:18:30  File Size: 62 MB

Lesson 19

Putting it All Together ? A Complete Application, Downloadable Version

In Lesson 19, you learn how to put everything that you learned together to build a complete application. In this section, we’ll design the tables, forms, queries, reports, macros, and modules needed as part of our sample application. Let’s finish thinks off with a bang! Lesson 19.1: Designing the Tables to Store Your Data Lesson 19.2: Building the Queries to Extract the Data You Need Lesson 19.3: Building the Forms to Edit Your Data Lesson 19.4: Designing the Reports to Display Your Data Lesson 19.5: Building the Macros Necessary to Automate Your Application Lesson 19.6: Polishing Off Your Application with the Necessary VBA Code

Duration: 00:18:07  File Size: 66 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2014
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-5239-5
  • ISBN-13: 978-0-7897-5239-0

Access 2013 Development LiveLessons (Video Training)

9+ Hours of Video Instruction

                                                                                                         

Learn everything you need to know in order to build powerful and robust Access applications!

                                                                                                   

• Start-to-finish personal training on Access 2013 Development: just watch and learn!

• Simple, quick video walkthroughs of the tasks you perform most often!

• Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!

                               

These video lessons will ensure that you can harness the power of Access for development faster and more easily than ever before! In 19 thorough parts, Access 2013 Development LiveLessons shows you how to increase add finesse and polish to your databases so they look like the pros. Expert Alison Balter simplifies powerful features and tools so you can truly harness the power built into Access! Just watch: You’ll master high-powered skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Access 2013 Development fast!

Bestselling author and trainer Alison Balter provides the novice programmer with 9+ hours of hands-on step-by-step video training on the fundamentals of creating Access applications. Packed with real-world examples on how to put Access to use in everyday programming, you'll start with the basics, and learn how to build applications at your own pace.

1              Access as a Development Tool

2              VBA: The Basics 

3              Objects, Properties, Methods, and Events

4              Debugging: Your Key to Successful Development

5              Error Handling: Preparing for the Inevitable

6              What Are ActiveX Data Objects and Data Access Objects and Why Are They Important?

7              Advanced Form Techniques

8              Advanced Report Techniques

9              Advanced Query Techniques 

10           Macro Basics 

11           Advanced Macro Techniques

12           Advanced VBA Techniques 

13           Exploiting the Power of Class Modules

14           Using External Data

15           Automation: Communicating with Other Applications

16           Exploiting the Power of the Windows API

17           Developing Client/Server Applications

18           Working With and Customizing Ribbons

19           Putting it All Together – A Complete Application

Section 1 provides you with an overview of what Access has to offer and why you would want to use it. Sections 2 through 5 allow you to develop your existing skills of working with the VBA language, Access objects, debugging, and error handling. Section 6 immerses you in a plethora of DAO and ADO techniques. Then you will move onto sections 7, 8, and 9, where you further your form, report, and query techniques. Sections 10 and 11 teach you everything you’d ever want to learn about macros. In sections 12 through 16, delve into special topics such as class modules, external data, automation, and the Windows API. Then, in section 17, learn how to build client/server applications. Finally, finish with ribbons and a section called “Putting it All Together”.

All of the lessons offer practical examples that will help you to benefit from what you are learning. You can easily take what you learn and implement it immediately in your real-life databases!

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more.  View all LiveLessons from Que Publishing at:

http://www.quepublishing.com/imprint/series_detail.aspx?st=87397

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 27 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, University of Southern California, Massachusetts Institute of Technology, and others.

Alison specializes in teaching others how to develop Windows and Web applications. She is a leading author of 15 Microsoft Access books and SQL Server books, including Alison Balter’s Mastering Access 2003 Development, Alison Balter’s Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, Using Access 2010, and Access 2013 Absolute Beginners Guide. Alison is also featured in several training videos for both SAMS and Experts Exchange.

Most recently, Alison was given the honor of Microsoft Access MVP 2012, an honor bestowed on a select few individuals who have donated their time to bettering the development community. She was also selected as 2012/2013 Ventura County Woman Business Owner of the Year. Alison can be reached at alison@techismything.com.

Downloads

Downloads

Download the companion files

Sample Content

Table of Contents

Part 1     Access as a Development Tool 

1         Why Microsoft Access?

2         What Types of Applications Can I Build with Microsoft Access?

Part 2     VBA: The Basics

3         What Types of Modules are Available?

4         Working with Variables

5         Working with Constants

6         Adding Comments to Your Code

7         Using the Line Continuation Character

8         Using VBA Control Structures

9         Passing Parameters and Returning Values

10      Executing Procedures in the Code Window

11      The DoCmd Object: Performing Macro Actions

12      Working with Built-In Functions

13      Using Built-In Dialog Boxes

14      Editor Tips and Tricks

Part 3     Objects, Properties, Methods, and Events Explained

15      Understanding Access’s Object Model

16      Understanding Objects, Properties, Events, and Methods

17      Referring to Objects

18      Declaring and Assigning Object Variables

19      Differences Between Objects and Collections

20      Passing Objects to Subroutines and Functions

21      Determining the Type of a Control

22      Special Properties That Refer to Objects

Part 4     Debugging: Your Key to Successful Development

23      Avoiding Bugs

24      Harnessing the Power of the Immediate Window

25      Using Breakpoints to Troubleshoot

26      Stepping Through Code

27      Setting the Next Statement to Execute

28      Using the Call Stack Window

29      Working with the Locals Window

30      Working with the Watch Window

Part 5     Error Handling: Preparing for the Inevitable

31      Implementing Error Handling

32      Using On Error Statements

33      Using Resume Statements

34      The Cascading Error Effect

35      Raising an Error

36      Using the Errors Collection

37      Creating a Generic Error Handler

38      Preventing Your Own Error Handling from Being Invoked

Part 6     What Are ActiveX Data Objects and Data Access Objects and Why Are They Important?

39      DAO versus ADO – When to Use Each

40      The Data Access Object Model

41      Getting to Know DBEngine

42      Using CurrentDB()

43      Working with DAO Recordset Types

44       DAO Recordset Properties and Methods

45      Using DAO Code to Modify Table Data

46      Using DAO Code to Modify Database Objects

47      Examining the ADO Object Model

48      Working with Connections

49      Working with ADO Recordset Types

50      ADO Recordset Properties and Methods

51      Using ADO Code to Modify Table Data

52      Using ADO Code to Modify Database Objects

Part 7     Advanced Form Techniques

53      Form Events and When To Use Them?

54      Order of Events for Forms

55      Utilizing Section and Control Events

56      Taking Advantage of Built-In Form-Filtering Features

57      Switching a Form’s Record Source

58      Power Combo Box and List Box Techniques

59      Synchronizing a Form with Its Underlying Recordset

Part 8     Advanced Report Techniques

60      Report Events and When to Use Them

61      Order of Events for Reports

62      Practical Applications of Report Techniques

Part 9     Advanced Query Techniques

63      Self-Joins

64      Union Queries

65      Subqueries

66      The Propagation of Nulls and Query Results

67      Using User-Defined Functions with Queries

Part 10     Macro Basics

68      The Basics of Creating and Running a Macro

69      Harness the Power of Submacros

70      Control your Macros Using Program Flow

71      Run a Macro from the Macros Group of the Navigation Pane

72      Trigger a Macro from a Form or Report Event

73      Modify an Existing Macro

74      Create an Embedded Macro

Part 11     Advanced Macro Techniques

75      Create Data Macros

76      Create a Drillthrough Macro

77      Learn What Other New Features Are Available in Macros

78      Debug a Macro

79      Convert a Macro to VBA Code

80      Create an AutoExec Macro

Part 12     Advanced VBA Techniques

81      Working with Arrays

82      Advanced Function Techniques

83      Working with Empty and Null

84      Creating and Working with Custom Collections

Part 13     Exploiting the Power of Class Modules

85      Creating and Using a Class Module

86      Creating Multiple Class Instances

87      More About Class Modules

88      Class Modules in Use

Part 14     Using External Data

89      Using Code to Import External Data

90      Using Code to Link to External Data

91      Refreshing and Removing Links

Part 15     Automation: Communicating with Other Applications

92      Creating an Automation Object

93      Controlling Excel from Access

94      Closing an Excel Automation Object

95      Creating a Graph from Access

96      Controlling Word from Access

97      Controlling PowerPoint from Access

98      Controlling Outlook from Access

Part 16     Exploiting the Power of the Windows API

99      Declaring a Windows API Function

100   Using a Windows API Function

101   Getting Information About the Operating Environment

102   Determining Drive Information

Part 17     Developing Client/Server Applications

103   Understanding the Client/Server Model

104   Deciding Whether to Use the Client/Server Model

105   Roles Access Plays in the Application Design Model

106   Defining an ODBC Data Source

107   Upsizing an existing Access Database

108   Working with Linked Tables

109   Working with SQL Server Views

110   Using Pass-Through Queries

111   Executing Stored Procedures

112   Working with SQL User-Defined Functions

113   Building Client/Server Friendly Forms

114   Building Client/Server Friendly Reports

Part 18     Working With and Customizing Ribbons

115   Customizing the Ribbon

116   Applying a Custom Ribbon when a Database Opens

117   Associating a Custom Ribbon with a Form or Report

118   Executing a Macro from a Ribbon

Part 19     Putting it All Together – A Complete Application

119   Designing the Tables to Store Your Data

120   Building the Queries to Extract the Data You Need

121   Building the Forms to Edit Your Data

122   Designing the Reports to Display Your Data

123   Building the Macros Necessary to Automate Your Application

124   Polishing Off Your Application with the Necessary VBA Code

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership