Microsoft Office Tutorials and References
In Depth Information
Book IV: Forms for Editing Data
Contents at a Glance
Contents at a Glance
Chapter 1: Designing Custom Forms (and Reports) ...............289
Seeing How Forms and Reports Are Secretly Related ............................ 290
Understanding Form Basics ....................................................................... 290
Making and Using a Form ........................................................................... 293
Creating Forms with Wizards ..................................................................... 296
Modifying Existing Forms and Reports ..................................................... 300
Getting Your Fields Lined Up in Layout View .......................................... 301
Configuring the Whole Form or Report .................................................... 305
Storing Your Forms and Reports ............................................................... 310
Chapter 2: Jazzing Up Your Forms (and Reports) .................313
Creating New Forms Efficiently .................................................................. 313
Making All Kinds of Changes in Design View ........................................... 314
Taking Control of Your Form or Report ................................................... 317
Making Controls That Display Text, Numbers, and Dates ..................... 323
Breaking Out of the Control Layout .......................................................... 326
Renaming, Resizing, Deleting, and Copying Controls ............................. 330
Formatting Numbers and Dates ................................................................. 330
Choosing Fonts, Colors, and Other Decorative Touches ....................... 331
Creating Check Boxes for Yes/No Fields .................................................. 335
Adding Lines, Boxes, and Backgrounds .................................................... 335
Controlling Cursor Movement in Your Form ........................................... 336
Chapter 3: Creating Smarter Forms .............................339
Creating and Configuring Combo and List Boxes .................................... 339
Designing Cool Looks for Yes/No Fields ................................................... 345
Creating Option Groups .............................................................................. 345
Creating Command Buttons ....................................................................... 348
Making a Find Box ....................................................................................... 354
Displaying Attachments .............................................................................. 355
Adding Form Headers and Footers ........................................................... 357
Creating Tabbed Forms .............................................................................. 358
You Can’t Type That Here! ......................................................................... 360
Making a Main Menu for Your Database ................................................... 361
Chapter 4: Doing Calculations in Forms and Subforms
(and Reports) ................................................365
Doing Elementary Calculations .................................................................. 365
Calculating and Formatting Numbers ....................................................... 369
Calculating and Formatting Dates ............................................................. 370
Calculating and Formatting Text ............................................................... 370
Displaying Values That Depend on Conditions ....................................... 371
Formatting Calculated Controls ................................................................. 371
Using a Split Form to Display a Datasheet ............................................... 372
Using a Subform to Display Detail Records .............................................. 373
Adding Subtotals and Totals from Subforms ........................................... 379
 
Search JabSto ::




Custom Search