June 2010
Intermediate to advanced
834 pages
29h 12m
English
Content preview from Access 2010: The Missing ManualBecome 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.
Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More
In Chapter 1, you took your first look at the datasheet—a straightforward way to browse and edit the contents of a table. As you’ve learned since then, the datasheet isn’t the best place to build a table. (Design view is a better choice for database control freaks.) However, the datasheet is a great tool for reviewing the records in your table, making edits, and inserting new data.
Based on your experience creating the Dolls table (Creating a Simple Table), you probably feel pretty confident breezing around the datasheet. However, most tables are considerably larger than the examples you’ve seen so far. After all, if you need to keep track of only a dozen bobbleheads, then you really don’t need a database—you’ll be just as happy jotting the list down in any old spreadsheet, word processor document, or scrap of unused Kleenex.
On the other hand, if you plan to build a small bobblehead empire (suitable for touring in international exhibitions), you need to fill your table with hundreds or thousands of records. In this situation, it’s not as easy to scroll through the mass of data to find what you need. All of a sudden, the datasheet seems more than a little overwhelming.
Fortunately, Access is stocked with datasheet goodies that can simplify your life. In this chapter, you’ll become a datasheet expert, with tricks like sorting, searching, and filtering at your fingertips. You’ll also learn a quick-and-dirty way ...
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.