Buttons are one of the key interactive elements that you'll use on forms.…They instantly tell the end user that something will happen when I click there.…Buttons will be linked to either Macros or Visual Basic code to control their behavior.…Like the other controls, you add them to reports as well for navigation…within your database.…But the nice thing about buttons is that they don't print when you print your report.…Let's take a look at adding some buttons to my Controls form.…I'll right-click on that form in the Navigation pane and choose Design View.…The Button control is this one right here, the rectangle at the Xs inside of it.…I'll go ahead and click that once and click to add a button to my form.…
When I do that the Command Button Wizard starts, and it asks what do I want my button to do?…This first section has Categories;…the second section has Actions within each category.…So for instance, I've got Record Navigation, and I can do Find Next or Find…Record or Go To Next Record or Last Record.…
- 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
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.