Join Adam Wilbert for an in-depth discussion in this video Grouping and sorting data, part of Access 2007: 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…roles, and bundles all of it together to documents that are ready to be sent to…a printer or a PDF file.…In this movie, we're going to take a look at how Access organizes data into…grouping and sorting levels.…Now, if you've ever used the Totals Row within a query, this is going to seem…somewhat familiar as the concepts are really similar.…Let's get away from the Olive Oil Company for just a moment, and open up a…sample database that's all about playing cards.…
Now I've got a table here called Draw.…I'm going to double-click on that and open it, and we can see that this table…has 5000 records in it.…This table represents 5000 random card pulls from a deck of playing cards.…The first time I randomly drew a card, I had the 6 of hearts, the second time,…the 4 of clubs, and I did this for 5000 times.…Let's go ahead and close this table and we'll open up this query…
- 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. The User Experience
- 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.