PDA

View Full Version : Carlson, Roger J.



Roger J Carlson
03-19-2007, 05:40 PM
Title: Create Your Own Median Domain-Aggregate Function in Microsoft Access (http://my.advisor.com/doc/18358)
Author(s): Carlson, Roger J.
Publication Date: January 1, 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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

Link (publisher):http://my.advisor.com/doc/18358
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
03-19-2007, 05:46 PM
Title: Design Microsoft Access Forms the Right Way -- From the Start (http://msaccess.advisorguide.com/doc/18506)
Author(s): Carlson, Roger J.
Publication Date: December 1, 2006
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.

Link (publisher):http://msaccess.advisorguide.com/doc/18506
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
04-23-2007, 05:33 PM
Title: Create the Right Relationships Between Tables in Microsoft Access (http://my.advisor.com/doc/18808)
Author(s): Carlson, Roger J.
Publication Date: May 1, 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.


Link (publisher):http://my.advisor.com/doc/18808
Link to author's website: http://www.rogersaccesslibrary.com
__________________
--Roger J. Carlson
www.rogerjcarlson.com

Roger J Carlson
05-21-2007, 07:34 PM
Title: Scramble Your Microsoft Access Data for Testing (http://my.advisor.com/doc/18812)

Author(s): Carlson, Roger J.
Publication Date: June 1, 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.

Link (publisher):http://my.advisor.com/doc/18812
Link to author's website: http://www.rogersaccesslibrary.com (http://www.rogersaccesslibrary.com/)
__________________

Roger J Carlson
08-01-2007, 09:26 PM
Title: Avoid Common Problems when Running Queries from Microsoft Access Code (http://advisor.com/doc/19067)

Author(s): Carlson, Roger J.
Publication Date: July 1, 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.


Link (publisher):http://advisor.com/doc/19067
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
10-08-2007, 08:24 PM
Title: Analyze Your Microsoft Access Data with the Top Query (http://my.advisor.com/doc/19276)
Author(s): Carlson, Roger J.
Publication Date: Nov 1, 2007
Publisher: Advisor Guide to Microsoft Access
Format: Print Magazine, Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.


Link (publisher):http://advisor.com/doc/19067
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
04-17-2008, 10:10 AM
Title: Recreate Microsoft Access Tables in SQL Server (http://my.advisor.com/doc/19457)
Author(s): Carlson, Roger J.
Publication Date: Web Edition: 2008 Week 16
Publisher: DataBased Advisor
Format: Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.



Link (publisher):http://my.advisor.com/doc/19457
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
07-02-2009, 08:58 PM
Title: Number and Sum Your Microsoft Access Data in SQL Queries (http://my.advisor.com/doc/19612)
Author(s): Carlson, Roger J.
Publication Date: Web Edition: 2009 Week 17
Publisher: DataBased Advisor
Format: Webzine
ISBN: na
Price: Subscription: $99/year
Logline: (one-paragraph description): 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.


Link (publisher): http://my.advisor.com/doc/19612
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
12-30-2009, 07:45 PM
Title: Easy Excel Charting from Microsoft Access (http://my.advisor.com/doc/19652)
Author(s): Carlson, Roger J.
Publication Date: Web Edition: 2009 Week 41
Publisher: DataBased Advisor
Format: Webzine
Logline: (one-paragraph description): 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.

Link (publisher): http://my.advisor.com/doc/19652
Link to author's website: http://www.rogersaccesslibrary.com

Roger J Carlson
12-30-2009, 07:46 PM
Title: Automating Microsoft Word and Excel from Access (http://my.advisor.com/doc/19653)
Author(s): Carlson, Roger J.
Publication Date: Web Edition: 2009 Week 52
Publisher: DataBased Advisor
Format: Webzine
Logline: (one-paragraph description): 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.

Link (publisher): http://my.advisor.com/doc/19653
Link to author's website: http://www.rogersaccesslibrary.com