Course Registration
416-978-5462


General Inquiries & Appointments:
416-978-2066



SUBSCRIBE
ODLC Listserv

 

accessibility
Directions

215 Huron Street, 6th floor
odlc@utoronto.ca


Toastmasters (SALUT)


  Print help
Previous month Previous day Next day Next month
See by year See by month See by week Search Jump to month



Access 2016 Level 3

Tuesday, August 27, 2019, 09:00am - 04:00pm

 

This 6-hour course focuses on advanced queries, creating and modifying reports, importing and exporting data, designing menu systems and creating and running macros.

 

Topics include:

 

  • Creating Multi-Table Queries, Totals Queries, Parameter Queries, Find Duplicates Queries and Find Unmatched Records Queries
  • Working with Action Queries (Make-Table Query, Append Query, Update Query, Delete Query)
  • Using Calculations in Queries
  • Working with the Expression Builder
  • Modifying Query Joins
  • Changing Query Properties
  • Importing Data from Text Files, from Excel, and from another Access Database
  • Linking to Data in Another Database
  • Exporting Data to Excel, to Word, to a Text file, to a PDF File, to another Access Database and to a Word Mail Merge
  • Creating Reports using the Report Wizard
  • Using Design View, Report View and Layout View
  • Working with Report Sections
  • Adding Controls to a Report
  • Creating Calculated Controls
  • Changing Control Properties
  • Sorting and Grouping Data in a Report
  • Applying Themes and Conditional Formatting to a Report
  • Modifying Report Setup
  • Printing Reports
  • Creating Mailing Labels Using the Label Wizard
  • Creating and Using a Switchboard
  • Creating a Navigation Form
  • Setting Access Startup Options
  • Working with Macros

 

Requirement: Completion of Access 2016 Level 2 or equivalent experience with Access or any other database program.

 

Register

 


To Cancel and Check Fees click here


Location: 256 McCaul Street , Room 109
Presenter: Simone Hubers

 

Back