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 .<
|