Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Knowledge
  New Posts New Posts RSS Feed - Roger's Published Articles
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Roger's Published Articles

 Post Reply Post Reply
Author
Message
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: Roger's Published Articles
    Posted: 21 Jul 2008 at 5:16am
Create Your Own Median Domain-Aggregate Function in Microsoft Access
Publication Date: January 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
Calculating an average is an important part of many database projects. It is so important, that SQL has a function (AVG) to help you calculate it. But sometimes, in order to accurately represent your data, you need to calculate a median instead of an average. Unfortunately, Microsoft Access does not give you this option. Here's how to fill the gap
 
Design Microsoft Access Forms the Right Way -- From the Start
Publication Date: December 2006
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
Following a pre-existing paper-based system when designing tables can create an application that makes life difficult for both you and your users. Paper forms weren't created with proper application design principles in mind. By blindly following the paper form to determine your database and form design, you can end up with a system that's hard to build, hard to maintain, and filled with data integrity errors. Here's what to do when creating an application to replace a paper-based system.
 
Create the Right Relationships Between Tables in Microsoft Access
Publication Date: May 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
It's entirely possible to create a database with the right table design and still not be able to retrieve the information your users want. To deliver information your users need, you must also get the relationships between your tables right.
 
Scramble Your Microsoft Access Data for Testing
Publication Date: June 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
The best data for testing purposes is real world data. However, using real user's data might violate your user's confidentiality. These two routines will scramble your data so you don't into trouble.
 
Avoid Common Problems when Running Queries from Microsoft Access Code
Publication Date: July 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
Running queries from code can result in aggravating messages being displayed to your users. You can suppress some messages by using DAO instead of DoCmd.
 
Analyze Your Microsoft Access Data with the Top Query
Publication Date: Nov 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
The SQL Top query lets you retrieve a subset of your data that you feel is important -- or random records. You can even use VBA to create a Top query that lets you interactively control how may records you will get.
 
Recreate Microsoft Access Tables in SQL Server
Publication Date: Web Edition: 2008 Week 16
Publisher: DataBased Advisor
Format: Webzine
Here’s a tool that SQL Server has and Access doesn’t: The ability to generate SQL Scripts that can be used to recreate your table design in SQL Server -- or any other database server.
 
Number and Sum Your Microsoft Access Data in SQL Queries
Publication Date: Web Edition: 2009 Week 17
Publisher: DataBased Advisor
Format: Webzine
Some things are easy to do in reports and impossible to do in queries -- unless you know how to use Access domain functions and SQL subqueries. With those tools you can do the impossible.
 
Publication Date: Web Edition: 2009 Week 41
Publisher: DataBased Advisor
Format: Webzine
Using an Excel template, a tiny bit of Office Automation, and the Access TransferSpreadsheet method, you can send data from Access to formatted cells in Excel and create a chart based on it.
 
Publication Date: Web Edition: 2009 Week 52
Publisher: DataBased Advisor
Format: Webzine
By exposing the underlying object model for each of its Office applications, Microsoft lets you exercise control not only within a particular application, but between applications.
Please consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down