Call 479-715-6700

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