Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Saturday, December 31, 2011 – Permalink –

Number Entries

Beyond AutoNumber

Embedding information in a Primary key or ID, can lead to trouble in the future.
(If the first three numbers are to represent the warehouse address, what happens if new addresses have four numbers?)

Autonumbering can give a false sense of order. There is an initial tendency to try to keep all database records in some order. This violates the sense of a relational database.

The records can be sorted or filtered as needed.

Still some record numbering scheme may be desired.

Allen Browne's Access tips:
Numbering Entries in a Report or Form
"In relational database theory, the records in a table cannot have any physical order, so record numbers represent faulty thinking. In place of record numbers, Access uses the Primary Key of the table, or the Bookmark of a recordset. If you are accustomed from another database and find it difficult to conceive of life without record numbers, check out What, no record numbers?"

See all Topics access
Labels: Entries, General, Tips

<Doug Klippert@ 3:51 AM

Comments: Post a Comment

Sunday, December 25, 2011 – Permalink –

Auto Link

Outlook Contacts in Access

Automatically set up links to data outside of Access.
It still works in Access/Outlook '07-'10.

Try this:

Choose File >Open from the menu bar.
(Office button>Open in 2007)

Under Files Of Type choose Outlook().

Locate your Outlook PST files.

Choose Contacts, or if you have set up separate files for different groups choose an appropriate one.

The wizard walks you through the process of creating an Access database with a linked Contact table.

The changes made in Access will be reflected in Outlook and vice versa. If you want to create a new database that will link to other data that isn't in an Access format, you can do it quickly.
The classic way is to use the File>Get External Data >Link Tables method. However you can simply choose File >Open from the menu bar. Select the appropriate data format from the Files Of Type dropdown list (such as Microsoft Excel (*.xls)). Open the file and Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data. From there you can develop forms, queries and reports.

See all Topics access
Labels: E-mail, General, List, Tips, Tutorials

<Doug Klippert@ 3:57 AM

Comments: Post a Comment

Thursday, December 22, 2011 – Permalink –

Good OLAP

More data

From Builders.com.com:

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?"

The article also has links to:

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: Reference, Tips, Tutorials

<Doug Klippert@ 3:35 AM

Comments: Post a Comment