April 2013
Intermediate to advanced
1296 pages
31h 42m
English
Content preview from Access 2013 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Part VI: Access Programming Fundamentals
In This Part
Chapter 22: Using Access Macros
Chapter 23: Getting Started with Access VBA
Chapter 24: Mastering VBA Data Types and Procedures
Chapter 25: Understanding the Access Event Model
Chapter 26: Debugging Your Access Applications
Part VI introduces macro programming and explains the art and science of Visual Basic for Applications (VBA). Very few professional-quality Access applications have been written without liberal use of either the VBA programming language or macros, or a combination of both.
With Access 2007, Microsoft began a significant effort to enhance macros as a valuable contributor to Access development. Long maligned as weaker or inferior to VBA, macros were often relegated to second-class citizenship in many Access developer toolkits. However, as you'll read in Chapter 22, Microsoft introduced embedded macros, a very efficient technique for automating many tasks in forms and reports.
Starting with Chapter 23, Part VI turns your attention to automation with VBA. VBA provides functionality that goes far beyond simply opening forms and reports and controlling the user interface. You'll use VBA code to validate data, as well as to transform and combine data in new and interesting ways. VBA code is used to import and export data, respond to user input, and handle the mistakes inevitably made by users.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.