Form headers are a distinct zone at the top of a form that can be used to place titles and other information about the contents of the form. When used on a form with lots of scrolling records, the header stays fixed on the top of the screen in order to provide a constant reference point and reminder about the form’s purpose.
- [Voiceover] We're gonna wrap up our…employee directory here,…and add a final bit of polish using the Property Sheet…to modify some additional objects within our form.…We're going to do this by adding a header section…up here across the top,…so that our end users will know…immediately what they're looking at.…As we go through this, keep an eye on the Property Sheet…and you'll see values change as we move things around…and make selections.…In order to add that header,…we'll switch our view into Design view.…At the top of our form,…you'll notice this bar that says, Detail…with the arrow pointing down.…If I right-click on it, you'll get a new pop-up window,…and one of the options we can choose…is to Add a Form Header/Footer.…
When I click on that, I get two new sections on my form.…Up here at the top, I have a form header,…and down at the bottom I have a new form footer.…Now, we're not going to add the footer section to this form,…so I'm gonna click down here at the very bottom,…and when I get this double-headed arrow,…
Author
Adam Wilbert
Released
7/6/2016Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.
- Creating forms with the Form Wizard
- Formatting and aligning form objects
- Combining text boxes
- Adding a header and labels
- Controlling input
- Adding attachments and images
- Linking form controls
- Creating menus and data entry forms for the database
- Building reports
- Creating calculation fields
- Linking forms and reports
- Printing and exporting reports
- Creating a form letter
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m
-
-
1. Introduction to Forms
-
2. Form Design Basics: Creating an Employee Directory
-
Organize the form design7m 29s
-
Object alignment5m 1s
-
Anchor controls3m 30s
-
Modify form properties6m 4s
-
Combine text boxes2m 42s
-
Add a form header4m 47s
-
-
3. Form and Report Controls
-
Label control6m 22s
-
Lines and rectangles6m 8s
-
Button controls7m 23s
-
Link to external content5m 38s
-
Select data with a combo box9m 37s
-
Attach external documents6m 23s
-
Add images to a form5m 51s
-
Embed a subform control5m 11s
-
Display a chart6m 39s
-
Link form controls6m 18s
-
Edit the Tab Stop sequence4m 35s
-
-
4. Getting Around the Database
-
Create a main menu5m 48s
-
Refine button macros4m 19s
-
Create a data entry form7m 1s
-
Finalize the customer form4m 58s
-
-
5. Report Layout
-
Build a report from a query3m 55s
-
Create calculation fields4m 44s
-
Add a report header5m 7s
-
Segment data into groups5m 45s
-
6. Linking Forms and Reports: Creating a Profit Summary
-
Build the query4m 56s
-
Create the report structure4m 49s
-
Add data to the report8m 54s
-
Connect the form6m 21s
-
Connect the query2m 44s
-
-
7. Printing and Exporting Reports
-
8. Populating Business Documents
-
Prepare the scanned template1m 36s
-
Construct the I-9 report5m 36s
-
Create a form letter5m 22s
-
-
Conclusion
-
Next steps59s
-
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: Add a form header