SKU Rationalization - brought to you by Planet Retail

Learn about Walmart's ongoing efforts to reduce the number of SKU's in their stores. Click here for more information.

Advanced Access 2003 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. Mastering these processes will give you 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

Call 1-479-715-6700 for information.

Close

Uh-oh!

We haven't been able to give you any COOKIES.

Cookies are small pieces of text stored on a computer by a web browser. Our site requires that your web browser has cookies enabled for these actions:

These are common reasons your web browser is not accepting cookies:

If you wish to register for a course and cannot change your browser to accept cookies, call 1-479-715-6700 for customer service.