- Subscribe to this page:
- RSS
- Email Alert
database applications
(83 results)-
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
Preparing for Exchange Server 2010
Dec 2009
This table is a companion piece to Scott Lowe's column, "Preparing for Exchange Server 2010's hardware and software requirements." The table provides you with a starting point in your Exchange RAM...
Provided by Scott Lowe
-
Downloads
Lunch and Learn: Microsoft Access 2007 Intermediate Skills
Sep 2007
This Microsoft Access 2007 Intermediate Skills presentation provides a preformatted presentation for helping staff better leverage the database application's capabilities. It covers such things as...
Provided by TechRepublic Pro
-
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
How do I... Transfer data from a Word form to an Access database?
Jan 2008
Although Access forms are powerful interface objects, your users might not be familiar with them. However, your users may be very familiar with Word forms. Susan Sales Harkins shows you how to use...
Provided by Susan Harkins
-
Downloads
Lunch and Learn: Microsoft Access 2007 Basics
Sep 2007
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentation contains everything you...
Provided by TechRepublic Pro
-
Downloads
10+ tips for designing flexible and efficient Access tables
Mar 2007
The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...
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
A simple solution for tracking changes to Access data
Mar 2007
When you have a lot of users changing data, it's easy for things to go wrong. But if you keep an audit trail of data input changes, you'll be able to determine which operators are consistently...
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+ 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 with dates in Microsoft Access
Nov 2006
Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. Database expert Susan...
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
10 tricks for handling null values in Microsoft Access
Oct 2006
Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...
Provided by Susan Harkins
-
Downloads
How do I... Configure transactional replication between two SQL Server 2005 systems?
Aug 2007
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical...
Provided by Josh Hoskins
-
Downloads
Understand schema-based XML filtering
Feb 2010
Edmond Woychowsky shares code that creates XSL using an XML schema. He says that using the code as a starting point when dealing with BizTalk may help you keep your sanity.This download is also...
Provided by Edmond Woychowsky
-
Downloads
Designing database applications for optimal performance
Jun 2009
In his book review of Prentice Hall's The Data Access Handbook, TechRepublic blogger Justin James notes that chapter two provided him with more information about database connectivity than he...
Provided by Prentice Hall PTR
-
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
How do I... fill Word form fields with Access data?
Jun 2007
Filling a Word form with Access data can be useful when you need to use Word's formatting features to present that data in just the right way. Fortunately, the process is simple, whether sharing...
Provided by Susan Harkins
-
Downloads
How do I... Dynamically fill Microsoft Word fields using Access data?
Aug 2007
Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame. Fortunately, Office...
Provided by Susan Harkins
-
Downloads
How do I... Query foreign data using SQL Server's linked servers?
Jul 2007
Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest...
Provided by Susan Harkins
-
Downloads
How do I... Fill a Word table with Access data?
Mar 2008
Almost effortless collaboration is a key selling point for Microsoft Office: If the data already exists in one format, why re-enter it in another. Usually Office delivers nicely on its promise....
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
-
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+ things I can never find in Access 2007 and 2010
Aug 2010
Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.This download is also...
Provided by Susan Harkins
-
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
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 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 key enhancements in Access 2007
Jun 2007
The Microsoft Access development team added more features to Access 2007 than perhaps to any other previous version. You'll definitely want to see what all the buzz is about around this latest...
Provided by Jeff Conrad
-
Downloads
Microsoft Access 2007 Advanced Functionality Lunch And Learn
Jan 2008
This Microsoft Access 2007 - Advanced Functionality presentation is a preformatted solution for training staff to maximize Microsoft Access's more advanced functions. The accompanying reference...
Provided by TechRepublic Pro
-
Downloads
How do I... Select records for a dynamic label report in Access?
Nov 2007
Generating reports is a big part of most database applications. Generally, a query or filter does a good job of passing only the data you want to see to the report. But it isn't always that easy....
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 use Access (and a few reasons not to)
Aug 2008
Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the...
Provided by Susan Harkins
-
Downloads
10 tips for sorting, grouping, and summarizing SQL data
Nov 2006
Arranging data in a manner that's meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more—you need groups you can analyze and summarize. Fortunately, SQL...
Provided by Susan Harkins
-
Downloads
Use this simple Access application to catalog MP3s and other files
Nov 2006
IT pro Tim Chapman created a handy application that makes it easy to generate a listing of files in a specified folder. He originally wrote the app so he could build an Access table containing his...
Provided by Tim Chapman
-
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
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
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
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
An updated guide to Microsoft software versions
Dec 2010
In this Excel table, Scott Lowe lists numerous versions of Windows, SQL Server, Exchange, System Center Configuration Manager, System Center Data Protection Manager, and System Center Operations...
Provided by Scott Lowe
-
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+ things I can never find in Access 2007 and 2010
Aug 2010
Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.This download is also...
Provided by Susan Harkins
-
Downloads
Understand schema-based XML filtering
Feb 2010
Edmond Woychowsky shares code that creates XSL using an XML schema. He says that using the code as a starting point when dealing with BizTalk may help you keep your sanity.This download is also...
Provided by Edmond Woychowsky
-
Downloads
Preparing for Exchange Server 2010
Dec 2009
This table is a companion piece to Scott Lowe's column, "Preparing for Exchange Server 2010's hardware and software requirements." The table provides you with a starting point in your Exchange RAM...
Provided by Scott Lowe
-
Downloads
SharePoint 2007 Reference Guide
Dec 2009
Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule. This reference guide is a collection...
Provided by TechRepublic Pro
-
Downloads
Learn to use Git version control for added flexibility
Nov 2009
Vincent Danen introduces Git, a distributed version control system that gains extra flexibility from being free of a central server, like Subversion or CVS. Here are some of the features that set...
Provided by Vincent Danen
-
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
Avoid import glitches when bringing Excel data into Access
Sep 2009
Importing data from Excel to Access can be somewhat dicey. These pointers will help you prepare your data and sidestep common import problems.This download is also available as an entry in our...
Provided by Susan Harkins
-
Downloads
Designing database applications for optimal performance
Jun 2009
In his book review of Prentice Hall's The Data Access Handbook, TechRepublic blogger Justin James notes that chapter two provided him with more information about database connectivity than he...
Provided by Prentice Hall PTR
-
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 do I... Configure SQL Mail in SQL Server 2000?
Mar 2009
SQL Mail is a component of SQL Server that allows you to send and receive e-mail by working side by side with a mail server. Steven Warren describes the possibilities of SQL Mail and explains how...
Provided by Steven Warren
-
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
Improve MySQL performance with MySQLTuner
Oct 2008
Vincent Danen covers the basics of the MySQL Tuner tool, which analyzes your configuration and suggests changes that will boost the performance of your MySQL installation.
Provided by Vincent Danen
-
Downloads
Return to the record you were working on when you reopen an Access form
Aug 2008
If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight...
Provided by Susan Harkins
-
Downloads
10+ reasons to use Access (and a few reasons not to)
Aug 2008
Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the...
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
-
Downloads
How do I... Reseed a SQL Server identity column?
Jul 2008
Microsoft SQL Server's identity column generates sequential values for new records using a seed value. You can control the column's first and subsequent values, by specifying those values when you...
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
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
How do I... Identify and delete duplicates from SQL Server tables?
Jun 2008
Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. The good news is that...
Provided by Susan Harkins
-
Downloads
How do I... Replace a complex connection string with a DSN?
May 2008
Technically speaking, a Data Source Name (DSN) is an identifier to a data source for an Open Data Base Connectivity (ODBC) driver (library). ODBC is a function library that interfaces between the...
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
IT Hiring Kit: SQL Server Database Administrator
Apr 2008
New version designed especially for SQL Server DBAs! The IT Hiring Kit for SQL Server Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA...
Provided by TechRepublic Pro
-
Downloads
IT Hiring Kit: Oracle Database Administrator
Apr 2008
New version designed especially for Oracle DBAs! The IT Hiring Kit for Oracle Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA position. This...
Provided by TechRepublic Pro
-
Downloads
How do I... Fill a Word table with Access data?
Mar 2008
Almost effortless collaboration is a key selling point for Microsoft Office: If the data already exists in one format, why re-enter it in another. Usually Office delivers nicely on its promise....
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
-
Downloads
Lunch And Learn: Get Up To Speed On OpenOffice Base
Mar 2008
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with the database component of OpenOffice - Base. Everything is...
Provided by TechRepublic Pro
-
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... Add items to an Access combo box on the fly?
Feb 2008
On occasion, an application developer working with Microsoft Access may need a list control that's a bit more flexible by allowing users to update the control's list. Handing over a bit of...
Provided by Susan Harkins
-
Downloads
How do I... Reject alpha characters in a SQL Server character column?
Jan 2008
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your...
Provided by Susan Harkins
-
Downloads
How do I... Display multiple values in an Access value list control?
Jan 2008
You can populate a list control with an explicit list of values and generally, that list consists of one column, although you can display more. Creating a multi-column value list control is the...
Provided by Susan Harkins
-
Downloads
How do I... Pass data over a network using disconnected recordsets?
Jan 2008
Retrieving data across a busy network can put a real cramp in your networking performance. Dragging only the data you actually need and only when you need it is the key to working efficiently...
Provided by Susan Harkins
-
Downloads
How do I... Transfer data from a Word form to an Access database?
Jan 2008
Although Access forms are powerful interface objects, your users might not be familiar with them. However, your users may be very familiar with Word forms. Susan Sales Harkins shows you how to use...
Provided by Susan Harkins
-
Downloads
How do I... Base a control's default value on data input?
Dec 2007
One of the most common ways to reduce data input is to provide a default value -- the most common value --for input controls. That way, when the value equals the default value, the user simply...
Provided by Susan Harkins
-
Downloads
How do I... Transfer Access data to an Outlook contact?
Dec 2007
How you use data often determines where you store it, which can create a bit of trouble down the line. For instance, you might store contact information in an Access database. If you want the same...
Provided by Susan Harkins
-
Downloads
How do I... Install and configure Spotlight on SQL Server?
Dec 2007
For database administrators, peak performance of their SQL Servers is always a priority. Spotlight on SQL Server from Quest Software is a tool to help SQL Server DBA's monitor the performance of...
Provided by Josh Hoskins
-
Downloads
Designing database applications for optimal performance
Jun 2009
In his book review of Prentice Hall's The Data Access Handbook, TechRepublic blogger Justin James notes that chapter two provided him with more information about database connectivity than he...
Provided by Prentice Hall PTR
-
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
Learn to use Git version control for added flexibility
Nov 2009
Vincent Danen introduces Git, a distributed version control system that gains extra flexibility from being free of a central server, like Subversion or CVS. Here are some of the features that set...
Provided by Vincent Danen
-
Downloads
SharePoint 2007 Reference Guide
Dec 2009
Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule. This reference guide is a collection...
Provided by TechRepublic Pro
-
Downloads
Preparing for Exchange Server 2010
Dec 2009
This table is a companion piece to Scott Lowe's column, "Preparing for Exchange Server 2010's hardware and software requirements." The table provides you with a starting point in your Exchange RAM...
Provided by Scott Lowe
-
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+ things I can never find in Access 2007 and 2010
Aug 2010
Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.This download is also...
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
An updated guide to Microsoft software versions
Dec 2010
In this Excel table, Scott Lowe lists numerous versions of Windows, SQL Server, Exchange, System Center Configuration Manager, System Center Data Protection Manager, and System Center Operations...
Provided by Scott Lowe
-
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
Protect sensitive Web site data by encrypting information with MySQL
Oct 2006
Securing Web site data stored in MySQL from hackers or snoopers is a critical concern, both to avoid unauthorized use or damage to your application and to retain your competitive advantage. MySQL...
Provided by Melonfire
-
Downloads
10 tricks for handling null values in Microsoft Access
Oct 2006
Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...
Provided by Susan Harkins
-
Downloads
10 tips for sorting, grouping, and summarizing SQL data
Nov 2006
Arranging data in a manner that's meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more—you need groups you can analyze and summarize. Fortunately, SQL...
Provided by Susan Harkins
-
Downloads
Use this simple Access application to catalog MP3s and other files
Nov 2006
IT pro Tim Chapman created a handy application that makes it easy to generate a listing of files in a specified folder. He originally wrote the app so he could build an Access table containing his...
Provided by Tim Chapman
-
Downloads
10 tips for working with dates in Microsoft Access
Nov 2006
Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. Database expert Susan...
Provided by Susan Harkins
-
Book chapters
Master the basics of designing relational databases with Visual Studio and SQL Server 2005
Nov 2006
For the most part, the process of creating a database is hidden from us by a database application's IDE: we just use drag-and-drop or use wizards to build the databases and tables we want. This...
Provided by Addison Wesley Professional
-
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
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
-
Book chapters
Administer SQL Server 2005 Express Edition
Dec 2006
SQL Server Express is a free, easy-to-use, simple-to-manage database without many of the features of the full-blown SQL Server, but powerful and flexible enough to meet the needs of low-end...
Provided by Sybex
-
Downloads
10 tips for customizing menus and toolbars in your Access apps
Jan 2007
When you build an Access application, you'll generally want to tailor the menus and toolbars so that users have all the tools they need but won't stumble over the built-in options. Access expert...
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
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
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 designing flexible and efficient Access tables
Mar 2007
The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...
Provided by Susan Harkins
-
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 creating efficient Microsoft Access list box controls
Apr 2007
Efficiency isn't always about performance -- sometimes, it's a about making tasks easier for end users. See how the effective design and implementation of list box and combo box controls in your...
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
Lunch and Learn: Get up to speed on Microsoft Access 2007
Apr 2007
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with Access 2007. Everything is ready to be used even if you...
Provided by TechRepublic Pro
-
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
How do I... Obtain and use information about runtime errors in Access applications?
May 2007
To make sure a runtime error doesn't derail your Access applications, you should include error handling that ignores or fixes the error and continues processing, requests information from the user...
Provided by Susan Harkins
-
Downloads
10 key enhancements in Access 2007
Jun 2007
The Microsoft Access development team added more features to Access 2007 than perhaps to any other previous version. You'll definitely want to see what all the buzz is about around this latest...
Provided by Jeff Conrad
-
Downloads
How do I... fill Word form fields with Access data?
Jun 2007
Filling a Word form with Access data can be useful when you need to use Word's formatting features to present that data in just the right way. Fortunately, the process is simple, whether sharing...
Provided by Susan Harkins
-
Downloads
A couple of MySQL stored procedures myths get busted
Jun 2007
Two often repeated myths about MySQL stored procedures include (1) MySQL does not support stored procedures and (2) MySQL stored procedures are too difficult to work with under typical...
Provided by Edmond Woychowsky
-
Downloads
How do I... Query foreign data using SQL Server's linked servers?
Jul 2007
Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest...
Provided by Susan Harkins
-
Downloads
TechRepublic's Access 2003 Lunch and Learn collection
Jul 2007
You can use this collection of TechRepublic Lunch and Learns to get users up to speed quickly on Microsoft Access 2003. This download contains the following five Lunch and Learn presentations:...
Provided by TechRepublic Pro
-
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... 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
Lunch and Learn: Microsoft Access 2007 Basics
Sep 2007
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentation contains everything you...
Provided by TechRepublic Pro
-
Downloads
How do I... Dynamically fill Microsoft Word fields using Access data?
Aug 2007
Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame. Fortunately, Office...
Provided by Susan Harkins
-
Downloads
Lunch and Learn: Microsoft Access 2007 Intermediate Skills
Sep 2007
This Microsoft Access 2007 Intermediate Skills presentation provides a preformatted presentation for helping staff better leverage the database application's capabilities. It covers such things as...
Provided by TechRepublic Pro
