Access 2016 Advanced

Exercise...................................................................................................................46

LESSON 5 -

USING CHARTS.............................................................................47 Working with Charts...............................................................................................48 Adding a Chart to a Form or Report .......................................................................51 Using Microsoft Graph to Edit ................................................................................53 Changing the Chart Type ........................................................................................56 Changing the Chart Title .........................................................................................59 Formatting the Chart Title ......................................................................................60 Adding Data Labels to a Chart ................................................................................61 Exercise...................................................................................................................64 WORKING WITH INDEXES.............................................................65 Viewing Indexes......................................................................................................66 Creating a Single Field Index...................................................................................67 Creating a Multiple Field Index...............................................................................69 Deleting an Index....................................................................................................71 Creating a Multiple Field Primary Key ....................................................................72 Exercise...................................................................................................................75 EXPORTING DATA ........................................................................77 Exporting Data to an Excel Workbook....................................................................78 Saving Export Setup................................................................................................80 Dragging and Dropping Data into Excel..................................................................80 Creating Word Mail Merge Documents .................................................................82 Exercise...................................................................................................................84 USING ACCESS AND THE INTERNET ...............................................85 Working with Hyperlinks ........................................................................................86 Creating a Hyperlink Field.......................................................................................87 Inserting a Hyperlink Field......................................................................................88 Editing a Hyperlink Field .........................................................................................90 Deleting a Hyperlink Field.......................................................................................91 Exercise...................................................................................................................93

LESSON 6 -

LESSON 7 -

LESSON 8 -

LESSON 9 -

USING ACCESS DATABASE SECURITY.............................................95

Page iv

OFFICEPRO, Inc.