More data

An introduction to the benefits of online analytical processing (OLAP)

"Every day we create reams of data in customer relationship management applications, order entry applications, and warehouse management systems. We're drowning in a sea of data. However, even with all that data we don't have a large amount of information. We have the ones and zeros of the transactions, but we don't have the answers we need to simple questions like:

• "Why was March better than February?"
  
• "Where is the sales force having the most success?"
  
• "In what conditions does the sales team struggle with making sales?"

• Oracle 9i makes data warehousing easy to implement
  
• Seven highly effective steps to a smooth data warehouse implementation
  
• Business intelligence is just a few steps away for SAP R/3 users
  
• Resources for designing, planning, and implementing a data warehouse strategy
  
• Making the operational case for data warehousing
  
• TechRepublic Tutorial: Data warehousing defined

Also see:
OLAP Cube

Data Warehousing and OLAP
A Research-Oriented Bibliography

FAQ Excel 2007 – OLAP

Microsoft:

OLAP



See all Topics

access

Labels: List, Tables, Tips

Multiple selections

"How to open a report based on a multiple selection in a list box. For example, you may have a list of makes of car and a report that shows various details for each make of car. You want to allow the users to select a range of cars and pull up the report according to that selection."

Microsoft KB:
How to Use a Multi-Select List Box to Filter a Form

Customize a list box, combo box, or drop-down list box



See all Topics

access

Labels: Forms, General, List, Tips

We must have order

"A nice way to enhance your application is to give your users the ability to sort the contents of listboxes.

If you have a listbox with many records, this feature could be much appreciated. It's easy to manipulate the listbox RowSource property to accomplish this.

A command button could be used to add an "Order By" clause to the SQL statement, and once the RowSource property is updated, the list is automatically sorted."

Labels: List

Bit o' code

Sub ListFields()
Dim dbs As DATABASE
Dim dbfield As Field
Dim tdf As TableDef

Set dbs = CurrentDb
Set tdf = dbs.TableDefs!NAMEOFYOURTABLE

Debug.Print ""
Debug.Print "Name of table: "; tdf.Name
Debug.Print ""

For Each dbfield In tdf.Fields
        Debug.Print dbfield.Name
Next dbfield
End Sub

Labels: List