Access 2016 Intermediate

LESSON 10 -

USING DESIGN VIEW .................................................................. 181 Adding a Label ......................................................................................................182 Adding an Image...................................................................................................183 Adding a Rectangle ...............................................................................................185 Adding a Line ........................................................................................................186 Editing an Unbound Control .................................................................................188 Using Multiple Undo/Redo in Design View ..........................................................189 Exercise.................................................................................................................192 USING ADVANCED FORM DESIGN............................................... 193 Using Forms in Design View .................................................................................194 Creating a Combo Box ..........................................................................................195 Editing List Items ..................................................................................................199 Creating a List Box ................................................................................................201 Creating an Option Group ....................................................................................205 Adding a Logic Control..........................................................................................209 Setting the Tab Order Automatically....................................................................212 Setting the Tab Order Manually ...........................................................................213 Adding a Form Header and Footer .......................................................................215 Creating a Blank Form ..........................................................................................217 Exercise.................................................................................................................219 USING ADVANCED REPORT DESIGN ............................................ 221 Adding Report Sections in Design View................................................................222 Creating a Calculated Control...............................................................................223 Creating a Running Summary ...............................................................................226 Inserting a Date/Time Control..............................................................................228 Inserting a Page Break ..........................................................................................229 Changing the Report Margins...............................................................................230 Using the Label Wizard.........................................................................................233 Creating a Report without Using a Wizard ...........................................................237 Exercise.................................................................................................................239

LESSON 11 -

LESSON 12 -

Page vi

OFFICEPRO, Inc.