Application Development with Microsoft Access 2007 LiveLessons (Video Training)

Application Development with Microsoft Access 2007 LiveLessons (Video Training)

By: Alison Balter (author)Mixed Media

Up to 2 WeeksUsually despatched within 2 weeks

Description

Application Development with Microsoft (R) Access 2007 Live Lessons Microsoft Access/Databases For Access power users, programmers, and anyone who wants to master Access 2007 development fast. In Application Development with Access 2007, renowned Access developer, trainer, and author Alison Balter teaches all the skills you need to build professional-quality Access 2007 applications. This package brings together more than twelve hours of personalized, expert video training: 100+ quick, practical video lessons that demonstrate all the skills you need to build virtually any Access application. You'll learn one step at a time, at your own pace-using hands-on examples that reflect realistic development challenges and showcase Access 2007's remarkable capabilities. Application Development with Access 2007 delivers the power of the best classroom training at a small fraction of the cost. If you don't have time to read a huge book on Access development, this is exactly what you've been searching for! Looking for a better way to master today's rapidly changing programming technologies? Want expert help, but don't have the time or energy to read a book? Can't find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world's leading technology experts. LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions-you'll learn key skills in as little as fifteen minutes! Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your instructor shows how to get results in today's top development environments: including Microsoft's Visual Studio and eclipse.org's Eclipse. "We are reaching more and more for video alternatives because they make sense! The imprints of Pearson Technology Group are the most trusted source of quality technology books, and they will be the brands we turn to for visual learning." -Leo J. Hauguel, Information Security Analyst 5Wells Fargo Services Company Alison Balter, one of the world's most experienced Access developers and trainers, has created Access applications ranging from small end-user projects to enterprise-wide systems. Her thirteen books on Access include Alison Balter's Mastering Microsoft Office Access 2007 Development. System RequirementsOperating System: Windows 98, 2000, XP, or Vista; Mac OS X; versions of Linux with the Flash 8 Player or later Multimedia: DVD drive, an 800x600 or higher display, and sound card with speakers Computer: 500MHz or higher, 128MB RAM or more

About Author

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 23 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly Marina Consulting Group) in 1990,its client base has expanded to include major corporations and government agencies such as Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others. Alison is the author of more than 300 internationally marketed computer training videos and CDROMs,including 18 Access 2000 videos, 35 Access 2002 videos, 15 Access 2003 videos, and 14 Access 2007 user videos. Alison travels throughout North America, giving training seminars on Microsoft Access, Microsoft SQL Server, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.Alison is also author of 14 books published by Sams Publishing: Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter'sMastering Microsoft Access Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a Snap, Alison Balters's Mastering Access 2007 Development, a power user book on Microsoft Access 2007, three e-books on Microsoft Access 2007, and Teach Yourself SQL Express 2005 in 24 Hours. Alison is a coauthor of three Access books published by SamsPublishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed. An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users' Group. She is currently immediate past president of the Ventura County ProfessionalWomen's Network.Alison's firm, InfoTech Services Group, Inc., is available for consulting work and onsite training in Microsoft Access, Visual Studio .NET, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows Vista, Windows XP, PC networking, and Microsoft Exchange Server. You can contact Alison by email at Alison@CallInfoTech.com, or visit theInfoTech Services Group website at http://www.CallInfoTech.com.

Contents

SECTION 1Access as a Development Tool 1Lesson 1: What's New with the User Interface .......................................1Lesson 2: What's New with Tables..........................................................2Lesson 3: Enhancements to Datasheet View ..........................................2Lesson 4: What's New with Forms ..........................................................3Lesson 5: What's New with Reports .......................................................4Lesson 6: The New and Improved Embedded Macros ..........................5SECTION 2VBA: A Foundational Review 6Lesson 7: What Types of Modules Are Available?..................................6Lesson 8: Working with Variables ...........................................................7Lesson 9: Working with Constants..........................................................9Lesson 10: Adding Comments to Your Code .......................................10Lesson 11: Using the Line Continuation Character ..............................10Lesson 12: Using VBA Control Structures.............................................10Lesson 13: Passing Parameters and Returning Values..........................11Lesson 14: Executing Procedures in the Code Window ......................12Lesson 15: The DoCmd Object: Performing Macro Actions................13Lesson 16: Working with Built-In Function ...........................................14Lesson 17: Using Built-In Dialog Boxes ................................................14Lesson 18: Editor Tips and Tricks..........................................................17SECTION 3Objects, Properties, Methods, and Events Explained 19Lesson 19: Understanding Access's Object Model ..............................20Lesson 20: Understanding Objects, Properties, Events, and Methods ......20Lesson 21: Referring to Objects ...........................................................21Lesson 22: Declaring and Assigning Object Variables .........................22Lesson 23: Differences Between Objects and Collections ...................24Lesson 24: Passing Objects to Subroutines and Functions ..................25Lesson 25: Determining the Type of Control........................................26Lesson 26: Special Properties That Refer to Objects ...........................27SECTION 4Debugging: Your Key to Successful Development 28Lesson 27: Avoiding Bugs.....................................................................28Lesson 28: Harnessing the Power of the Immediate Window .............29Lesson 29: Using Breakpoints to Troubleshoot ....................................31Lesson 30: Stepping Through Code .....................................................32Lesson 31: Setting the Next Statement to Execute .............................33Lesson 32: Using the Call Stack Window..............................................33Lesson 33: Working with the Locals Window .......................................33Lesson 34: Working with the Watch Window.......................................34SECTION 5Error Handling: Preparing for the Inevitable 35Lesson 35: Implementing Error Handling .............................................35Lesson 36: Using On Error Statements.................................................37Lesson 37: Using Resume Statements ..................................................38Lesson 38: The Cascading Error Effect .................................................39Lesson 39: Raising an Error ...................................................................40Lesson 40: Using the Errors Collection.................................................41Lesson 41: Creating a Generic Error Handler.......................................42Lesson 42: Preventing Your Own Error Handling fromBeing Invoked .......................................................................................44SECTION 6What Are ActiveX Data Objects and Data Access Objects and Why Are They Important? 45Lesson 43: The Data Access Object Model..........................................45Lesson 44: Getting to Know DBEngine ................................................45Lesson 45: Using CurrentDB() ...............................................................46Lesson 46: Working with DAO Recordset Types ..................................47Lesson 47: DAO Recordset Properties and Methods...........................48Lesson 48: Using DAO Code to Modify Table Data.............................48Lesson 49: Using DAO Code to Modify Database Objects .................49Lesson 50: Examining the ADO Object Model ....................................50Lesson 51: Working with Connections..................................................50Lesson 52: Working with ADO Recordset Types ..................................51Lesson 53: ADO Recordset Properties and Methods...........................52Lesson 54: Using ADO Code to Modify Table Data.............................53Lesson 55: Using ADO Code to Modify Database Objects .................54SECTION 7Advanced Form Techniques 56Lesson 56: Form Events and When to Use Them.................................56Lesson 57: Order of Events for Forms ..................................................56Lesson 58: Utilizing Section and Control Events ..................................57Lesson 59: Taking Advantage of Built-In Form-Filtering Features .......58Lesson 60: Switching a Form's Record Source .....................................59Lesson 61: Power Combo Box and List Box Techniques......................60Lesson 62: Synchronizing a Form with Its Underlying Recordset.........61SECTION 8Advanced Report Techniques 62Lesson 63: Report Events and When to Use Them ..............................62Lesson 64: Order of Events for Reports ...............................................63Lesson 65: Practical Applications of Report Techniques ......................63SECTION 9Advanced Query Techniques 65Lesson 66: Understanding SQL.............................................................65Lesson 67: Self-Joins .............................................................................67Lesson 68: Union Queries .....................................................................67Lesson 69: Pass-Through Queries.........................................................69Lesson 70: Subqueries ..........................................................................70Lesson 71: The Propagation of Nulls and Query Results .....................70Lesson 72: Using User-Defined Functions with Queries.......................70SECTION 10Advanced VBA Techniques 71Lesson 73: Working with Arrays............................................................71Lesson 74: Advanced Function Techniques ..........................................73Lesson 75: Working with Empty and Null.............................................75Lesson 76: Creating and Working with Custom Collections ................77SECTION 11Exploiting the Power of Class Modules 79Lesson 77: Creating and Using a Class Module ...................................79Lesson 78: Creating Multiple Class Instances.......................................81Lesson 79: More About Collections......................................................82Lesson 80: Custom Collections in Use..................................................83SECTION 12Using External Data 85Lesson 81: Using Code to Import External Data..................................85Lesson 82: Using Code to Link to External Data..................................86Lesson 83: Refreshing and Removing Links..........................................88SECTION 13Automation: Communicating with Other Applications 90Lesson 84: Creating an Automation Object .........................................90Lesson 85: Controlling Excel from Access............................................91Lesson 86: Closing an Excel Automation Object .................................93Lesson 87: Creating a Graph from Access............................................94Lesson 88: Controlling Word from Access............................................95Lesson 89: Controlling PowerPoint from Access..................................96Lesson 90: Controlling Access from Other Applications......................97SECTION 14Exploiting the Power of the Windows API 99Lesson 91: Declaring a Windows API Function ....................................99Lesson 92: Getting Information About the Operating Environment....100Lesson 93: Determining Drive Information.........................................101SECTION 15Developing Multiuser and Enterprise Applications 103Lesson 94: Designing a Multiuser Application ...................................103Lesson 95: Understanding Access's Locking Mechanisms..................104Lesson 96: Understanding the Client/Server Model ..........................105Lesson 97: Deciding Whether to Use the Client/Server Model .........105Lesson 98: Roles Access Plays in the Application Design Model ......107Lesson 99: What Is a Linked Client/Server Application? ....................108Lesson 100: Defining an ODBC Data Source .....................................108Lesson 101: Upsizing an Existing Access Database ...........................109Lesson 102: Working with Linked Tables ............................................110Lesson 103: Working with SQL Server Views .....................................111Lesson 104: Using Pass-Through Queries...........................................111Lesson 105: Executing Stored Procedures .........................................113Lesson 106: Building Client/Server-Friendly Forms ...........................115Lesson 107: Building Client/Server-Friendly Reports.........................115SECTION 16Working with and Customizing Ribbons 116Lesson 108: Customizing the Ribbon .................................................116Lesson 109: Applying a Custom Ribbon When a Database Opens .....117Lesson 110: Associating a Custom Ribbon with a Form or Report...........117Lesson 111: Executing a Macro from a Ribbon..................................118SECTION 17Working with Microsoft SharePoint 119Lesson 112: What Is SharePoint Server 2007 andWhy Integrate It with Your Access Applications? ...............................119Lesson 113: Exporting Data to a SharePoint Site...............................120Lesson 114: Publishing Data to a SharePoint Site..............................121Lesson 115: Opening Access Forms and Reports from a SharePoint Site...122Lesson 116: Linking to and Importing from SharePoint Lists .............123Lesson 117: Taking SharePoint Lists Offline .......................................123Lesson 118: Reestablishing Links When a SharePoint Site Has Been Moved.......124SECTION 18Database Security Made Easy 125Lesson 119: What's New in Access 2007 Security? ............................125Lesson 120: Working with the Trust Center........................................126Lesson 121: Using an Access 2007 Database in a Trusted Location........127Lesson 122: Use a Database Password to Encrypt an Access 2007 Database ........................128Lesson 123: Packaging, Signing, and Distributing an Access 2007 Database ............................129

Product Details

  • ISBN13: 9780672330216
  • Format: Mixed Media
  • Number Of Pages: 144
  • ID: 9780672330216
  • weight: 404
  • ISBN10: 0672330210

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly

Close