Join Adam Wilbert for an in-depth discussion in this video Controlling input with option groups, part of Access 2007: Forms and Reports.
We're going to continue editing our Reviews form for entering data into our Reviews table.…Let's take a quick look at the Reviews table one more time.…And now I need to add some elements that help us deal with this Rating column…and the Public column.…The Public column is a Yes/No field and by default in a table, it shows up as a checkbox.…The Rating column is a number field.…We could type in whatever number we want but we want to restrict users to a 1…through 5 scale. But we also want to identify what 1 through 5 means,…so we can do that on our form.…Let's go ahead and close our Reviews table.…
We'll go back to our Reviews form that we were working on in the last movie.…I'm going to switch into Design View and we're going to take a look at a couple of…elements that deal with the Yes/ No data type like our Public field.…In the Control section of our Design tab, we've got the Check Box, the Option…Button and sometimes it's called a radio button.…We also have a Toggle Button, that's this icon up here.…
- 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.