Welcome to 8th & Walton -  the premier destination for Walmart supplier education. Our mission is singular: to offer services and solutions that support organizations of all sizes and from anywhere in the world in their efforts to do business more efficiently and effectively with the world's largest and most important retailer.

 

Whether you are looking for courses in a city near you, an online course that will allow you to save time and money or custom and private training held at your facility, 8th & Walton can help.

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

Upcoming Dates

Oct 20, 2010 - Bentonville - $500
Register  |  More Info

Date: October 20, 2010

Time: 8:30 AM - 4:30 PM

Price: $500

Facility: 8th & Walton

902B South Walton Blvd., Suite 18
Bentonville, AR 72712

Audience:

Intended for individuals at all levels of their organization who have experience using Retail Link® and Microsoft Access.

Schedule:

This course is taught from 8:30 AM - 4:30 PM.

Notes:

Prerequisite: Microsoft Access experience and Retail Link experience.
Participants will need a laptop with Microsoft Access (version 2003).

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.