Join Adam Wilbert for an in-depth discussion in this video Adding the finishing touches, part of Access 2007: Forms and Reports in Depth.
- View Offline
- Exercise Files
No report should be complete without those finishing touches that make it…a polished document.…Things such as page numbers, date and time stamps, and logos help present a…professional looking report.…In this movie we're going to finish up our Lifetime Sales Report by adding such elements.…I'll double-click on the LifetimeSpend report here, and we'll switch into Design View.…Now adding date and timestamps and page numbers is nothing more than adding an…unbound text box with a calculated control source, just like we did in the last movie.…
We could add them manually and type in the expressions if we knew the proper…syntax, but these finishing elements are so common that Access actually has…buttons for these specifically built right into the Ribbon.…For instance, I can click this button here on the top…that says Title to add a title, and we've already added our own title using a label.…I can click this button here that says Number, and that will insert a page number.…And when I click on it, Access will open up this Page Numbers dialog box.…
- 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
Access 2007 Power Shortcutswith Alicia Katz Pollock3h 25m 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.