- Subscribe to this page:
- RSS
- Email Alert
data tools
(54 results)Search the Library
Mission Statement
TechRepublic's Download Directory is the place to get free tech resources in a variety of formats, including PDF versions of popular articles, "10 things" lists, sample chapters from technology books, "How do I..." problem-solving guides, cheat sheets for knocking out IT tasks, keyboard shortcuts, glossaries, career pointers, and collections of tips and techniques that focus on critical topics.
-
Book chapters
Use the GROUP BY clause to write SQL queries that group and aggregate data
Jan 2007
Introduction to SQL, long the definitive SQL tutorial for database professionals, has been updated to reflect the latest SQL standards and newest versions of today's leading RDBMSs: Oracle,...
Provided by Addison Wesley Professional
-
Downloads
85 keyboard shortcuts for moving faster in Microsoft Excel
Apr 2006
Keyboard shortcuts can shave a surprising amount of time off the process of performing various Excel tasks. This list includes all the basics, along with those 'I know there's a way to do this...
Provided by TechRepublic
-
Downloads
Big Data Primer for IT Pros
Nov 2012
This primer introduces the host of issues IT leaders must understand as they evaluate their organizations' needs and move forward with Big Data initiatives.
Provided by TechRepublic Pro
-
Downloads
Trends that will change business intelligence in 2012
Jan 2012
The world of business intelligence is radically changing. See how the cloud, social media, mobile adoption, open source, and data growth are transforming BI.
Provided by Robert Eugene Miller
-
Downloads
75 essential Excel tips
Feb 2005
This compilation of 75 practical, time-saving tech tips will help your Microsoft Excel users make quick work of many common and not-so-common Excel tasks. From data entry and cell formatting to...
Provided by TechRepublic
-
Downloads
10+ things you should do before building a custom Access database
Mar 2008
Whether you take on freelance work or you support your organization's IT needs by developing custom database solutions, you must build an efficient, easy-to-use database if you plan to stay...
Provided by Susan Harkins
-
Downloads
10 reasons to turn your Access applications into Web-based applications
Apr 2008
An Access database often outgrows its original purpose. When that happens, you face applying band-aid technology or upgrading to a more powerful database system, such as SQL Server Express or even...
Provided by Susan Harkins and Drew Wutka
-
Downloads
Export Excel comments to Word VBScript
Jun 2005
Excel's comment feature allows you to quickly and easily describe a cell's function or provide additional information. While printing these comments is relatively simple, getting them into a Word...
Provided by TechRepublic
-
Downloads
10+ tips for working smarter with SQL
Jun 2009
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.This download is also available as an entry in our 10...
Provided by Susan Harkins
-
Downloads
10+ ways to screw up your database design
Oct 2010
Database developers often fall into certain design traps -- and it's generally the users who pay the price. See how you can improve your design process and build a more flexible, reliable, and...
Provided by Susan Harkins
-
Downloads
10 efficient ways to produce useful metrics
Mar 2011
Accurate metrics are essential for assessing performance and making informed decisions, but companies often rely on flawed information that paints a misleading picture. Alan Norton explains the...
Provided by Alan Norton
-
Downloads
10+ reasons to split an Access database
Oct 2009
Splitting your Access database offers numerous advantages, including increased flexibility, security, efficiency, and scalability.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Downloads
10 tips for choosing between a surrogate and natural primary key
Mar 2011
The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when -- and why -- you might choose one over the...
Provided by Susan Harkins
-
Downloads
Anatomy of Excel data analysis: Sorting and filtering information
Nov 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
Excel keyboard shortcuts
Dec 2003
Get lots of valuable Excel keyboard shortcuts. Try this one-page sample chart from our Quick Reference: Microsoft Office Pak.
Provided by TechRepublic
-
Downloads
10 tips for using wildcard characters in Microsoft Access criteria expressions
Jan 2007
Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...
Provided by Susan Harkins
-
Downloads
Gain confidence in your presentations by following these tips
Aug 2005
For most of us, effective public speaking requires a bit of discipline, preparation, and practice. These suggestions will help you develop your delivery skills and overcome presentation jitters....
Provided by TechRepublic
-
Downloads
10 reasons why IT pros hate Microsoft Access (but really shouldn't)
Jul 2008
Microsoft Access may not be right for all situations, but it does have its place -- at least according to database expert Susan Harkins. Here's her take on some of the more common complaints she's...
Provided by Susan Harkins
-
Downloads
Anatomy of Excel data analysis: Advanced graphs and PivotCharts
Dec 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
Access reference: Working with queries
Mar 2004
Putting data into a database is only part of the Access puzzle. Once the data's stored, your users will need to review it, analyze it, and even change it. This guide explains the key aspects of...
Provided by TechRepublic
-
Downloads
10+ tips for working efficiently in Access' Query Design window
Apr 2007
If you create Access queries, you probably know your way around the Query Design window. But there are some not-so-obvious tricks you can use to work more efficiently, maintain accuracy, and...
Provided by Susan Harkins
-
Downloads
How do I... Print a single Microsoft Access record in Form View?
Feb 2007
Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button, you...
Provided by Susan Harkins
-
Downloads
The Metrics Of IT: Management By Measurement
Apr 2011
Good metrics should be used to guide the development of strategic objectives, narrow investment opportunities to minimize wasted capital, and continually evaluate status to ensure that progress is...
Provided by TechRepublic Pro
-
Downloads
How do I... Create a crosstab query in Microsoft Access?
Sep 2006
Crosstab queries in Microsoft Access allow you to do what normal SELECT queries do not: aggregate data across columns as well as rows. This walkthough will show you how to use these unique...
Provided by Tim Chapman
-
Downloads
Anatomy of Excel formatting: Make better spreadsheet presentations - part 3
Sep 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
10 things that are [still] broken in Access 2007... and maybe in 2010
Sep 2009
In Access 2007, some things just don't work — and a few problems appear to be persisting in the 2010 Technical Preview.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Downloads
Support Republic's Ultimate Excel Compilation
Jun 2003
Don't wait for users to ask for advice; be proactive and help them improve their Excel skills with this compilation of Excel tips. This download contains over 100 pages of invaluable Excel advice...
Provided by TechRepublic
-
Downloads
Anatomy of Word: Taking Word tables to the next level with spreadsheet techniques
Feb 2006
Word tables and Excel spreadsheets share a few things in common, such as the ability to perform calculations on numbers in each cell. This document explores these similarities and points out where...
Provided by TechRepublic
-
Downloads
10 things you can do to protect your data
Apr 2006
Operating systems and applications can always be reinstalled, but your data is unique--making it the most important thing on your computer or network. Here's a look at 10 ways you can protect that...
Provided by TechRepublic
-
Downloads
How do I... Print a label for an individual record in Microsoft Access?
Sep 2007
Printing labels using the Microsoft Access Label wizard is straightforward and relatively simple. But printing a label for a single record can be a bit more challenging. In this How do I..., Susan...
Provided by Susan Harkins
-
Downloads
Should you use SQL Server Express Edition or Microsoft Access for your small business applications?
Dec 2006
Small businesses that are considering adopting a database application have a variety of choices. IT pro Tim Chapman focuses on two of them--SQL Server Express edition and Microsoft Access--and...
Provided by Tim Chapman
-
Downloads
How do I... Populate an Access list control with the results of a dynamic search?
Jul 2007
This tutorial and sample Access database will guide you through the process of setting up fixed queries to populate a list control with the query results. Using a list control provides events that...
Provided by Susan Harkins
-
Downloads
Log errors in Microsoft Access with a simple function
Oct 2008
If you Google "error logging in Microsoft Access," you'll find a number of complex solutions. The process doesn't have to that difficult. Most of us need only a simple function to log specific...
Provided by Susan Harkins
-
Downloads
How do I... Retrieve a random set of records in Microsoft Access?
Oct 2007
We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. In this How do...
Provided by Susan Harkins
-
Book chapters
Communicate clearly and immediately with proper dashboard design
May 2006
This chapter from Information Dashboard Design: The Effective Visual Communication of Data explores the potential communicative power of a visual dashboard and the pitfalls that have prevented the...
Provided by O'Reilly Media
-
Downloads
Sample Excel invoice
Mar 2001
Drop-down menus are great for ensuring accurate data entry in Excel. Here is a sample invoice that illustrates how data validation can be used to create these handy tools.
Provided by TechRepublic
-
Downloads
How do I... Add custom error handling to my Access forms and reports?
Jul 2007
Access is designed to handle action errors -- such as those that occur when someone tries to add a record without filling in required fields -- without any help from you. But when you need a...
Provided by Susan Harkins
-
Downloads
Anatomy of Excel data analysis: Creating and modifying simple graphs
Dec 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
Get the most from your Excel charts with these five tips
Nov 2005
This download provides five powerful tips to help you create strong Excel charts. Visual aids make complicated data more understandable. Excel's pie charts, bar graphs, line charts and other...
Provided by TechRepublic
-
Book chapters
Unleash the power of SQL Server Management Studio, Query Analyzer, and Visual Studio with these essential tools
Sep 2007
Master SQL Server Management Studio, Query Analyzer, and Visual Studio tools in this chapter download from Microsoft SQL Server 2005 Compact Edition. First, learn how to use SQL Server Management...
Provided by Sams Publishing
-
Downloads
Big Data Primer for IT Pros
Nov 2012
This primer introduces the host of issues IT leaders must understand as they evaluate their organizations' needs and move forward with Big Data initiatives.
Provided by TechRepublic Pro
-
Downloads
Trends that will change business intelligence in 2012
Jan 2012
The world of business intelligence is radically changing. See how the cloud, social media, mobile adoption, open source, and data growth are transforming BI.
Provided by Robert Eugene Miller
-
Downloads
The Metrics Of IT: Management By Measurement
Apr 2011
Good metrics should be used to guide the development of strategic objectives, narrow investment opportunities to minimize wasted capital, and continually evaluate status to ensure that progress is...
Provided by TechRepublic Pro
-
Downloads
10 efficient ways to produce useful metrics
Mar 2011
Accurate metrics are essential for assessing performance and making informed decisions, but companies often rely on flawed information that paints a misleading picture. Alan Norton explains the...
Provided by Alan Norton
-
Downloads
10 tips for choosing between a surrogate and natural primary key
Mar 2011
The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when -- and why -- you might choose one over the...
Provided by Susan Harkins
-
Downloads
Scaling that mountain of data: 10 questions on records management with Kon Leong
Feb 2011
Kon Leong, CEO of ZL Technologies, shares his insights on the biggest changes and trends in the rapidly escalating area of records management.This download is also available as an entry in our 10...
Provided by Jeff Cerny
-
Downloads
10+ ways to screw up your database design
Oct 2010
Database developers often fall into certain design traps -- and it's generally the users who pay the price. See how you can improve your design process and build a more flexible, reliable, and...
Provided by Susan Harkins
-
Downloads
10+ reasons to split an Access database
Oct 2009
Splitting your Access database offers numerous advantages, including increased flexibility, security, efficiency, and scalability.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Downloads
10+ tips for working smarter with SQL
Jun 2009
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.This download is also available as an entry in our 10...
Provided by Susan Harkins
-
Downloads
How to print multiple labels for a single record in Access
Feb 2009
Label printing is often more complex than generating a single label for each record. Users might need one label for multiple records or multiple labels for one record -- or something in between....
Provided by Susan Harkins
-
Downloads
Log errors in Microsoft Access with a simple function
Oct 2008
If you Google "error logging in Microsoft Access," you'll find a number of complex solutions. The process doesn't have to that difficult. Most of us need only a simple function to log specific...
Provided by Susan Harkins
-
Downloads
How to list the primary key columns in an Access table
Oct 2008
You can get a list of the columns in a primary key manually, but depending on the task, you may want to handle it programmatically instead. Susan Harkins shares a VBA function that uses ADOX...
Provided by Susan Harkins
-
Downloads
10 reasons why IT pros hate Microsoft Access (but really shouldn't)
Jul 2008
Microsoft Access may not be right for all situations, but it does have its place -- at least according to database expert Susan Harkins. Here's her take on some of the more common complaints she's...
Provided by Susan Harkins
-
Book chapters
User beware: Electronic documents can reveal far more than you want
Jul 2008
The WYSIWYG mentality can be dangerous when users fail to understand what underlies the visible presentation of electronic data. This chapter from Blown to Bits: Your Life, Liberty, and Happiness...
Provided by Addison-Wesley
-
Downloads
10+ tips for getting the best performance out of your SQL Server data types
Jul 2008
Data integrity and performance are the driving force behind almost every decision you make during the design and development process. Defining appropriate data types is one of the easiest ways to...
Provided by Susan Harkins
-
Downloads
10 things that are [still] broken in Access 2007... and maybe in 2010
Sep 2009
In Access 2007, some things just don't work — and a few problems appear to be persisting in the 2010 Technical Preview.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Downloads
10 reasons to turn your Access applications into Web-based applications
Apr 2008
An Access database often outgrows its original purpose. When that happens, you face applying band-aid technology or upgrading to a more powerful database system, such as SQL Server Express or even...
Provided by Susan Harkins and Drew Wutka
-
Downloads
10 reasons to explicitly convert SQL Server data types
Mar 2008
SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's those surprise conversions that cause trouble....
Provided by Susan Harkins
-
Downloads
10+ things you should do before building a custom Access database
Mar 2008
Whether you take on freelance work or you support your organization's IT needs by developing custom database solutions, you must build an efficient, easy-to-use database if you plan to stay...
Provided by Susan Harkins
-
Downloads
How do I... Retrieve a random set of records in Microsoft Access?
Oct 2007
We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. In this How do...
Provided by Susan Harkins
-
Downloads
How do I... Print a label for an individual record in Microsoft Access?
Sep 2007
Printing labels using the Microsoft Access Label wizard is straightforward and relatively simple. But printing a label for a single record can be a bit more challenging. In this How do I..., Susan...
Provided by Susan Harkins
-
Book chapters
Unleash the power of SQL Server Management Studio, Query Analyzer, and Visual Studio with these essential tools
Sep 2007
Master SQL Server Management Studio, Query Analyzer, and Visual Studio tools in this chapter download from Microsoft SQL Server 2005 Compact Edition. First, learn how to use SQL Server Management...
Provided by Sams Publishing
-
Book chapters
Unlock the business value in unstructured data to make your company more competitive, responsive, and innovative
Aug 2007
Regardless of the type of business they do, most companies face a similar problem when it comes to business data analysis: large amounts of unstructured information and standard approaches to...
Provided by IBM Press
-
Downloads
How do I... Populate an Access list control with the results of a dynamic search?
Jul 2007
This tutorial and sample Access database will guide you through the process of setting up fixed queries to populate a list control with the query results. Using a list control provides events that...
Provided by Susan Harkins
-
Downloads
How do I... Add custom error handling to my Access forms and reports?
Jul 2007
Access is designed to handle action errors -- such as those that occur when someone tries to add a record without filling in required fields -- without any help from you. But when you need a...
Provided by Susan Harkins
-
Downloads
How do I... Query for multiple values in Access on the fly?
May 2007
When you need a flexible way to filter a form or report on multiple values, a fixed query isn't your best bet. Find out how you can use a VBA function to add a versatile query solution that can...
Provided by Susan Harkins
-
Downloads
10 MySQL variables that you should monitor
May 2007
The developers of MySQL have provided a fairly comprehensive list of performance variables that you can monitor in real time to check the health and performance of your MySQL server. We've listed...
Provided by Melonfire
-
Downloads
10+ tips for working efficiently in Access' Query Design window
Apr 2007
If you create Access queries, you probably know your way around the Query Design window. But there are some not-so-obvious tricks you can use to work more efficiently, maintain accuracy, and...
Provided by Susan Harkins
-
Downloads
How do I... Print a single Microsoft Access record in Form View?
Feb 2007
Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button, you...
Provided by Susan Harkins
-
Downloads
10 tips for using wildcard characters in Microsoft Access criteria expressions
Jan 2007
Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...
Provided by Susan Harkins
-
Book chapters
Use the GROUP BY clause to write SQL queries that group and aggregate data
Jan 2007
Introduction to SQL, long the definitive SQL tutorial for database professionals, has been updated to reflect the latest SQL standards and newest versions of today's leading RDBMSs: Oracle,...
Provided by Addison Wesley Professional
-
Downloads
Should you use SQL Server Express Edition or Microsoft Access for your small business applications?
Dec 2006
Small businesses that are considering adopting a database application have a variety of choices. IT pro Tim Chapman focuses on two of them--SQL Server Express edition and Microsoft Access--and...
Provided by Tim Chapman
-
Downloads
Three easy ways to optimize your MySQL queries
Nov 2006
Any database programmer will tell you that in high-traffic database-driven applications, a single badly-designed SQL query can significantly impact the overall performance of your application. Not...
Provided by Melonfire
-
Downloads
How do I... Create a crosstab query in Microsoft Access?
Sep 2006
Crosstab queries in Microsoft Access allow you to do what normal SELECT queries do not: aggregate data across columns as well as rows. This walkthough will show you how to use these unique...
Provided by Tim Chapman
-
Book chapters
Beat the odds at Texas Hold 'Em using inferential statistics and the "Rule of Four"
Jul 2006
Inferential statistics allow us to understand the way probability works, discover relationships, predict events with uncanny accuracy, and occasionally, even make a little money with a well-placed...
Provided by O'Reilly Media
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft Excel keyboard shortcuts
Apr 2005
GUIs make applications like Microsoft Excel much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some time....
Provided by TechRepublic Pro
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft PowerPoint keyboard shortcuts - PDF
Apr 2005
GUIs make applications like Microsoft PowerPoint much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some...
Provided by TechRepublic Pro
-
Downloads
TechRepublic Real World Guide: Recovering Windows Client Data
Oct 2005
When something goes wrong on your Windows workstation and you lose data, you need to have a strategy to get it back. This 17-page PDF gives you tips and tricks about what to do to recover lost...
Provided by TechRepublic Pro
-
Book chapters
Communicate clearly and immediately with proper dashboard design
May 2006
This chapter from Information Dashboard Design: The Effective Visual Communication of Data explores the potential communicative power of a visual dashboard and the pitfalls that have prevented the...
Provided by O'Reilly Media
-
Downloads
Anatomy of Excel formatting: Make better spreadsheet presentations - part 3
Sep 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
85 keyboard shortcuts for moving faster in Microsoft Excel
Apr 2006
Keyboard shortcuts can shave a surprising amount of time off the process of performing various Excel tasks. This list includes all the basics, along with those 'I know there's a way to do this...
Provided by TechRepublic
-
Downloads
10+ reasons to split an Access database
Oct 2009
Splitting your Access database offers numerous advantages, including increased flexibility, security, efficiency, and scalability.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Downloads
Access reference: Working with queries
Mar 2004
Putting data into a database is only part of the Access puzzle. Once the data's stored, your users will need to review it, analyze it, and even change it. This guide explains the key aspects of...
Provided by TechRepublic
-
Downloads
Support Republic's Ultimate Excel Compilation
Jun 2003
Don't wait for users to ask for advice; be proactive and help them improve their Excel skills with this compilation of Excel tips. This download contains over 100 pages of invaluable Excel advice...
Provided by TechRepublic
-
Downloads
Sample Excel invoice
Mar 2001
Drop-down menus are great for ensuring accurate data entry in Excel. Here is a sample invoice that illustrates how data validation can be used to create these handy tools.
Provided by TechRepublic
-
Downloads
Get the most from your Excel charts with these five tips
Nov 2005
This download provides five powerful tips to help you create strong Excel charts. Visual aids make complicated data more understandable. Excel's pie charts, bar graphs, line charts and other...
Provided by TechRepublic
-
Downloads
Export Excel comments to Word VBScript
Jun 2005
Excel's comment feature allows you to quickly and easily describe a cell's function or provide additional information. While printing these comments is relatively simple, getting them into a Word...
Provided by TechRepublic
-
Downloads
Anatomy of Word: Taking Word tables to the next level with spreadsheet techniques
Feb 2006
Word tables and Excel spreadsheets share a few things in common, such as the ability to perform calculations on numbers in each cell. This document explores these similarities and points out where...
Provided by TechRepublic
-
Downloads
10 things you can do to protect your data
Apr 2006
Operating systems and applications can always be reinstalled, but your data is unique--making it the most important thing on your computer or network. Here's a look at 10 ways you can protect that...
Provided by TechRepublic
-
Downloads
Anatomy of Excel formatting: Make better spreadsheet presentations - part 3
Sep 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
Downloads
Gain confidence in your presentations by following these tips
Aug 2005
For most of us, effective public speaking requires a bit of discipline, preparation, and practice. These suggestions will help you develop your delivery skills and overcome presentation jitters....
Provided by TechRepublic
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft Excel keyboard shortcuts
Apr 2005
GUIs make applications like Microsoft Excel much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some time....
Provided by TechRepublic Pro
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft PowerPoint keyboard shortcuts - PDF
Apr 2005
GUIs make applications like Microsoft PowerPoint much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some...
Provided by TechRepublic Pro
-
Downloads
TechRepublic Real World Guide: Recovering Windows Client Data
Oct 2005
When something goes wrong on your Windows workstation and you lose data, you need to have a strategy to get it back. This 17-page PDF gives you tips and tricks about what to do to recover lost...
Provided by TechRepublic Pro
-
Downloads
10+ ways to screw up your database design
Oct 2010
Database developers often fall into certain design traps -- and it's generally the users who pay the price. See how you can improve your design process and build a more flexible, reliable, and...
Provided by Susan Harkins
-
Book chapters
Beat the odds at Texas Hold 'Em using inferential statistics and the "Rule of Four"
Jul 2006
Inferential statistics allow us to understand the way probability works, discover relationships, predict events with uncanny accuracy, and occasionally, even make a little money with a well-placed...
Provided by O'Reilly Media
-
Book chapters
Use the GROUP BY clause to write SQL queries that group and aggregate data
Jan 2007
Introduction to SQL, long the definitive SQL tutorial for database professionals, has been updated to reflect the latest SQL standards and newest versions of today's leading RDBMSs: Oracle,...
Provided by Addison Wesley Professional
-
Downloads
10 MySQL variables that you should monitor
May 2007
The developers of MySQL have provided a fairly comprehensive list of performance variables that you can monitor in real time to check the health and performance of your MySQL server. We've listed...
Provided by Melonfire
-
Downloads
How do I... Add custom error handling to my Access forms and reports?
Jul 2007
Access is designed to handle action errors -- such as those that occur when someone tries to add a record without filling in required fields -- without any help from you. But when you need a...
Provided by Susan Harkins
-
Book chapters
Unleash the power of SQL Server Management Studio, Query Analyzer, and Visual Studio with these essential tools
Sep 2007
Master SQL Server Management Studio, Query Analyzer, and Visual Studio tools in this chapter download from Microsoft SQL Server 2005 Compact Edition. First, learn how to use SQL Server Management...
Provided by Sams Publishing
-
Downloads
How do I... Print a label for an individual record in Microsoft Access?
Sep 2007
Printing labels using the Microsoft Access Label wizard is straightforward and relatively simple. But printing a label for a single record can be a bit more challenging. In this How do I..., Susan...
Provided by Susan Harkins
-
Downloads
10+ things you should do before building a custom Access database
Mar 2008
Whether you take on freelance work or you support your organization's IT needs by developing custom database solutions, you must build an efficient, easy-to-use database if you plan to stay...
Provided by Susan Harkins
-
Downloads
10 reasons to turn your Access applications into Web-based applications
Apr 2008
An Access database often outgrows its original purpose. When that happens, you face applying band-aid technology or upgrading to a more powerful database system, such as SQL Server Express or even...
Provided by Susan Harkins and Drew Wutka
-
Downloads
10 things that are [still] broken in Access 2007... and maybe in 2010
Sep 2009
In Access 2007, some things just don't work — and a few problems appear to be persisting in the 2010 Technical Preview.This download is also available as an entry in our 10 Things blog.
Provided by Susan Harkins
-
Book chapters
User beware: Electronic documents can reveal far more than you want
Jul 2008
The WYSIWYG mentality can be dangerous when users fail to understand what underlies the visible presentation of electronic data. This chapter from Blown to Bits: Your Life, Liberty, and Happiness...
Provided by Addison-Wesley
-
Downloads
10 reasons why IT pros hate Microsoft Access (but really shouldn't)
Jul 2008
Microsoft Access may not be right for all situations, but it does have its place -- at least according to database expert Susan Harkins. Here's her take on some of the more common complaints she's...
Provided by Susan Harkins
-
Downloads
How to list the primary key columns in an Access table
Oct 2008
You can get a list of the columns in a primary key manually, but depending on the task, you may want to handle it programmatically instead. Susan Harkins shares a VBA function that uses ADOX...
Provided by Susan Harkins
-
Downloads
How to print multiple labels for a single record in Access
Feb 2009
Label printing is often more complex than generating a single label for each record. Users might need one label for multiple records or multiple labels for one record -- or something in between....
Provided by Susan Harkins
-
Downloads
Trends that will change business intelligence in 2012
Jan 2012
The world of business intelligence is radically changing. See how the cloud, social media, mobile adoption, open source, and data growth are transforming BI.
Provided by Robert Eugene Miller
-
Downloads
10 tips for choosing between a surrogate and natural primary key
Mar 2011
The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when -- and why -- you might choose one over the...
Provided by Susan Harkins
-
Downloads
10 reasons to explicitly convert SQL Server data types
Mar 2008
SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's those surprise conversions that cause trouble....
Provided by Susan Harkins
-
Book chapters
Unlock the business value in unstructured data to make your company more competitive, responsive, and innovative
Aug 2007
Regardless of the type of business they do, most companies face a similar problem when it comes to business data analysis: large amounts of unstructured information and standard approaches to...
Provided by IBM Press
-
Downloads
Should you use SQL Server Express Edition or Microsoft Access for your small business applications?
Dec 2006
Small businesses that are considering adopting a database application have a variety of choices. IT pro Tim Chapman focuses on two of them--SQL Server Express edition and Microsoft Access--and...
Provided by Tim Chapman
-
Downloads
How do I... Populate an Access list control with the results of a dynamic search?
Jul 2007
This tutorial and sample Access database will guide you through the process of setting up fixed queries to populate a list control with the query results. Using a list control provides events that...
Provided by Susan Harkins
-
Downloads
Scaling that mountain of data: 10 questions on records management with Kon Leong
Feb 2011
Kon Leong, CEO of ZL Technologies, shares his insights on the biggest changes and trends in the rapidly escalating area of records management.This download is also available as an entry in our 10...
Provided by Jeff Cerny
-
Downloads
10+ tips for working efficiently in Access' Query Design window
Apr 2007
If you create Access queries, you probably know your way around the Query Design window. But there are some not-so-obvious tricks you can use to work more efficiently, maintain accuracy, and...
Provided by Susan Harkins
-
Downloads
10+ tips for getting the best performance out of your SQL Server data types
Jul 2008
Data integrity and performance are the driving force behind almost every decision you make during the design and development process. Defining appropriate data types is one of the easiest ways to...
Provided by Susan Harkins
-
Downloads
Big Data Primer for IT Pros
Nov 2012
This primer introduces the host of issues IT leaders must understand as they evaluate their organizations' needs and move forward with Big Data initiatives.
Provided by TechRepublic Pro
-
Downloads
How do I... Print a single Microsoft Access record in Form View?
Feb 2007
Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button, you...
Provided by Susan Harkins
-
Downloads
10 tips for using wildcard characters in Microsoft Access criteria expressions
Jan 2007
Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...
Provided by Susan Harkins
