Tom Bizannes - EzineArticles.com Expert Author Bio

Report this author if you suspect they are involved in any fraudulent practices.

Suggest a topic or article headline you would like the author to write about.

Tom Bizannes - EzineArticles.com Expert Author

Microsoft Database and Reporting Specialist Sydney, Australia

[View Tom Bizannes's Extended Author Bio]

[Display Categories] Sort By [Title] [Newest] [Oldest]

Tom Bizannes Email Alerts

Dealing With Large Spreadsheets
[Computers-and-Technology:Software] Why do spreadsheets grow very large? Often they are used as databases, and with Excel 2007 now being able to cater for a millions rows, they can hold quite a lot of data. The typical scenario is to have a worksheet with the data and other worksheets which use pivot tables and lookup functions like vlookup to analyze and report on the data. Another situation that is quite common is monthly reporting. You start off with reporting for a number of branches for one month and then you end up with reporting month after month for a year or two and you now have a very complex set of linked workbooks. e.g. 10 branches by 24 months 240 linked workbooks plus the 24 data sheets..!

So You Want To Upsize Your Access Databases?
[Computers-and-Technology:Software] Learn about ways to upsize your Microsoft Access Databases to increase productivity and make your data more reliable and secure. There are many ways to upsize your access databases or migrating the data and or access application to another system. This article discusses all the different options plus shows how a combination of methods is often more successful and less expensive than the "let's replace everything" approach.

URL Parameters Used in Reporting Services
[Computers-and-Technology:Software] Reporting Parameters give you more control over what you or the user can see.

Parameters in Microsoft SQL Server 2000 Reporting Services
[Computers-and-Technology:Software] Using Parameters properly makes reporting easier for the end user.