The next two controls that I want to explore are the Line and…Rectangle controls.…They're useful for marking of space and grouping elements together in your forms and reports.…Generally, they are pretty passive and not really all that exiting, but…proper use of them can go a long way to making your forms and reports legible and unambiguous.…Let's go ahead and open up this Controls form that I've got here, we've…created in the last movie.…Now right-click and say Design View to jump straight into Design View.…Now the line control is here in the Design ribbon.…I can click on it and drag out a line.…Now lines have a kind of a weird property to them when they're completely…horizontal like this or completely vertical like this they're invisible to you.…
The only way you can see what you're doing is to look at the ruler on the left…side, while you're dragging out a vertical line or the ruler across the top when…you're dragging out a horizontal line.…Once I let go of the mouse though the line will appear and it will be selected.…
- 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.