Access 2016 Intermediate

Using the Expression Builder ..................................................................................61 Using a Wildcard Character ....................................................................................64 Exercise...................................................................................................................67 DESIGNING ADVANCED QUERIES ..................................................69 Setting Top Values in a Query ................................................................................70 Creating a Calculated Field .....................................................................................72 Formatting a Calculated Field.................................................................................74 Displaying a Totals Row in a Query ........................................................................75 Creating a Function Query......................................................................................77 Creating a Parameter Query...................................................................................79 Using Multivalued Fields ........................................................................................80 Creating a Concatenation in a Query .....................................................................82 Filtering a Query .....................................................................................................84 Exercise...................................................................................................................86 CREATING ACTION QUERIES .........................................................89 Creating a Make-table Query .................................................................................90 Creating an Update Query......................................................................................93 Creating an Append Query .....................................................................................95 Creating a Delete Query .........................................................................................98 Exercise.................................................................................................................102 USING ADVANCED QUERY WIZARDS........................................... 105 Using the Crosstab Query Wizard.........................................................................106 Using the Find Duplicates Query Wizard..............................................................109 Using the Find Unmatched Query Wizard............................................................111 Exercise.................................................................................................................115 USING ADVANCED DATABASE FEATURES .................................... 117 Importing Data .....................................................................................................118 Linking Data to an Access Table ...........................................................................122 Using the Linked Table Manager ..........................................................................124 Exporting Data ......................................................................................................126 Converting Files ....................................................................................................129 Printing a Relationship Document........................................................................131

LESSON 4 -

LESSON 5 -

LESSON 6 -

LESSON 7 -

Page iv

OFFICEPRO, Inc.