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.
Made with FlippingBook - Online magazine maker