Join Adam Wilbert for an in-depth discussion in this video Controlling input with option groups, part of Access 2010: Forms and Reports.
Yes/No Data Type fields have several different ways that the user can…interact with them.…The most common is with a Checkbox an Option Button or a Toggle Button.…We can also group several of these elements together in what is called an option…group to deal with more complex data entry.…We are going to continue working with a simple form to capture product reviews…that we created in the last movie.…I will double-click to open it and we will see that we can select an oil name…from this drop-down menu and entering comments here that we want to add to our Review.…Let me go ahead and open up this Reviews table.…I will double-click on it to open and we will see that the Reviews table also…has two fields, one for Rating, here, which is the numerical value and one for Public.…
A Checkbox or Yes/No data type that says whether or not we can use the review on our website.…I am going to go ahead and close this table down and we will change our format…to Design View, here.…I am going to go up to the controls up at the top and I am going to use the More…
- 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
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Intermediate
Setting Up a Database in Excel 2010with Dennis Taylor43m 23s 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.