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…
Author
Adam Wilbert
Released
2/15/2012- 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
Duration
Views
-
Introduction
-
Welcome59s
-
-
1. Introduction to Forms
-
Introducing forms2m 41s
-
Exploring the database1m 49s
-
-
2. Form-Design Basics: Creating a Directory
-
Organizing the form elements7m 14s
-
Formatting4m 48s
-
-
3. Form and Report Controls
-
Introducing form controls3m 48s
-
Using lines and rectangles2m 48s
-
Adding buttons5m 3s
-
Linking to external content4m 15s
-
Attaching documents6m 49s
-
Attaching images5m 8s
-
Adding charts7m 9s
-
Linking controls7m 41s
-
-
4. Getting around the Database
-
Creating the main menu8m 49s
-
Creating a customer form7m 18s
-
-
5. Report Layout
-
Grouping and sorting data4m 36s
-
Formatting conditionally6m 59s
-
Calculating fields4m 35s
-
Adding the finishing touches4m 49s
-
-
6. Printing, Tweaking, and Automating
-
Printing reports3m 6s
-
Tweaking the design7m 10s
-
-
Conclusion
-
Next steps58s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Controlling input with option groups