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
