Thursday, July 30, 2009

Auto-Generated Update SQL

Retrieving data isn't all that you can do with generated SQL statements. Ann Ziegler shows how to create an update-and-append statement on the fly. Read more here http://www.vb123.com/kb/200202_az_auto_updates_sql.htm

Tuesday, July 28, 2009

Compute the median in a query

You should never calculate the average value of anything without also calculating the median value. Chris Weber explains why and gives you a clean, step-by-step method for deriving the median value from any numeric series. Unlike other published methods, Chris' method uses no temporary tables or custom functions–all you need is a single query. This article comes from our Smart Access collections http://www.vb123.com/kb/200504_cwmedian.htm

Why not purchase a collection and help fund this monster Access website.

Sunday, July 26, 2009

Migrating Access (and Outlook Data) to SQL Server

It's an unusual Jet database that will convert smoothly to SQL Server. Rick Dobson shows how to mix your own code with the Upsizing Wizard. But in many cases it's not just Access data that you need to convert, so he shows how Access can let you move Outlook data into SQL Server. Read this article in our Smart Access KB site http://www.vb123.com/kb/200504_rdsqlupsize.htm

Thursday, July 23, 2009

Workbench Help is Online + New Workbench

Following on from the massive http://www.vb123.com/kb Smart Access project, we are now rolling out online help for The Access Workbench. Check out the help here
http://www.vb123.com/workbench/help/

A new version of the Workbench is now available. Read about the improvements here.

Wednesday, July 22, 2009

Total Access Speller for Access 2002/2003

Ever since I have been developing in Access, FMS have been writing products for it. In this article from the Smart Access vaults, Danny Lesandrini takes Total Access Speller for a test drive. Find the article here.

Tuesday, July 21, 2009

Data Modeling for the Access Newcomer, Part 1

Thorough, thoughtful, and accurate data modeling should be the starting point of detailed database design. But a surprising number of developers have little or no understanding of data modeling and shy away from what sounds like a non-profitable and time-consuming task. Glenn Lloyd looks at the typical design pitfalls that trap Access beginners and shows the basic techniques that ensure success.

Find out about data modelling basics here

User queries on the fly

Rather than define every query that your users might require, why not let your users make up their queries as they need them. Russell Sinclair discusses how to create a simplified query interface for Access users.

You can find the article for this here

Note: For those of you that wonder why we dont post the actual download files with these articles, I must be upfront and explain that the downloads only come with the Smart Access collections. This is how we pay for the hours that are required to get these articles out to you. And to those of you that have purchased the Smart Access collections already, the fantastic initial response has inspired us to start building this comprehensive new website.

Highlighting search matches in Access 2007

Access MVP Allen Browne has a neat little database sample that shows you how you can highlight search terms at the same time that you are filtering records. This little beauty requires you to have a copy of Access 2007.

Read about it here at everythingaccess.com

Doug brings families together using SQL

In this article, Access MVP Doug Steele, aims to solve this dilemma and other family issues with just a query or two. "How can you concatenate the names of the family head from one record, the spouse's name from another record plus all of the children records and show them in a single line"

Read it at our new Smart Access inspired website

Wednesday, July 15, 2009

Tha Smart Access Online KB Has Arrived

After much testing, building of index words and experimenting with different structures, the new vb123.com KnowledgeBase site has been born. Initially it showcases the Smart Access collections but overtime it will house lots of articles from the Smart Access collections and other writings of note. Find it here http://www.vb123.com/kb/