Join Adam Wilbert for an in-depth discussion in this video Grouping and sorting data, part of Access 2010: Forms and Reports.
Access's way of preparing material and data for the printed page is through the report object.…Reports take data from tables and queries, applies formatting and organization…rules, and bundles all of it together into documents that are ready to be sent…to a printer or a PDF file, for example.…In this movie, we're going to take a look at how Access organizes data into…grouping and sorting levels.…If you've ever used the totals row within a query, this may seem somewhat…familiar, as the concept is really similar.…Let's get away from the Olive Oil Company for just a moment and we're going to…take a look at a database that's all about playing cards.…
I'm going to double-click on this table here called Draw.…We can see that this table has 5000 total records at the bottom here, and we…have a listing of randomized cards.…Basically, I took a random card from a deck of cards and I made a record of each pull.…So, for the first pull I had 6 of Hearts, on the second pull I had 4 of Clubs.…Let's go ahead and close the table and we'll take a look at a summarized look…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.