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.
35
Working with Subforms and Subreports
Subforms and Subreports are used every day in Access 2010. The Subform/Subreport control enables the developer to show other database objects directly from within the parent form. The Subform/Subreport control is extremely flexible and provides a lot of functionality for working with subobjects, as you will see in this lesson.
LESSON SETUP
This lesson is designed to provide an overview of working with Subforms and Subreports in Access Forms. Now that you have a basic understanding of working with Access Forms, you will explore the Subform/Subreport control to illustrate how easy it is to work with the visual controls of Access.
SUBFORMS/SUBREPORTS IN ACCESS
Access Subforms and Subreports are nothing more than object frames that can be used to display other database objects. Like forms, Subforms and Subreports can be Bound or Unbound, depending on what functionality is desired. Binding the control really only means that the Object Source property has been set to some valid database object. The Subform/Subreport control can be bound to tables, queries, forms, reports, PivotCharts, and PivotTables.
The type of database object that is bound to a Subform/Subreport determines the view for what is to be displayed in the Subform/Subreport control. In the case of a table or query, the default view is the Access Datasheet View, showing the data that would be shown in that object. For a report, PivotChart, or PivotTable, the default normal view for ...
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.