Roger's Published Articles |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
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. 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. |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |