DocumentsDate added

Access: Multi-user Network Sharinghot!

22.01.2008

This class introduces using an Access database on a network where more than one person must access the database and provides hands-on practice with six activities

Hits: 188

• Details
• Download
• View

Using Pivot tables in Excel hot!

07.05.2007

Learn basic techniques to use Pivot Tables in Excel (Access).

Hits: 144

• Details
• Download
• View

XLCubed: First Steps in OLAPhot!

05.06.2007

If you use Excel for analysis of large amounts of data from your business systems you will be familiar with some of its limitations as well as its power. At XLCubed we produce products that help to bridge the gap between Excel’s power as a spreadsheet and its limitations as a place for analyzing and storing large amounts of data.

Hits: 125

• Details
• Download
• View

Fascinating Query Trickshot!

09.05.2007

Here is an overview of what we will cover:

• How to pass a variable parameter to a query calculation
• How to add "<All Employees>" to a list of employee names
• Use UNION query to add a Totals row to a dataset output

Hits: 104

• Details
• Download

Access quick reference guide

02.04.2007

This document aims to cover all the query language elements (expressions, functions

etc) that are available for you to use in your queries, and on your forms and reports.

Hits: 82

• Details
• Download