Print Page | Close Window

Roger's Published Articles

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Knowledge
Forum Description: White papers, articles, and downloads
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=254
Printed Date: 11 Dec 2017 at 4:24am


Topic: Roger's Published Articles
Posted By: Roger Carlson
Subject: Roger's Published Articles
Date Posted: 21 Jul 2008 at 5:16am
http://my.advisor.com/doc/18358 - 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
 
http://msaccess.advisorguide.com/doc/18506 - 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.
 
http://my.advisor.com/doc/18808 - 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.
 
http://my.advisor.com/doc/18812 - 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.
 
http://advisor.com/doc/19067 - 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.
 
http://my.advisor.com/doc/19276 - 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.
 
http://my.advisor.com/doc/19457 - 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.
 
http://my.advisor.com/doc/19612 - 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.
 
http://my.advisor.com/doc/19652 - Easy Excel Charting from Microsoft Access  
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.
 

http://my.advisor.com/doc/19653 - Automating Microsoft Word and Excel from Access

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.


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window