Advanced Access for Retail Link® Users

Overview

Our Advanced Access for Retail Link® Users course focuses on streamlining the analysis process. It will help you to develop advanced queries, a user interface that will summarize key information, report generation, and automate procedures. You will have more time to make critical business decisions.

In this course, you will learn:

Structuring existing data

  • Analyzing tables
  • Improving table structure
  • Creating an input mask
  • Creating a lookup field
  • Data validation
  • Restricting data entry with field properties


Writing advanced queries

  • Creating ad hoc joins
  • Types of joins
  • Totals (group and summarizing records)
  • Crosstab query (summarizing records)
  • Creating a pivot table and a pivot chart
  • Parameter queries


Making forms more effective

  • Create a user interface
  • Working with controls
  • Tab Pages (organizing information)
  • Calculated fields
  • Subforms
  • Set form properties
  • Creating graphs


Making reports more effective

  • Working with controls
  • Calculated fields
  • Subtotals
  • Organizing information within groups
  • Subreports
  • Set report properties
  • Creating graphs


Simplifying tasks with macros

  • Creating a macro
  • Attach a macro to a command button
  • Restricting records