June 2011
Beginner
552 pages
14h 54m
English
Content preview from Microsoft® Access® 2010 24-Hour TrainerBecome 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.
36
Embedded Macros in Forms
Macros is one of the major Microsoft Access features that has been greatly improved upon in the last several releases of the product. Access 2010 has a completely revamped Macro Designer that makes it easier than ever to create macros in a database application. Using macros can be extremely easy, especially considering you do not need to know any special code to make them work. Using macros in forms can be a very simple, yet extremely effective method for enhancing the functionality of forms in an Access database.
LESSON SETUP
This lesson provides an overview of working with embedded macros in Access Forms. Now that you have a basic understanding of working with Access Forms and the controls that can be used on them, you explore the building of some embedded macros in a form to show how easy it is to build macros for forms using Access 2010.
MACROS IN ACCESS
The term macro in Access refers to a type of functionality that can be executed when the macro is called. A macro can have one or more actions that execute in sequence. The best part about them is that building macros is as easy as choosing items from a list, like in the Property Sheet. Basically two types of macros can be used in forms: Named Macros and Embedded Macros. These types of macros are basically the same, with a few distinct differences.
Named Macros
Named Macros, also known as standalone macros, are created as database objects. This is really the base type of macro object. A Named Macro ...
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.