• Drop-down Menus on Database Forms

    Updated: 2010-01-31 10:06:14
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Drop-down Menus on Database Forms Sunday January 31, 2010 In a recent forum message Kimmy wrote : Can anyone help me with creating drop down menus on forms that pull from tables with corresponding information according to previous drop down menu selection Basically I am creating a form that has 2 drop down menu fields and another field for description . The first one is for the Tool Name . The second one would be the Tool ID list but I dont want to have all the numbers listed for all the tools just the options for the specific tool I selected . The third would pull the description of the specific Tool Name Tool ID Is this possible If so how would I accomplish this Would I need to build a DB with all the tool information in it first Can you help Kimmy Interested in solutions to the same issue Visit the About Databases forum and join the discussion Comments 0 See All Posts Share Prev Comments No

  • Case Study: Online Database Applications at Procter & Gamble

    Updated: 2010-01-28 15:07:56
    By now you would think we had heard it all from our customers – “streamlined operations”, “increased visibility”, “enhanced collaboration” – this is what QuickBase and online database applications do best.  But this particular customer story truly is staggering.  Procter & Gamble’s GBS Project Management Organization (PMO) has saved significant operational costs, reduced 18-24 full [...]

  • Controlling Checkboxes with Form Rules

    Updated: 2010-01-28 14:42:20
    We got a request from a QuickBase enthusiast today that has a form with four check box fields representing, North, South, East and West. When he checked North, he wants the other South, East and West options to disappear and if unchecked to make them reappear. Definitely something QuickBase can do with a few form [...]

  • Getting Started with Data Mining

    Updated: 2010-01-28 06:26:31
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Getting Started with Data Mining Thursday January 28, 2010 Data mining products are taking the industry by storm . The major database vendors have already taken steps to ensure that their platforms incorporate data mining techniques . Oracle's Data Mining Suite Darwin implements classification and regression trees , neural networks , k-nearest neighbors , regression analysis and clustering algorithms . Microsoft's SQL Server also offers data mining functionality through the use of classification trees and clustering algorithms . If you're already working in a statistics environment , you're probably familiar with the data mining algorithm implementations offered by the advanced statistical packages SPSS , SAS , and S-Plus . Learn more about data mining software and techniques in Data Mining : An Introduction Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a

  • Quick Update on QuickBooks Premier 2010 at TechSoup

    Updated: 2010-01-26 17:36:41
    While we already have a wide selection of donations available to help with your organization's finances, some of you may be wondering about the availability of Intuit's QuickBooks Premier 2010.We don't have the specifics just yet, though TechSoup did make the request to Intuit for QuickBooks Premier 2010 1-user, 3-user, and Mac editions, as we understand the relevance of this updated version especially in light of Windows 7 compatibility. read more

  • Creating a custom login for your website

    Updated: 2010-01-26 15:20:53
    QuickBase is web based so much of what we would like to customize with QuickBase can be done using basic html. For instance if you want to add a custom QuickBase login right on one of your company’s web pages, you can do it by adding some simple html code to produce the following form. This is [...]

  • Change Data Capture in Microsoft SQL Server

    Updated: 2010-01-26 06:24:58
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Change Data Capture in Microsoft SQL Server Tuesday January 26, 2010 With the release of SQL Server 2008, Microsoft included Change Data Capture CDC functionality for the first time . This highly anticipated feature provides administrators with the ability to perform detailed auditing of database changes . Read the full story : Change Data Capture in Microsoft SQL Server Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read Responses 29 Add Your Response Recent Blog Comments Marching Band Database Payroll Database in Microsoft Access Creating a Database with

  • New Year's Technology Resolution #3: This Year, We Will Manage Our Finances Better

    Updated: 2010-01-25 19:09:07
    2010 is the year to make sure your finances are in tip-top shape, and TechSoup is here to help. For all your organization's accounting and finance needs, from banking and expense reports to donations processing, inventory tracking, and payroll, we have the software and learning tools to help your small to medium organization comfortably manage its finances. We've compiled this list of our most popular accounting and finance software, along with TechSoup's resources, to help you choose the software that puts your organization on track to meet its financial fitness goals. <a href="http://blog.techsoup.org/node/1136"read more

  • Definitions of Non-blocking, Lock-free and Wait-free

    Updated: 2010-01-25 11:50:03
    , , J ust S oftware S olutions just : thread C++0x Thread Library Call Us on 0845 053 0 350 Or email us for Custom Software Development About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives January 2010 3 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which lies just 4 miles from our office in West . Cornwall Design and Content Copyright 2005-2010 Just Software Solutions Ltd . All rights . reserved Sea Shell Photo Copyright MarieC Definitions of Non-blocking , Lock-free and Wait-free Monday , 25 January 2010 There was a post on comp.programming.threads this morning asking for a definition of these terms . To write good multithreaded code you really need to understand what these mean , and how they affect the behaviour and performance

  • Netezza Skimmer

    Updated: 2010-01-25 06:39:00
    As I previously complained, last week wasn’t a very convenient time for me to have briefings. So when Netezza emailed to say it would release its new entry-level Skimmer appliance this morning, while I asked for and got a Friday afternoon briefing, I kept it quick and basic. That said, highlights of my Netezza Skimmer briefing [...]

  • Join Climate Savers Computing Initiative

    Updated: 2010-01-25 05:55:19
    If you'd like to advocate for green IT and add your weight to the IT energy conservation movement, join Climate Savers Computing Initiative. It is no cost, and simply entails that you set power management on your computers.  read more

  • Printing Database Records

    Updated: 2010-01-24 19:31:36
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Printing Database Records Sunday January 24, 2010 In a recent forum message Don wrote : I am in the process of creating a client intake database based upon an extensive 5-page form that covers everything from basic information to criminal history to medical information . I have naturalized it as best I can by using tabs that relate to the different categories of client information . The input forms are based on , and look like the original forms albeit broken up into the various tabs . Each record has a unique client number and all the tabbed subforms relate to this number . In effect , the darn thing works correctly Where I'm having problems is in attempting to generate a print-out of all the information unique to the individual client so that it looks like the original 5-page document . I've tried creating a query that incorporates all the tables and by building a report that looks like the

  • Two cornerstones of Oracle’s database hardware strategy

    Updated: 2010-01-22 00:59:23
    After several months of careful optimization, Oracle managed to pick the most inconvenient* day possible for me to get an Exadata update from Juan Loaiza. But the call itself was long and fascinating, with the two main takeaways being: Oracle thinks flash memory is the most important hardware technology of the [...]

  • ACCDB File Format

    Updated: 2010-01-21 06:32:16
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS ACCDB File Format Thursday January 21, 2010 The release of Access 2007 brought us a new file format . The MDB database files we've known for over a decade are now slated to become historical relics . While Access 2007 continues to support MDB databases for backwards compatibility purposes , Microsoft has now introduced the new ACCDB file format as the new standard . Wondering if you should begin using the ACCDB format Read the full article : ACCDB Frequently Asked Questions Comments 0 See All Posts Share Prev Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read Responses 29 Add Your Response Recent

  • Alagad is Hiring a User Interface Designer

    Updated: 2010-01-20 20:17:43
    Corporate Site Contact Projects Blog Blog Author : Doug Hughes Doug Hughes is a veteran programmer who founded Alagad after briefly flirting with a career in computer animation . Doug has a strong record of achievement with large , complex web applications . His ability to learn and apply new technologies and techniques has helped Doug become one of the web application development industry’s most highly regarded . experts Doug’s current focus at Alagad is leading an application development team dedicated to helping organizations improve operational efficiency and performance . This commitment to client success has helped Alagad achieve record growth . A frequent speaker at industry conferences and user groups , Doug also regularly contributes to several well-known open source projects . In addition , his articles have been featured in numerous technical . publications Categories 83 entries Alagad 12 entries Ant 167 entries ColdFusion 10 entries ColdSpring 20 entries Conferences and Events 1 entries Development Tools 5 entries Dynamic Programming 1 entries Flexmaniacs 52 entries General 4 entries Groovy 5 entries JRun 16 entries Jobs 17 entries Model-Glue 27 entries OO Development

  • Euro Formatted Date Fields

    Updated: 2010-01-20 17:45:09
    An Australian QuickBase customer asked today, “How can we change the 01-20-2010 (U.S. date format) to the Euro 20-01-2010 format?”. They want their reports to display in a format that is customary for their country and locale. Well you can if you add a formula text field and reformat the date. See Video There is [...]

  • Normalizing Microsoft Access Databases

    Updated: 2010-01-19 06:31:39
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Normalizing Microsoft Access Databases Tuesday January 19, 2010 If you've been working with databases for a while , chances are you've heard the term normalization . Perhaps someone's asked you Is that database normalized or Is that in BCNF All too often , the reply is Uh , yeah . Normalization is often brushed aside as a luxury that only academics have time for . However , knowing the principles of normalization and applying them to your daily database design tasks really isn't all that complicated and it could drastically improve the performance of your DBMS . Read the full article : Normalizing a Database Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things

  • links for 2010-01-18

    Updated: 2010-01-18 14:04:10
    8 Top Twitter Track Tools to Organize the People You Follow The proliferation of tools created to support Twitter is astounding due to the [...]

  • Three broad categories of data

    Updated: 2010-01-17 07:31:24
    People often try to draw a distinction between: Traditional data of the sort that’s stored in relational databases, aka “structured.” Everything else, aka “unstructured” or “semi-structured” or “complex.” There are plenty of problems with these formulations, not the least of which is that the supposedly “unstructured” data is the kind that actually tends to have interesting internal structures. [...]

  • Linking Excel and Access

    Updated: 2010-01-17 06:29:41
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Linking Excel and Access Sunday January 17, 2010 In a recent forum message Lodi0080 wrote : I have an access 2007 database table linked to an excel spreadsheet . however , if the database is opened , I cannot open the excel spreadsheet . it says the file is in use . If i open the excel spreadsheet before i open the database , the file doesn't allow me to save . I want to allow users to access the database not modifying while I could be updating the spreadsheet . Is this possible I have researched the issue and found no solutions . Do you have any advice for Lodi Interested in solutions to the same problem Visit the About Databases Forum and join the discussion Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for

  • Vertica slaughters Sybase in patent litigation

    Updated: 2010-01-15 05:07:32
    Back in August, 2008, I pooh-poohed Sybase’s patent lawsuit against Vertica. Filed in the notoriously patent-holder-friendly East Texas courts, the suit basically claimed patent rights over the whole idea of a columnar RDBMS. It was pretty clear that this suit was meant to be a model for claims against other columnar RDBMS vendors as well, [...]<img src="http://feeds.feedburner.com/~r/MonashInformationServices/~4/PoZINRSpUmk" height="1" width="1"/

  • Intersystems Cache’ highlights

    Updated: 2010-01-15 00:07:25
    I talked with Robert Nagle of Intersystems last week, and it went better than at least one other Intersystems briefing I’ve had. Intersystems’ main product is Cache’, an object-oriented DBMS introduced in 1997 (before that Intersystems was focused on the fourth-generation programming language M, renamed from MUMPS). Unlike most other OODBMS, Cache’ is used for [...]

  • Improved Website Search Experience

    Updated: 2010-01-14 15:35:59
    I’m pleased to announce that this week, the QuickBase team rolled out some improvements to the search functionality of the QuickBase website. For those of you familiar with QuickBase, you may have used the search in the past to search the QuickBase Help documentation or many of our other support resources using the search box [...]

  • Database Security and PCI DSS

    Updated: 2010-01-14 06:45:43
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Database Security and PCI DSS Thursday January 14, 2010 The Payment Card Industry Data Security Standard PCI DSS sets forth the security requirements for organizations that store , process and or transmit credit or debit card transactions . These requirements stem from a series of significant security incidents affecting databases of consumer credit information over the past decade . What does PCI DSS mean to you as a database professional If you review the PCI DSS standard , you'll find seventeen pages packed with detailed requirements for securing cardholder information . If your organization processes transactions , it's a good idea to review the entire standard and ensure you're meeting all of those requirements . That said , I'll highlight a few salient points that pertain directly to database professionals . Read the full article : PCI DSS for Database Professionals Comments 0 See All Posts

  • just::thread C++0x Thread Library V1.3 Released

    Updated: 2010-01-13 17:07:05
    : , J ust S oftware S olutions just : thread C++0x Thread Library Call Us on 0845 053 0 350 Or email us for Custom Software Development About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives January 2010 3 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which lies just 4 miles from our office in West . Cornwall Design and Content Copyright 2005-2010 Just Software Solutions Ltd . All rights . reserved Sea Shell Photo Copyright MarieC just : thread C++0x Thread Library V1.3 Released Wednesday , 13 January 2010 I am pleased to announce that version 1.3 of just : thread our C++0x Thread Library has just been . released This release is the first to feature support for the new std : async function for starting asynchronous tasks . This

  • Counting Records in SQL

    Updated: 2010-01-12 06:43:58
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Counting Records in SQL Tuesday January 12, 2010 The COUNT( function in SQL allows you to count database records based upon a variety of criteria . You can use it to count all records in a table , count unique values in a column or count the number of times records occur that meet certain criteria . This tutorial takes a brief look at each of these scenarios . Read the full story : Counting Records in SQL Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read Responses 29 Add Your Response Recent Blog Comments Marching Band Database Payroll Database in Microsoft

  • Medical Clinic Database

    Updated: 2010-01-10 13:32:37
    Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Medical Clinic Database Sunday January 10, 2010 In a recent forum message John wrote : Hello all . I am new to this forum . Thank you in advance for your responses . I am volunteering at a Free Medical Clinic and we currently keep our records as hard copies . I want to develop a database to transfer patient information . Does anybody have a template that I could work from . The primary reason we want to switch to an electronic system is for grant writing purposes . I would like to be able to query patient symptom demographic information easily . Currently , our volunteers process this information by hand and it is very time consuming . Can you help John Interested in solutions to the same problem Visit the About Databases forum and join the discussion Comments 1 See All Posts Share Prev Next Leave a Comment Comments January 19, 2010 at 7:21 am 1 KansasCoder : says My company recently reviewed a

  • Updating our disclosures

    Updated: 2010-01-06 05:49:38
    From time to time a blogger should make disclosures about sources of income and other potential influences.  Fortunately, I’ve covered most of them in the past. The generalities I posted a few years ago still apply (and, I think, are a good read in any case about the realities of analyst coverage). The updates a year and [...]

  • PocketBase for iPhone Just Released for QuickBase

    Updated: 2010-01-05 02:32:54
    There is a new iPhone application in the iTunes Store called PocketBase. What is noteworthy about this application is that it works natively with QuickBase. Instead of accessing QuickBase via the iPhone’s web browser, MCF Tech has leveraged QuickBase’s API to present QuickBase applications with native iPhone functionality. Don Larson, founder [...]

  • Twitter Weekly Updates for 2010-01-03

    Updated: 2010-01-03 23:23:00
    DB Geek says: Twitter Weekly Updates for 2009-12-27: <!– google_ad_client = "pub-4372398370642959"; /* 468×60, cre… http://bit.ly/7vxWyl # Blogged "2009 : The Oracle Year in Review – Part 2" http://it.toolbox.com/trd/46/2/36072/3 # Just got fios 25/15 + HD Extreme. Verizon showed up with a wireless router, G not N, secured with WEP even though it's capable of WPA2. WTF? # Anyone know [...]

Last Months Items