Access 2016 Advanced

Table of Contents

ABOUT OFFICEPRO – WE CHANGE LIVES! ...............................................................I

WHAT TO EXPECT FROM OFFICEPRO?...................................................................II

TABLE OF CONTENTS...........................................................................................III

LESSON 1 -

USING SUBFORMS/SUBREPORTS....................................................1 Working with Subforms/Subreports ........................................................................2 Creating a Subform/Subreport.................................................................................3 Editing the Layout of a Subform...............................................................................7 Displaying a Subform in Datasheet View..................................................................8 Displaying a Subform/Subreport Total...................................................................10 Exercise...................................................................................................................14 ANALYZING TABLES......................................................................15 Analyzing a Table....................................................................................................16 Using Relationships in Splits ...................................................................................16 Using the Table Analyzer Wizard............................................................................16 Using the Performance Analyzer............................................................................21 Exercise...................................................................................................................24 CUSTOMIZING THE NAVIGATION PANE.........................................25 Creating Custom Categories ...................................................................................26 Creating Custom Groups ........................................................................................28 Adding Database Objects to a Group .....................................................................29 Showing/Hiding the Unassigned Objects Group ....................................................30 Deleting Objects from a Group...............................................................................31 Exercise...................................................................................................................33 USING OTHER FORM TECHNIQUES................................................35 Creating a Split Form ..............................................................................................36 Converting an Existing Form to a Split Form ..........................................................37 Editing a Split Form.................................................................................................38 Adding a Command Button ....................................................................................40 Saving a Form as a Report ......................................................................................43

LESSON 2 -

LESSON 3 -

LESSON 4 -

OFFICEPRO, Inc.

Page iii